Thread: Installing PostgreSQL 7.3.1 on windows 2000
I am trying to install the alpha version og pgsql 7.3.1 available at http://techdocs.postgresql.org/guides/InstallingOnWindows on windows 2000. The installation proceeds smoothly but I have the following problems: 1. At the end of the installation I briefly get the message: Administrator unknown, invalid user. I also did not get a prompt asking for a password. But I do have a user called Administrator in the group Administrators. 2. When I type pg_ctl start on the Pgsql command shell, I get the message: $FATAL: File /data/PG_VERSION is missing. This is not a valid data directory. Would appreciate help. I am trying to understand the use of Pgsql to a fair extent so I can introduce it in an undergraduate elective class here. Thanks Manish _________________________ Manish Agrawal Asstt. Prof., Dept. of ISDS, Univ. of South Florida 4202 E. Fowler Ave., CIS 1040, Tampa, Fl 33620 - 7800 (813)-974-6716 (W) 974-6749 (FAX) magrawal@coba.usf.edu <mailto:magrawal@coba.usf.edu> http://coba.usf.edu/departments/isds/faculty/agrawal/index.html -----Original Message----- From: Jason Tishler [mailto:jason@tishler.net] Sent: Tuesday, February 04, 2003 2:46 PM To: Pablo Pérez Cc: Pgsql-Cygwin Subject: Re: [CYGWIN] question On Tue, Feb 04, 2003 at 12:58:22PM -0600, Pablo Pérez wrote: > how can I post or where You can subscribe to the cygwin list at: http://developer.postgresql.org/mailsub.php To post, send email to <pgsql-cygwin@postgresql.org>. Jason -- PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
Manish,
On Thu, Feb 06, 2003 at 06:13:39PM -0500, Agrawal, Manish wrote:
> 1. At the end of the installation I briefly get the message:
> Administrator unknown, invalid user. I also did not get a prompt
> asking for a password. But I do have a user called Administrator in
> the group Administrators.
The above seems to imply that /etc/passwd and /etc/group were not
created correctly. Does the PgSQL731wina1.exe installer execute the
following?
mkpasswd -l >/etc/passwd
mkgroup -l >/etc/group
> 2. When I type pg_ctl start on the Pgsql command shell, I get the
> message: $FATAL: File /data/PG_VERSION is missing. This is not a valid
> data directory.
The above seems to imply that either PGDATA is not defined correctly or
that initdb was not run. Does the PgSQL731wina1.exe installer do these
steps too?
Jason
--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
Thanks very much Jason. It is indeed important to login as Administrator while installing the windows version of pgsql and the installation was smooth and easy. It would be nice if this was mentioned in the instructions at http://techdocs.postgresql.org/guides/InstallingOnWindows But now I have 2 other problems. After successful installation, I accidentally closed the pgsql command window (without stopping pgsql) to download and install pgadmin. As a result: (a) My computer shut down (b) I cannot restart pgsql. The error message is attached as an image to this email. Would appreciate help in restarting pgsql. Thanks Manish Agrawal, Manish wrote: > I am trying to install the alpha version og pgsql 7.3.1 available at > http://techdocs.postgresql.org/guides/InstallingOnWindows on windows > 2000. The installation proceeds smoothly but I have the following > problems: > > 1. At the end of the installation I briefly get the message: > Administrator unknown, invalid user. I also did not get a prompt > asking for a password. But I do have a user called Administrator in > the group Administrators. Hi Manish, It sounds like you didn't install this when logged in as Administrator. When it initialises the database as part of the installation process, it creates a PostgreSQL superuser with the same name as whatever user you installed it as. What you're getting is the PostgreSQL error message say that it's never heard of the user "Administrator", because it was initialised from a different user account. It's probably best if you uninstall it, then log in as Administrator and install it again. That _should_ (in theory) work. > 2. When I type pg_ctl start on the Pgsql command shell, I get the > message: > $FATAL: File /data/PG_VERSION is missing. This is not a valid data > directory. > > Would appreciate help. I am trying to understand the use of Pgsql to a > fair extent so I can introduce it in an undergraduate elective class > here. Wow. The present behaviour in the Alpha 1 release is going to change a fair bit for the official release of PostgreSQL with windows support (PostgreSQL 7.4). If might be better to use the PeerDirect version, although you won't have Schema support. Regards and best wishes, Justin Clift > Thanks > Manish -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi
Attachment
Manish,
On Fri, Feb 07, 2003 at 03:03:44PM -0500, Agrawal, Manish wrote:
> I accidentally closed the pgsql command window (without stopping
> pgsql) to download and install pgadmin. As a result:
> (a) My computer shut down
Hmm...
> (b) I cannot restart pgsql.
Try the following:
$ net stop ipc-daemon
$ rm -fr /tmp/cygipc_* /tmp/MultiFile*
$ net start ipc-daemon
$ pg_ctl start
> The error message is attached as an image to this email.
Next time please cut and paste your error messages as text. Remember,
the goal is to make it as easy as possible for someone to help.
Jason
--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
Thanks Jason,
I have accidently shut down pgsql on Windows 2000 by closing the
Command shell (this installation was the native Windows 2000 port of pgsql
7.3.1). Now I am unable to restart
> (b) I cannot restart pgsql.
Try the following:
$ net stop ipc-daemon
$ rm -fr /tmp/cygipc_* /tmp/MultiFile*
$ net start ipc-daemon
$ pg_ctl start
I tried these, but the error message is the same:
Administrator@COBA-MAGRAWAL
$ pg_ctl start
pg_ctl: Another postmaster may be running. Trying to start postmaster
anyway. Found a pre-existing shared memory block (Key 5432001, id 0) still
in use. If you're sure there are no old backends still running, remove the
shared memory block with ipcrm(1), or just delete "/data/postmaster.pid".
pg_ctl: cannot start postmaster
Examine the log output.
When I do
$delete "/data/postmaster.pid" I get
bash: delete: command not found
When I do
$ipcrm(1) I get
bash: syntax error near unexpected token '1'
Can I get help in (1) getting pgsql restarted and (2) viewing the log
output.
Thanks
Manish