Re: pgsql instalation

don't use ipc-daemon!!!!!!!!!!! it is deprecated.

Check the postgresql-7.4.3.README manual!!!! in /usr/share/doc/cygwin.

Look at the point 6.1. That solved my problems.

1. Install and configure cygserver as a NT service:

# cygserver-config

2. Create the "postgres" user account:

# net user postgres $password /add /fullname:postgres /comment:'PostgreSQL user account' /homedir:"$(cygpath -w /home/postgres)" # [11]
# mkpasswd -l -u postgres >>/etc/passwd

3. Grant the "postgres" user the "Log on as a service" user right:

# cmd /c secpol.msc # [3] [4] [5] [12]

4. Install postmaster as a NT service:

# cygrunsrv --install postmaster --path /usr/bin/postmaster --args "-D /var/postgresql/data -i" --dep cygserver --termsig INT --user postgres --shutdown # [6]

5. Create the PostgreSQL data directory:

# mkdir -p /var/postgresql/data

6. Change ownership of the PostgreSQL data directory:

# chown postgres /var/postgresql/data # [10]

6.1

$ chmod a+rwx /tmp
$ chmod a+rx /usr/bin /usr/bin/*
$ chmod a+rw /var/log # could adversely affect other daemons

and

Regardless of the installation type, the first step is to add "server" to
your CYGWIN environment variable setting and start cygserver.

7. Start cygserver:

# cygrunsrv -S cygserver # [7]

8. Initialize PostgreSQL (*when running under the "postgres" account*):

$ initdb -D /var/postgresql/data

9. Start postmaster:

# cygrunsrv -S postmaster # [7]

10. Verify postmaster is running:

# cygrunsrv -Q postmaster [13]

11. Connect to PostgreSQL:

# psql -U postgres template1 # [8] [9]

Best regards,
Andy.
----- Original Message -----
From: Loyiso Tyira - BCX - Networks
To: pgsql-cygwin(at)postgresql(dot)org
Sent: Monday, November 08, 2004 4:28 PM
Subject: [CYGWIN] pgsql instalation

> I am trying to install posgresql on cygwin on XP. I have installed postgesql

> and cygipc. Did the following steps

> 1. $ ipc-daemon&

> 2. $ mkdir /whatever/path/pgsql

> 3. $ initdb -D /whatever/path/pgsql

> 4. $ pg_ctl -D /whatever/path/pgsql -o "-i" start

5. $ createdb testdb

>

> But step 3 fails in the end.

> Can anyone help

Kind Regards,
Loyiso Tyira
Networks