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: [email protected] 
  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