pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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

view thread (5+ messages)  latest in thread

Message-ID: <20080508070102.GB16326@svana.org>
Permalink:  ../20080508070102.GB16326@svana.org/
Also on:    postgresql.org/message-id/20080508070102.GB16326@svana.org

 · 

reply

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