Postgre 8.0 Installation - Issues

Started by Ravindran G - TLS, Chennai.over 19 years ago18 messagesgeneral
Jump to latest

All,

We are facing few issues while we install Postgres 8.0 in Windows 2000
Japanese OS. Installer kit name : postgresql-8.0-ja

Scenario 1: While installing PostGRE 8.0, we got an logon failure at the end
of installing the component telling that it failed to produce the process
for initdb and also that the user name was not able to be recognized or the
password is wrong. After the OK button was clicked the whole process rolled
back automatically and the PostGRE got uninstalled.

Scenario 2: In one of the computers we managed to install the PostGRE 8.0
but the database initialization could not be performed. While creating the
database using the Credb patch we got an error telling that the tables were
missing and the connection with the local host failed.

Scenario 3: For one of the machines the database has also been created but
once the system is restarted the PostGRE does not work and we get the same
error as in the Scenario2.

Please shed some light on this. If this question is not relevant to this
group, please redirect us...

Thanks and regards,
Ravi
DISCLAIMER
The contents of this e-mail and any attachment(s) are confidential and intended for the

named recipient(s) only. It shall not attach any liability on the originator or HCL or its

affiliates. Any views or opinions presented in this email are solely those of the author and

may not necessarily reflect the opinions of HCL or its affiliates. Any form of reproduction,

dissemination, copying, disclosure, modification, distribution and / or publication of this

message without the prior written consent of the author of this e-mail is strictly

prohibited. If you have received this email in error please delete it and notify the sender

immediately. Before opening any mail and attachments please check them for viruses and

defect.

