Re: pgsql instalation
От
Andrei Bintintan
Тема
Re: pgsql instalation
Дата
Msg-id
00a801c4c5a3$76e4e530$0b00a8c0@forge
Список
Дерево обсуждения
Re: pgsql instalation "Leeuw van der, Tim" <tim.leeuwvander@nl.unisys.com>
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
# 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
$ 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.
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 -----Sent: Monday, November 08, 2004 4:28 PMSubject: [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
В списке pgsql-cygwin по дате отправления
