Обсуждение: How to move the ...
I have just installed PostgreSQL (postgresql-8.0.1.zip) on a Windows 2K Prof platform. but the the default Database Dir is in C:\Program Files\PostgreSQL\8.0\data can I move the default Database ex: D:\DataPG\ where can i set it?? Thank You for all your kind for reading my bad english email Dedy Styawan Semarang - Central Java Indonesia | . . |L /| . _ . |\ _| \--+._/| . / ||\| Y J ) / |/| ./ J |)'( | ` F`.'/ -<| F __ .-< | / .-'. `. /-. L___ J \ < \ | | O\|.-' _J \ .- \/ O | | \ |F '-F -<_. \ .-' `-' L__ __J _ _. >-' )._. |-' `-|.' /_. \_| F /.- . _.< /' /.' .' `\ /L /' |/ _.-'-\ /'J ___.---'\| |\ .--' V | `. ` |/`. `-. `._) / .-.\ \ ( `\ `.\
You just have to run again the initdb command with -D option :
initdb - D D:\DataPG
Then, you'll have to start the database server with this command :
pg_ctl -D D:\DataPG start
dedy a écrit :
initdb - D D:\DataPG
Then, you'll have to start the database server with this command :
pg_ctl -D D:\DataPG start
dedy a écrit :
I have just installed PostgreSQL (postgresql-8.0.1.zip) on a Windows 2K Prof platform.
but the the default Database Dir is in C:\Program Files\PostgreSQL\8.0\data
can I move the default Database ex: D:\DataPG\
where can i set it??
Thank You for all your kind for reading my bad english email
Dedy Styawan
Semarang - Central Java
Indonesia
| .
. |L /| .
_ . |\ _| \--+._/| .
/ ||\| Y J ) / |/| ./
J |)'( | ` F`.'/
-<| F __ .-<
| / .-'. `. /-. L___
J \ < \ | | O\|.-'
_J \ .- \/ O | | \ |F
'-F -<_. \ .-' `-' L__
__J _ _. >-' )._. |-'
`-|.' /_. \_| F
/.- . _.<
/' /.' .' `\
/L /' |/ _.-'-\
/'J ___.---'\|
|\ .--' V | `. `
|/`. `-. `._)
/ .-.\
\ ( `\
`.\
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Thank You sir. for your kind to answering my email. if try it but the default is in the c:\..... how can i move it to d:\DataPG ?? Dedy Styawan Olivier Martineau writes: > You just have to run again the initdb command with -D option : > initdb - D D:\DataPG > > Then, you'll have to start the database server with this command : > pg_ctl -D D:\DataPG start > > > dedy a écrit : > >> I have just installed PostgreSQL (postgresql-8.0.1.zip) on a Windows 2K >> Prof platform. >> but the the default Database Dir is in C:\Program >> Files\PostgreSQL\8.0\data >> can I move the default Database ex: D:\DataPG\ >> where can i set it?? >> Thank You for all your kind for reading my bad english email >> Dedy Styawan >> Semarang - Central Java >> Indonesia >> >> >> >> >> >> | . >> . |L /| . >> _ . |\ _| \--+._/| . >> / ||\| Y J ) / |/| ./ J |)'( | ` F`.'/ >> -<| F __ .-< >> | / .-'. `. /-. L___ >> J \ < \ | | O\|.-' >> _J \ .- \/ O | | \ |F >> '-F -<_. \ .-' `-' L__ >> __J _ _. >-' )._. |-' >> `-|.' /_. \_| F >> /.- . _.< >> /' /.' .' `\ /L /' |/ _.-'-\ >> /'J ___.---'\| |\ .--' V | `. ` >> |/`. `-. `._) >> / .-.\ \ ( `\ >> `.\ >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 6: Have you searched our list archives? >> >> http://archives.postgresql.org >> >> > | . . |L /| . _ . |\ _| \--+._/| . / ||\| Y J ) / |/| ./ J |)'( | ` F`.'/ -<| F __ .-< | / .-'. `. /-. L___ J \ < \ | | O\|.-' _J \ .- \/ O | | \ |F '-F -<_. \ .-' `-' L__ __J _ _. >-' )._. |-' `-|.' /_. \_| F /.- . _.< /' /.' .' `\ /L /' |/ _.-'-\ /'J ___.---'\| |\ .--' V | `. ` |/`. `-. `._) / .-.\ \ ( `\ `.\