pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jim C. Nasby <jim@nasby.net>
To: Ravindran G - TLS, Chennai. <ravindran_g@hcl.in>
Cc: pgsql-general@postgresql.org, "Hari Krishna D - TLS , Chennai" <harikrishnad@hcl.in>
Cc: Sasikala V - TLS , Chennai <sasikalav@hcl.in>
Subject: Re: [PERFORM] Postgre 8.0 Installation - Issues
Date: Tue, 10 Oct 2006 09:15:52 -0500
Message-ID: <20061010141552.GC72517@nasby.net> (raw)
In-Reply-To: <012301731C23DE4DBFE035647C68F1CC041879E6@sindhu.ctd.hcltech.com>
References: <012301731C23DE4DBFE035647C68F1CC041879E6@sindhu.ctd.hcltech.com>

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)



view thread (12+ messages)  latest in thread

Message-ID: <20061010141552.GC72517@nasby.net>
Permalink:  ../20061010141552.GC72517@nasby.net/
Also on:    postgresql.org/message-id/20061010141552.GC72517@nasby.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: jim@nasby.net, ravindran_g@hcl.in, harikrishnad@hcl.in, sasikalav@hcl.in
  Subject: Re: [PERFORM] Postgre 8.0 Installation - Issues
  In-Reply-To: <20061010141552.GC72517@nasby.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox