Re: Ubuntu question

--GRPZ8SYKNexpdSJ7
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Thu, May 08, 2008 at 01:52:17AM -0500, Q Master wrote:
> I had postgresql 7.4 on ubuntu and over one year ago I moved to 8.2
> Till now I was backing up my db via pgadmin remotely from windows but=20
> now I want to do it from the ubuntu server.

I suggest looking at the README.Debian for postgres, it contains much
im****tant information you need to understand how multiple concurrently
installed versions work.

> When I run the command pgdump it said that the database is 8.2 but
the=20
> tool is 7.4 - my question is, where in the world is the pgdump for 8.2
-=
=20
> I can't find it.
>=20
> pg_dump, pg_dumpall are all in /usr/bin but where are the 8.2 ones ?

First, check what you have installed with pg_lsclusters (this will give
you the ****t number). Normally you can specify the cluster directly to
pg_dump but if you want the actual binary go to:

/usr/lib/postgresql/<version>/bin/pg_dump.

Have a nice day,
--=20
Martijn van Oosterhout   <kleptog@[EMAIL PROTECTED]
>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while=20
> boarding. Thank you for flying nlogn airlines.

--GRPZ8SYKNexpdSJ7
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFIIqUuIB7bNG8LQkwRAiwyAJ9Y30W+ovCbpM85hT05mIQ32F0kjACfcMHL
7u875/iGyd/lCA3mBPn161I=
=rWyt
-----END PGP SIGNATURE-----

--GRPZ8SYKNexpdSJ7--