Re: pgsql instalation
| От | Andrei Bintintan |
|---|---|
| Тема | Re: pgsql instalation |
| Дата | |
| Msg-id | 00a801c4c5a3$76e4e530$0b00a8c0@forge обсуждение исходный текст |
| Ответ на | pgsql instalation ("Loyiso Tyira - BCX - Networks" <Loyiso.Tyira@bcx.co.za>) |
| Список | 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
# 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 по дате отправления: