initdb problem
Hi!
I don't know if it is a bug or not. What I am facing is that I can't open a database I created. It's better to explain you by below scenario:
I have installed the Postgres v7.1 or later. Then, I changed the initial database cluster to another disk, "/mydb". Then, I changed "PGDATA" in the "/etc/rc.d/init.d/postgresql". I did change all "start", and "stop" PGDATA variable to "/mydb". Everything works fine.
Until I formated the Linux (Redhat, v7.1) system, and re-installed the Redhat (v7.1) again. Please note that "/mydb" is not been removed because it is kept in another disk.
Now I installed the Postgres v7.1 again, and try to changed the initial database cluster to "/mydb". And it cannot allow me to do that.
My point is how can I open my database I kept in "/mydb" again. Is it a bug? Please help me.
Sincerely yours,
--
Ping - Nattaphol Manomaiphan.
EVSD Project Leader
No Magic Asia Ltd.,
719, 22nd Fl., KPN Tower, Rama IX Road,
Huaykwang, Bangkok 10320 Thailand.
Phone: +66-2-7170252 Fax: +66-2-7170251
email: nattaphol_m@nomagicasia.com
http://www.nomagicasia.com
"Ping (No Magic Asia)" <nattaphol_m@nomagicasia.com> writes:
Until I formated the Linux (Redhat, v7.1) system, and re-installed the Redh=
at (v7.1) again. Please note that "/mydb" is not been removed because it i=
s kept in another disk.
Now I installed the Postgres v7.1 again, and try to changed the initial dat=
abase cluster to "/mydb". And it cannot allow me to do that.=20=20=20=20
It is highly unlikely that this is a bug. You might try asking for help
on the pgsql-admin list. And provide some details when you do (like
exactly what settings you changed while trying to move the database, and
exactly what failure you're getting). "It cannot allow me" conveys
nothing.
regards, tom lane