From: | "Andrei Bintintan" <klodoma(at)ar-sd(dot)net> |
---|---|
To: | "Loyiso Tyira - BCX - Networks" <Loyiso(dot)Tyira(at)bcx(dot)co(dot)za>, <pgsql-cygwin(at)postgresql(dot)org> |
Subject: | Re: pgsql instalation |
Date: | 2004-11-08 14:58:51 |
Message-ID: | 00a801c4c5a3$76e4e530$0b00a8c0@forge |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-cygwin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Klint Gore | 2004-11-16 07:46:58 | 7.4.5 FAQ_MSWIN still refers to ipc-daemon2 |
Previous Message | Leeuw van der, Tim | 2004-11-08 14:48:04 | Re: pgsql instalation |