Обсуждение: 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

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