Apache+Postgresql+PHP. reconfigure?

vickr1z · 08-22-2004, 11:16 PM

hello there to all again. im here again ask for help.
i already have installed apache + postgresQL and php into my notebook.
heres my prob. i have set my dir data to /usr/local/pgsql/data by doing tlike this:
editing my /home/postgres.bashrc and appended the following lines

Code:

PGDATA=home/postgres/data
PATH="$PATH:/usr/local/pgsql/bin"

export PGDATA PATH

and issue the command:
/usr/local/pgsql/bin/postmaster -D /home/potgres/data

now i want them(dir data file) to trasfer to '/var/pgsql/data'. i dont know how to do it. can any one show me how to do it step-by-step and nicely?
pls help..

btmiller · 08-23-2004, 01:31 AM

I'm not a PosgreSQL whiz (just started playing with it), but you ought to be able to just move the data directory and change the -D argument to postmaster to reflect the location of the new data directory.

vickr1z · 08-23-2004, 03:58 AM

u mean like this:

PGDATA=/var/pgsql/data
PATH="$PATH:/usr/local/pgsql/bin"