PostgreSQL 8.01 Proble/Question
Hi, I have just installed SuSE 9.2 PostgreSQL 8.01 RPMs from: ftp://ftp.suse.com/pub/projects/postgresql/postgresql-8.0.1 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 *** *** http://snow.prohosting.com/guru4mac/ ************************************************
Andrei, 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. Frank -----Original Message----- From: Andrei Verovski (aka MacGuru) [mailto:andreil1@starlett.lv] Sent: Sunday, February 13, 2005 3:18 PM To: suse-linux-e@suse.com Cc: max@suse.de Subject: [SLE] PostgreSQL 8.01 Proble/Question Hi, I have just installed SuSE 9.2 PostgreSQL 8.01 RPMs from: ftp://ftp.suse.com/pub/projects/postgresql/postgresql-8.0.1 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 *** *** http://snow.prohosting.com/guru4mac/ ************************************************ -- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com
El Domingo, 13 de Febrero de 2005 22:18, Andrei Verovski (aka MacGuru) escribió: | 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. Try this: pg_ctl -D /usr/local/pgsql/data -p /usr/local/pgsql/bin/postmaster -o '-i -p 5432' start Best regards. Ventura -- **************************************************************************** Llave GNUpg 0x75F9AACA disponible en anillo pgp http://www.rediris.es/cert/servicios/keyserver/ **************************************************************************** El correo electrónico no firmado/encriptado no es seguro y puede no ser auténtico. Si tiene alguna duda sobre el contenido, por favor, telefonee para confirmarlo. La información contenida en este mensaje es confidencial y destinada exclusivamente para la/s dirección/es arriba indicada/s. Si ha recibido este mensaje por error o ha habido algún problema, por favor, notifíquelo inmediatamente al remitente. El uso no autorizado, revelación, copia o alteración de este mensaje está estrictamente prohibido. ****************************************************************************
participants (3)
-
Andrei Verovski (aka MacGuru) -
Frank L. Parks -
Ventura Valderrábano Ornedo