[wellylug] 'postgresql-dump' confusion

[Adam Bogacki]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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: 8\uffff+@\uffff\uffff&@
> 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,
afb at paradise.net.nz



 
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCjcR218X1Fk5VORARArwaAJ0RbIQ6TvuhvTOkK2yAzKaIyzArNwCfUVp9
3dgmVK5Ts9ZPKczFoC0mhuk=
=7Lie
-----END PGP SIGNATURE-----