#2Jim Nasby
Jim.Nasby@BlueTreble.com
In reply to: Ravindran G - TLS, Chennai. (#1)
Re: [PERFORM] Postgre 8.0 Installation - Issues

Moving to -general.

On Tue, Oct 10, 2006 at 04:17:06PM +0530, Ravindran G - TLS, Chennai. wrote:

All,

We are facing few issues while we install Postgres 8.0 in Windows 2000
Japanese OS. Installer kit name : postgresql-8.0-ja

Is there a reason you're not using 8.1.4? 8.0 was the first windows
release, and as such there's a number of issues that were improved in
8.1. You should at least be using the latest 8.0 version (8.0.8).

Scenario 1: While installing PostGRE 8.0, we got an logon failure at the end

BTW, it's PostgreSQL or Postgres. PostGRE doesn't exist...

of installing the component telling that it failed to produce the process
for initdb and also that the user name was not able to be recognized or the
password is wrong. After the OK button was clicked the whole process rolled
back automatically and the PostGRE got uninstalled.

Make sure that you have the right password for the account that
PostgreSQL will be running under. I often find it's easiest to just
delete that account and let the installer create it for me.

Scenario 2: In one of the computers we managed to install the PostGRE 8.0
but the database initialization could not be performed. While creating the
database using the Credb patch we got an error telling that the tables were
missing and the connection with the local host failed.

Scenario 3: For one of the machines the database has also been created but
once the system is restarted the PostGRE does not work and we get the same
error as in the Scenario2.

These could be issues surrounding administrator rights. PostgreSQL will
refuse to start if the account it's running under has Administrator
rights.

Please shed some light on this. If this question is not relevant to this
group, please redirect us...

Thanks and regards,
Ravi
DISCLAIMER
The contents of this e-mail and any attachment(s) are confidential and intended for the

named recipient(s) only. It shall not attach any liability on the originator or HCL or its

affiliates. Any views or opinions presented in this email are solely those of the author and

may not necessarily reflect the opinions of HCL or its affiliates. Any form of reproduction,

dissemination, copying, disclosure, modification, distribution and / or publication of this

message without the prior written consent of the author of this e-mail is strictly

prohibited. If you have received this email in error please delete it and notify the sender

immediately. Before opening any mail and attachments please check them for viruses and

defect.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

In reply to: Jim Nasby (#2)
Re: [PERFORM] Postgre 8.0 Installation - Issues

Thanks for your comments and moving it to general group.

We would like to know which is the most stable version in Postgresql ?.
Because Postgresql may undergo changes and will have the version
incremented. In this case, do we need to do the upgrade frequently ?. Of
course, its good have the latest version but this cannot be done each and
every time after deploying our application to end customers.

Please advise.

Regards, Ravi

-----Original Message-----
From: Jim C. Nasby [mailto:jim@nasby.net]
Sent: Tuesday, October 10, 2006 7:46 PM
To: Ravindran G - TLS, Chennai.
Cc: pgsql-general@postgresql.org; Hari Krishna D - TLS , Chennai; Sasikala V
- TLS , Chennai
Subject: Re: [PERFORM] Postgre 8.0 Installation - Issues

Moving to -general.

On Tue, Oct 10, 2006 at 04:17:06PM +0530, Ravindran G - TLS, Chennai. wrote:

All,

We are facing few issues while we install Postgres 8.0 in Windows 2000
Japanese OS. Installer kit name : postgresql-8.0-ja

Is there a reason you're not using 8.1.4? 8.0 was the first windows
release, and as such there's a number of issues that were improved in
8.1. You should at least be using the latest 8.0 version (8.0.8).

Scenario 1: While installing PostGRE 8.0, we got an logon failure at the

end

BTW, it's PostgreSQL or Postgres. PostGRE doesn't exist...

of installing the component telling that it failed to produce the process
for initdb and also that the user name was not able to be recognized or

the

password is wrong. After the OK button was clicked the whole process

rolled

back automatically and the PostGRE got uninstalled.

Make sure that you have the right password for the account that
PostgreSQL will be running under. I often find it's easiest to just
delete that account and let the installer create it for me.

Scenario 2: In one of the computers we managed to install the PostGRE 8.0
but the database initialization could not be performed. While creating the
database using the Credb patch we got an error telling that the tables

were

missing and the connection with the local host failed.

Scenario 3: For one of the machines the database has also been created but
once the system is restarted the PostGRE does not work and we get the same
error as in the Scenario2.

These could be issues surrounding administrator rights. PostgreSQL will
refuse to start if the account it's running under has Administrator
rights.

Please shed some light on this. If this question is not relevant to this
group, please redirect us...

Thanks and regards,
Ravi
DISCLAIMER
The contents of this e-mail and any attachment(s) are confidential and

intended for the

named recipient(s) only. It shall not attach any liability on the

originator or HCL or its

affiliates. Any views or opinions presented in this email are solely those

of the author and

may not necessarily reflect the opinions of HCL or its affiliates. Any

form of reproduction,

dissemination, copying, disclosure, modification, distribution and / or

publication of this

message without the prior written consent of the author of this e-mail is

strictly

prohibited. If you have received this email in error please delete it and

notify the sender

immediately. Before opening any mail and attachments please check them for

viruses and

defect.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

#4Joshua D. Drake
jd@commandprompt.com
In reply to: Jim Nasby (#2)
Re: [PERFORM] Postgre 8.0 Installation - Issues

Scenario 1: While installing PostGRE 8.0, we got an logon failure at the end

BTW, it's PostgreSQL or Postgres. PostGRE doesn't exist...

You know, every time someone brings this up it reminds me of:

Are you Josh or Joshua...

It doesn't matter people.

Joshua D. Drake

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

#5Bill Moran
wmoran@collaborativefusion.com
In reply to: Joshua D. Drake (#4)
Re: [PERFORM] Postgre 8.0 Installation - Issues

In response to "Joshua D. Drake" <jd@commandprompt.com>:

Scenario 1: While installing PostGRE 8.0, we got an logon failure at the end

BTW, it's PostgreSQL or Postgres. PostGRE doesn't exist...

You know, every time someone brings this up it reminds me of:

Are you Josh or Joshua...

It doesn't matter people.

To some it does. I've had a number of people ask me whether I want
Bill, William, or Will. The first two are fine, I prefer that the
third not be used.

I had an almost-gf once who was introduced to me as Patricia. I asked
if she went by Pat or Patty. She responded, "Not if you want to live."
I called her Tricia.

--
Bill Moran
Collaborative Fusion Inc.

#6A.M.
agentm@themactionfaction.com
In reply to: Bill Moran (#5)
Re: [PERFORM] Postgre 8.0 Installation - Issues

On Oct 10, 2006, at 10:34 , Bill Moran wrote:

I had an almost-gf once...

Me too!

-M

#7Joshua D. Drake
jd@commandprompt.com
In reply to: Bill Moran (#5)
Re: [PERFORM] Postgre 8.0 Installation - Issues

Bill Moran wrote:

In response to "Joshua D. Drake" <jd@commandprompt.com>:

Scenario 1: While installing PostGRE 8.0, we got an logon failure at the end

BTW, it's PostgreSQL or Postgres. PostGRE doesn't exist...

You know, every time someone brings this up it reminds me of:

Are you Josh or Joshua...

It doesn't matter people.

To some it does. I've had a number of people ask me whether I want
Bill, William, or Will. The first two are fine, I prefer that the
third not be used.

I had an almost-gf once who was introduced to me as Patricia. I asked
if she went by Pat or Patty. She responded, "Not if you want to live."
I called her Tricia.

You can not compare the intricacies of the woman psyche to that of
software naming ;).

I get your point but when someone is asking for help, if the first thing
you do is correct them on something so minimal that has nothing to do
with their problem.... It sends a negative vibe.

Sincerely,

Joshua D. Drake

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

#8Dave Page
dpage@pgadmin.org
In reply to: Joshua D. Drake (#4)
Re: [PERFORM] Postgre 8.0 Installation - Issues

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of
Joshua D. Drake
Sent: 10 October 2006 15:28
To: Jim C. Nasby
Cc: Ravindran G - TLS, Chennai.;
pgsql-general@postgresql.org; Hari Krishna D - TLS , Chennai;
Sasikala V - TLS , Chennai
Subject: Re: [GENERAL] [PERFORM] Postgre 8.0 Installation - Issues

Scenario 1: While installing PostGRE 8.0, we got an logon

failure at the end

BTW, it's PostgreSQL or Postgres. PostGRE doesn't exist...

You know, every time someone brings this up it reminds me of:

Are you Josh or Joshua...

It doesn't matter people.

That reminds me Bob - did you see my email about Stefan's pmt account?

:-p

/D

#9Bill Moran
wmoran@collaborativefusion.com
In reply to: Joshua D. Drake (#7)
Re: [PERFORM] Postgre 8.0 Installation - Issues

In response to "Joshua D. Drake" <jd@commandprompt.com>:

Bill Moran wrote:

In response to "Joshua D. Drake" <jd@commandprompt.com>:

Scenario 1: While installing PostGRE 8.0, we got an logon failure at the end

BTW, it's PostgreSQL or Postgres. PostGRE doesn't exist...

You know, every time someone brings this up it reminds me of:

Are you Josh or Joshua...

It doesn't matter people.

To some it does. I've had a number of people ask me whether I want
Bill, William, or Will. The first two are fine, I prefer that the
third not be used.

I had an almost-gf once who was introduced to me as Patricia. I asked
if she went by Pat or Patty. She responded, "Not if you want to live."
I called her Tricia.

You can not compare the intricacies of the woman psyche to that of
software naming ;).

:)

I get your point but when someone is asking for help, if the first thing
you do is correct them on something so minimal that has nothing to do
with their problem.... It sends a negative vibe.

I suppose. On many mailing lists that I frequent, the first response a
new poster gets is something along the lines of, "please don't top-post"
or "please fix your email formatting."

These could be taken as "negative vibe" and have often been complained
about by newbies. I claim that they're an indication that we have some
actual culture, and that it's a manifestation of the desire to maintain
that culture. I find the complaints to be a manifestation of inconsiderate
people who don't respect the culture of others.

It's also possible that I just think about this stuff too much.

--
Bill Moran
Collaborative Fusion Inc.

#10Joshua D. Drake
jd@commandprompt.com
In reply to: Dave Page (#8)
Re: [PERFORM] Postgre 8.0 Installation - Issues

Dave Page wrote:

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of
Joshua D. Drake
Sent: 10 October 2006 15:28
To: Jim C. Nasby
Cc: Ravindran G - TLS, Chennai.;
pgsql-general@postgresql.org; Hari Krishna D - TLS , Chennai;
Sasikala V - TLS , Chennai
Subject: Re: [GENERAL] [PERFORM] Postgre 8.0 Installation - Issues

Scenario 1: While installing PostGRE 8.0, we got an logon

failure at the end

BTW, it's PostgreSQL or Postgres. PostGRE doesn't exist...

You know, every time someone brings this up it reminds me of:

Are you Josh or Joshua...

It doesn't matter people.

That reminds me Bob - did you see my email about Stefan's pmt account?

*sigh* how many times must I remind you... it is Bobby not Bob...

And, I appear to have missed it.. I will get it setup.

Joshua D. Drake

:-p

/D

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

#11Joshua D. Drake
jd@commandprompt.com
In reply to: Bill Moran (#9)
Re: [PERFORM] Postgre 8.0 Installation - Issues

It's also possible that I just think about this stuff too much.

Give this guy a cookie. :)

Joshua D. Drake

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

#12Dave Page
dpage@pgadmin.org
In reply to: Joshua D. Drake (#10)
Re: [PERFORM] Postgre 8.0 Installation - Issues

-----Original Message-----
From: Joshua D. Drake [mailto:jd@commandprompt.com]
Sent: 10 October 2006 17:11
To: Dave Page
Cc: Jim C. Nasby; pgsql-general@postgresql.org
Subject: Re: [GENERAL] [PERFORM] Postgre 8.0 Installation - Issues

That reminds me Bob - did you see my email about Stefan's

pmt account?

*sigh* how many times must I remind you... it is Bobby not Bob...

And, I appear to have missed it.. I will get it setup.

Thanks Rob.

/D

#13Jim Nasby
Jim.Nasby@BlueTreble.com
In reply to: Ravindran G - TLS, Chennai. (#3)
Re: [PERFORM] Postgre 8.0 Installation - Issues

PostgreSQL doesn't really have any unstable versions (unless you're
talking about code right out of CVS). The closest you might come will
be the initial release of a major version, or of course a beta/
release candidate. (Note that the first "dot" indicates a major
version for PostgreSQL. 8.0 is a major version, as is 8.1). But even
our betas are generally very solid and stable. If you're looking for
the utmost in stability, you probably want to go with 8.1.4 (or
8.1.5, which should be out RSN).

What does happen from time-to-time is a complex bug (usually some
kind of a race condition) that has the potential to corrupt data will
be discovered. These are generally very hard to reproduce, and
usually go back a number of major versions. This is why it's
important to update to newer minor versions (ie: 8.1.3 to 8.1.4) when
they come out.

Another issue you'll be facing is that windows support is fairly new;
8.0 was the first release that had it. So the performance of the
windows version has been getting better, and some minor bugs are
still being found and fixed.

I know that may sound a bit scary, but the truth is it's no different
for commercial databases; they just hide it from you.

Of course, unless you've discovered some magic process for producing
bug-free code, you'll undoubtedly have to send out bug fixes for your
product as well. ;) It's very painless to do a minor version upgrade
of PostgreSQL, so it makes sense to include that with the updates you
send out for your product.

On Oct 10, 2006, at 9:27 AM, Ravindran G - TLS, Chennai. wrote:

Thanks for your comments and moving it to general group.

We would like to know which is the most stable version in
Postgresql ?.
Because Postgresql may undergo changes and will have the version
incremented. In this case, do we need to do the upgrade
frequently ?. Of
course, its good have the latest version but this cannot be done
each and
every time after deploying our application to end customers.

Please advise.

Regards, Ravi

-----Original Message-----
From: Jim C. Nasby [mailto:jim@nasby.net]
Sent: Tuesday, October 10, 2006 7:46 PM
To: Ravindran G - TLS, Chennai.
Cc: pgsql-general@postgresql.org; Hari Krishna D - TLS , Chennai;
Sasikala V
- TLS , Chennai
Subject: Re: [PERFORM] Postgre 8.0 Installation - Issues

Moving to -general.

On Tue, Oct 10, 2006 at 04:17:06PM +0530, Ravindran G - TLS,
Chennai. wrote:

All,

We are facing few issues while we install Postgres 8.0 in Windows
2000
Japanese OS. Installer kit name : postgresql-8.0-ja

Is there a reason you're not using 8.1.4? 8.0 was the first windows
release, and as such there's a number of issues that were improved in
8.1. You should at least be using the latest 8.0 version (8.0.8).

Scenario 1: While installing PostGRE 8.0, we got an logon failure
at the

end

BTW, it's PostgreSQL or Postgres. PostGRE doesn't exist...

of installing the component telling that it failed to produce the
process
for initdb and also that the user name was not able to be
recognized or

the

password is wrong. After the OK button was clicked the whole process

rolled

back automatically and the PostGRE got uninstalled.

Make sure that you have the right password for the account that
PostgreSQL will be running under. I often find it's easiest to just
delete that account and let the installer create it for me.

Scenario 2: In one of the computers we managed to install the
PostGRE 8.0
but the database initialization could not be performed. While
creating the
database using the Credb patch we got an error telling that the
tables

were

missing and the connection with the local host failed.

Scenario 3: For one of the machines the database has also been
created but
once the system is restarted the PostGRE does not work and we get
the same
error as in the Scenario2.

These could be issues surrounding administrator rights. PostgreSQL
will
refuse to start if the account it's running under has Administrator
rights.

Please shed some light on this. If this question is not relevant
to this
group, please redirect us...

Thanks and regards,
Ravi
DISCLAIMER
The contents of this e-mail and any attachment(s) are confidential
and

intended for the

named recipient(s) only. It shall not attach any liability on the

originator or HCL or its

affiliates. Any views or opinions presented in this email are
solely those

of the author and

may not necessarily reflect the opinions of HCL or its affiliates.
Any

form of reproduction,

dissemination, copying, disclosure, modification, distribution
and / or

publication of this

message without the prior written consent of the author of this e-
mail is

strictly

prohibited. If you have received this email in error please delete
it and

notify the sender

immediately. Before opening any mail and attachments please check
them for

viruses and

defect.

---------------------------(end of
broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

---------------------------(end of
broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

#14Jim Nasby
Jim.Nasby@BlueTreble.com
In reply to: Joshua D. Drake (#4)
Re: [PERFORM] Postgre 8.0 Installation - Issues

On Oct 10, 2006, at 9:28 AM, Joshua D. Drake wrote:

Scenario 1: While installing PostGRE 8.0, we got an logon failure
at the end

BTW, it's PostgreSQL or Postgres. PostGRE doesn't exist...

You know, every time someone brings this up it reminds me of:

Are you Josh or Joshua...

It doesn't matter people.

On the other hand Fred, I see about a dozen emails about how our name
doesn't matter and not one actually answering Ravindran's question...
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

In reply to: Jim Nasby (#14)
Re: [PERFORM] Postgre 8.0 Installation - Issues

Thanks for you detail mail on this. We will look into 8.1.4 and start using
it.

Meanwhile, we would like to know about this error.

When I start PostgreSQL service, the below error message is displayed and
finally service didn't started.

The PostgreSQL Database Server 8.0 service of a local computer cannot begin.

Error 1069: Service was not able to begin because it had failed in logon.

Any idea about this error ?. Hope when we start service it checks for
Windows authentication rather than DB authentication. Not Sure!.

Regards, Ravi

-----Original Message-----
From: Jim Nasby [mailto:jim@nasby.net]
Sent: Wednesday, October 11, 2006 7:29 AM
To: Ravindran G - TLS, Chennai.
Cc: pgsql-general@postgresql.org; Hari Krishna D - TLS , Chennai; Sasikala V
- TLS , Chennai
Subject: Re: [GENERAL] [PERFORM] Postgre 8.0 Installation - Issues

PostgreSQL doesn't really have any unstable versions (unless you're
talking about code right out of CVS). The closest you might come will
be the initial release of a major version, or of course a beta/
release candidate. (Note that the first "dot" indicates a major
version for PostgreSQL. 8.0 is a major version, as is 8.1). But even
our betas are generally very solid and stable. If you're looking for
the utmost in stability, you probably want to go with 8.1.4 (or
8.1.5, which should be out RSN).

What does happen from time-to-time is a complex bug (usually some
kind of a race condition) that has the potential to corrupt data will
be discovered. These are generally very hard to reproduce, and
usually go back a number of major versions. This is why it's
important to update to newer minor versions (ie: 8.1.3 to 8.1.4) when
they come out.

Another issue you'll be facing is that windows support is fairly new;
8.0 was the first release that had it. So the performance of the
windows version has been getting better, and some minor bugs are
still being found and fixed.

I know that may sound a bit scary, but the truth is it's no different
for commercial databases; they just hide it from you.

Of course, unless you've discovered some magic process for producing
bug-free code, you'll undoubtedly have to send out bug fixes for your
product as well. ;) It's very painless to do a minor version upgrade
of PostgreSQL, so it makes sense to include that with the updates you
send out for your product.

On Oct 10, 2006, at 9:27 AM, Ravindran G - TLS, Chennai. wrote:

Thanks for your comments and moving it to general group.

We would like to know which is the most stable version in
Postgresql ?.
Because Postgresql may undergo changes and will have the version
incremented. In this case, do we need to do the upgrade
frequently ?. Of
course, its good have the latest version but this cannot be done
each and
every time after deploying our application to end customers.

Please advise.

Regards, Ravi

-----Original Message-----
From: Jim C. Nasby [mailto:jim@nasby.net]
Sent: Tuesday, October 10, 2006 7:46 PM
To: Ravindran G - TLS, Chennai.
Cc: pgsql-general@postgresql.org; Hari Krishna D - TLS , Chennai;
Sasikala V
- TLS , Chennai
Subject: Re: [PERFORM] Postgre 8.0 Installation - Issues

Moving to -general.

On Tue, Oct 10, 2006 at 04:17:06PM +0530, Ravindran G - TLS,
Chennai. wrote:

All,

We are facing few issues while we install Postgres 8.0 in Windows
2000
Japanese OS. Installer kit name : postgresql-8.0-ja

Is there a reason you're not using 8.1.4? 8.0 was the first windows
release, and as such there's a number of issues that were improved in
8.1. You should at least be using the latest 8.0 version (8.0.8).

Scenario 1: While installing PostGRE 8.0, we got an logon failure
at the

end

BTW, it's PostgreSQL or Postgres. PostGRE doesn't exist...

of installing the component telling that it failed to produce the
process
for initdb and also that the user name was not able to be
recognized or

the

password is wrong. After the OK button was clicked the whole process

rolled

back automatically and the PostGRE got uninstalled.

Make sure that you have the right password for the account that
PostgreSQL will be running under. I often find it's easiest to just
delete that account and let the installer create it for me.

Scenario 2: In one of the computers we managed to install the
PostGRE 8.0
but the database initialization could not be performed. While
creating the
database using the Credb patch we got an error telling that the
tables

were

missing and the connection with the local host failed.

Scenario 3: For one of the machines the database has also been
created but
once the system is restarted the PostGRE does not work and we get
the same
error as in the Scenario2.

These could be issues surrounding administrator rights. PostgreSQL
will
refuse to start if the account it's running under has Administrator
rights.

Please shed some light on this. If this question is not relevant
to this
group, please redirect us...

Thanks and regards,
Ravi
DISCLAIMER
The contents of this e-mail and any attachment(s) are confidential
and

intended for the

named recipient(s) only. It shall not attach any liability on the

originator or HCL or its

affiliates. Any views or opinions presented in this email are
solely those

of the author and

may not necessarily reflect the opinions of HCL or its affiliates.
Any

form of reproduction,

dissemination, copying, disclosure, modification, distribution
and / or

publication of this

message without the prior written consent of the author of this e-
mail is

strictly

prohibited. If you have received this email in error please delete
it and

notify the sender

immediately. Before opening any mail and attachments please check
them for

viruses and

defect.

---------------------------(end of
broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

---------------------------(end of
broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

#16Jim Nasby
Jim.Nasby@BlueTreble.com
In reply to: Ravindran G - TLS, Chennai. (#15)
Windows install problem (was: Postgre 8.0 Installation - Issues)

On Wed, Oct 11, 2006 at 01:32:29PM +0530, Ravindran G - TLS, Chennai. wrote:

When I start PostgreSQL service, the below error message is displayed and
finally service didn't started.

The PostgreSQL Database Server 8.0 service of a local computer cannot begin.

Error 1069: Service was not able to begin because it had failed in logon.

Any idea about this error ?. Hope when we start service it checks for
Windows authentication rather than DB authentication. Not Sure!.

Hrm... certainly looks like a windows authentication issue. Hopefully
someone else here can help, 'cause I don't know much about that. You
might try searching the source code too...
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

#17Merlin Moncure
mmoncure@gmail.com
In reply to: Jim Nasby (#16)
Re: Windows install problem (was: Postgre 8.0 Installation - Issues)

On 10/12/06, Jim C. Nasby <jim@nasby.net> wrote:

On Wed, Oct 11, 2006 at 01:32:29PM +0530, Ravindran G - TLS, Chennai. wrote:

When I start PostgreSQL service, the below error message is displayed and
finally service didn't started.

The PostgreSQL Database Server 8.0 service of a local computer cannot begin.

Error 1069: Service was not able to begin because it had failed in logon.

Any idea about this error ?. Hope when we start service it checks for
Windows authentication rather than DB authentication. Not Sure!.

Hrm... certainly looks like a windows authentication issue. Hopefully
someone else here can help, 'cause I don't know much about that. You
might try searching the source code too...

is this a fresh installation?

the service was unable to login to the computer box. one way this
happens is password expiration on the account. there are other things
tho. more information would be helpful.

merlin

#18Oisin Glynn
me@oisinglynn.com
In reply to: Merlin Moncure (#17)
Re: Windows install problem

Merlin Moncure wrote:

On 10/12/06, Jim C. Nasby <jim@nasby.net> wrote:

On Wed, Oct 11, 2006 at 01:32:29PM +0530, Ravindran G - TLS, Chennai.
wrote:

When I start PostgreSQL service, the below error message is

displayed and

finally service didn't started.

The PostgreSQL Database Server 8.0 service of a local computer

cannot begin.

Error 1069: Service was not able to begin because it had failed in

logon.

Any idea about this error ?. Hope when we start service it checks for
Windows authentication rather than DB authentication. Not Sure!.

Hrm... certainly looks like a windows authentication issue. Hopefully
someone else here can help, 'cause I don't know much about that. You
might try searching the source code too...

is this a fresh installation?

the service was unable to login to the computer box. one way this
happens is password expiration on the account. there are other things
tho. more information would be helpful.

merlin

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Or I have been sucker punched by the user must change password setting
on the account created by the install.

Oisin