Hi, I'm having a problem getting Postgresql working properly. There seem to be two problems. The postmaster is not working and the database is in an older format that cannot be read by version 7.4 of PostgreSQL.I have read the 'README.Debian.migration' file but am still confused. I tried apt-removing the older version and apt-reinstalling with no difference.
When running 'postgresql-dump' I get the following >> Tux:/root$ psql postgresql-dump -- d >> psql: could not connect to server: [EMAIL PROTECTED]&@ >> Is the server running locally and accepting >> connections on Unix domain socket >> "/var/run/postgresql/.s.PGSQL.5432"? >> Tux:/root$ > > Also, >> Tux:/etc/postgresql# /etc/init.d/postgresql start >> Starting PostgreSQL database server: postmaster(FAILED) >> ERROR: The database is in an older format that cannot be read by >> version 7.4 of PostgreSQL. >> >> Run postgresql-dump to dump the old database and to reload >> it in the new format. >> *** READ /usr/share/doc/postgresql/README.Debian.migration.gz FIRST! *** >> >> The version 7.4 postmaster cannot be started until >> this is done. > > When I try to get into postgres I get asked for a password, but as I have not yet set up or configured it, there isn't one. >> Tux:/root$ su postgres >> Password: > > I'm aware this is a fairly common procedure but I'm floundering around, the night is late, I'm trying to RTFM, and other priorities call. Can anyone point me in the right direction ? Adam Bogacki, [EMAIL PROTECTED] -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
