Mailinglist Archive: opensuse (3666 mails)

< Previous Next >
RE: [SLE] PostgreSQL 8.01 Proble/Question

I don't know if you found the answer to this or not. I had the same problem
and here is what I did to fix it.

1. Hopefully, you did a pg_dumpall on your old database(s)
2. You need to delete your data directory
3. cd /usr/bin
4. su postgres
5. Do an ./initdb on your data directory using the -D option
6. exit
7. rcpostgresql - Voila
8. reload your data either using pg_restore (if you put it out in the right
format, which of course I didn't) or psql -U postgres template1 < dump.file.


-----Original Message-----
From: Andrei Verovski (aka MacGuru) [mailto:andreil1@xxxxxxxxxxx]
Sent: Sunday, February 13, 2005 3:18 PM
To: suse-linux-e@xxxxxxxx
Cc: max@xxxxxxx
Subject: [SLE] PostgreSQL 8.01 Proble/Question


I have just installed SuSE 9.2 PostgreSQL 8.01 RPMs from:

Unfortunately, PostgreSQL seem to be not running... Calling rcpostgresql
or /etc/init.d/postgresql scripts return nothing for start, stop, restart,
etc. Like nothing happen.

Anyone have an idea what might be wrong?

Thanks in advance for any suggestion(s).

***   with best regards
***   Andrei Verovski (aka MacGuru)
***   Mac, Linux, DTP, Programming Web Site

Check the headers for your unsubscription address
For additional commands send e-mail to suse-linux-e-help@xxxxxxxx
Also check the archives at
Please read the FAQs: suse-linux-e-faq@xxxxxxxx

< Previous Next >