From: Martijn van Oosterhout <kleptog@svana.org>
To: Q Master <theqmaster@gmail.com>
Cc: pgsql-general@postgresql.org
Subject: Re: Ubuntu question
Date: Thu, 8 May 2008 09:01:02 +0200
Message-ID: <20080508070102.GB16326@svana.org> (raw)
In-Reply-To: <4822A321.8030004@gmail.com>
References: <b88f0d670805071302h469141e0ke29413edddb444e0@mail.gmail.com>
<19037.1210196461@sss.pgh.pa.us>
<b88f0d670805071524g1e4965cbif9b48a822dba961f@mail.gmail.com>
<1210227916.4268.254.camel@ebony.site>
<4822A321.8030004@gmail.com>
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
> 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
> tool is 7.4 - my question is, where in the world is the pgdump for 8.2 -
> I can't find it.
>
> 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/<version>/bin/pg_dump.
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.
Attachments:
signature.asc (application/pgp-signature, 188B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: kleptog@svana.org, theqmaster@gmail.com, pgsql-general@postgresql.org
Subject: Re: Ubuntu question
In-Reply-To: <20080508070102.GB16326@svana.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox