Hi,
I tried to install postgre 7.0 on WinXP.
I got postgre 7.0 binary for NT from postgresql.com.
I installed cygwin.
I started cygipc deamon.
I started cygwin and in $ prompt i write:
The steps i made are:
1)I copy postgresql in f:\pgsql directory
2)mkdir -p /usr/local/pgsql
3)mount -b f:/pgsql /usr/local/pgsql
4)Using an editor i create .bashrc in / directory as belows:
PATH=$PATH:/usr/local/pgsql/bin:/usr/local/bin
PGDATA=/usr/local/pgsql/data
PGLIB=/usr/local/pgsql/lib
LD_LIBRARY_PATH=/usr/local/pgsql/lib:/usr/local/lib
export LD_LIBRARY_PATH PATH PGDATA PGLIB
5)source /.bashrc
6)initdb –D /usr/local/pgsql/data/db –U www
The response was:
invalid option –U
*administrator is Catalin
7)initdb –D /usr/local/pgsql/data/db
executed from path /
The response was:
The database system will be initialized with username “Catalin”
All it’s working fine.
Success. You can nou start the database server using :
/usr/local/pgsql/bin/postmaster –D /usr local/pgsql/db
or
/usr/local/pgsql/bin/pg_ctl –D /usr local/pgsql/db start
8)Edit the file /usr/local/pgsql/data/pg_hba.conf, such as:
host all 127.0.0.1 255.255.255.0 trust
9)ipc-daemon.exe&
10)cd /usr/local/pgsql/bin
11)pg_ctl –D /usr local/pgsql/db start
The response was:
The program postmaster needed by pg_ctl could not be found. It was expected at : ./postmaster
12)create a directory postmaster and copy the postmaster file in it
13)pg_ctl –D /usr local/pgsql/db start
Tre response was
pg_ctl : is seems another postmaster is running.Try to start postmaster anyway
./postmaster:not found
pg_ctl:cannot start postmaster.Is another postmaster is running?
14)Pg_ctl status
Pg_ctl : postmaster is running(pid:6210)
Options are:
/usr/local/pgsql/bin/postmaster
-p 5432
-D /usr/local/pgsql/data
-B 64
-b /usr/local/pgsql/bin/postgres
-i
-N 32
15)Pg_ctl stop
Kill 6210:no such process
Postmaster successfully shut down
My question is:
What dimension must have postmaster? At me is 1K.
What i'm doing wrong?
I tried to install postgre 7.0 on WinXP.
I got postgre 7.0 binary for NT from postgresql.com.
I installed cygwin.
I started cygipc deamon.
I started cygwin and in $ prompt i write:
The steps i made are:
1)I copy postgresql in f:\pgsql directory
2)mkdir -p /usr/local/pgsql
3)mount -b f:/pgsql /usr/local/pgsql
4)Using an editor i create .bashrc in / directory as belows:
PATH=$PATH:/usr/local/pgsql/bin:/usr/local/bin
PGDATA=/usr/local/pgsql/data
PGLIB=/usr/local/pgsql/lib
LD_LIBRARY_PATH=/usr/local/pgsql/lib:/usr/local/lib
export LD_LIBRARY_PATH PATH PGDATA PGLIB
5)source /.bashrc
6)initdb –D /usr/local/pgsql/data/db –U www
The response was:
invalid option –U
*administrator is Catalin
7)initdb –D /usr/local/pgsql/data/db
executed from path /
The response was:
The database system will be initialized with username “Catalin”
All it’s working fine.
Success. You can nou start the database server using :
/usr/local/pgsql/bin/postmaster –D /usr local/pgsql/db
or
/usr/local/pgsql/bin/pg_ctl –D /usr local/pgsql/db start
8)Edit the file /usr/local/pgsql/data/pg_hba.conf, such as:
host all 127.0.0.1 255.255.255.0 trust
9)ipc-daemon.exe&
10)cd /usr/local/pgsql/bin
11)pg_ctl –D /usr local/pgsql/db start
The response was:
The program postmaster needed by pg_ctl could not be found. It was expected at : ./postmaster
12)create a directory postmaster and copy the postmaster file in it
13)pg_ctl –D /usr local/pgsql/db start
Tre response was
pg_ctl : is seems another postmaster is running.Try to start postmaster anyway
./postmaster:not found
pg_ctl:cannot start postmaster.Is another postmaster is running?
14)Pg_ctl status
Pg_ctl : postmaster is running(pid:6210)
Options are:
/usr/local/pgsql/bin/postmaster
-p 5432
-D /usr/local/pgsql/data
-B 64
-b /usr/local/pgsql/bin/postgres
-i
-N 32
15)Pg_ctl stop
Kill 6210:no such process
Postmaster successfully shut down
My question is:
What dimension must have postmaster? At me is 1K.
What i'm doing wrong?