Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 9EE3D2E0031 for ; Thu, 8 May 2008 04:01:19 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 54626-05 for ; Thu, 8 May 2008 04:01:03 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from svana.org (svana.org [203.190.233.187]) by developer.postgresql.org (Postfix) with ESMTP id 85C902E0059 for ; Thu, 8 May 2008 04:01:05 -0300 (ADT) Received: from kleptog by svana.org with local (Exim 4.63) (envelope-from ) id 1Ju07i-0004N1-Bv; Thu, 08 May 2008 17:01:02 +1000 Date: Thu, 8 May 2008 09:01:02 +0200 From: Martijn van Oosterhout To: Q Master Cc: pgsql-general@postgresql.org Subject: Re: Ubuntu question Message-ID: <20080508070102.GB16326@svana.org> Reply-To: Martijn van Oosterhout Mail-Followup-To: Q Master , pgsql-general@postgresql.org References: <19037.1210196461@sss.pgh.pa.us> <1210227916.4268.254.camel@ebony.site> <4822A321.8030004@gmail.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="GRPZ8SYKNexpdSJ7" Content-Disposition: inline In-Reply-To: <4822A321.8030004@gmail.com> X-PGP-Key-ID: Length=1024; ID=0x6F0B424C X-PGP-Key-Fingerprint: 34A8 8EAC F902 8C8D CA72 DCC7 201E DB34 6F0B 424C User-Agent: Mutt/1.5.13 (2006-08-11) X-SA-Exim-Connect-IP: X-SA-Exim-Mail-From: kleptog@svana.org X-SA-Exim-Scanned: No (on svana.org); SAEximRunCond expanded to false X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/255 X-Sequence-Number: 132654 --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 important 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 port number). Normally you can specify the cluster directly to pg_dump but if you want the actual binary go to: /usr/lib/postgresql//bin/pg_dump. Have a nice day, --=20 Martijn van Oosterhout 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--