pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Srinivas Kotapally <ksrinivas@coriendo.com>
To: 'Linux Geeks' <indolinux.geeks@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Moving data directory
Date: Sat, 12 May 2007 12:53:34 -0400
Message-ID: <026d01c794b6$14f29770$800101df@srinilaptop> (raw)
In-Reply-To: <e0247eb60705120947q495da44ar629cd1b8191879f@mail.gmail.com>
References: <e0247eb60705120947q495da44ar629cd1b8191879f@mail.gmail.com>

You can do an initdb -d /var/lib/postgresql  to initialize the data directory in
the /var/lib/postgresql directory.  If you also have data in the
/usr/lib/postgresql - make sure you back it up and restore it in the new
directory.

-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org]
On Behalf Of Linux Geeks
Sent: Saturday, May 12, 2007 12:48 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Moving data directory

Hi All,

I'm very new to postgresql and would like to move my data directory to another
partition in Ubuntu. The standard installation is in /usr/lib/postgresql. How do
I move it into /var/lib/postgresql.

Regards,

Dino

--
To Analyze Is To Know Batte Field, Differ from Battle Itself

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly




view thread (10+ messages)  latest in thread

Message-ID: <026d01c794b6$14f29770$800101df@srinilaptop>
Permalink:  ../026d01c794b6$14f29770$800101df@srinilaptop/
Also on:    postgresql.org/message-id/026d01c794b6$14f29770$800101df@srinilaptop

 · 

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-admin@postgresql.org
  Cc: ksrinivas@coriendo.com, indolinux.geeks@gmail.com
  Subject: Re: Moving data directory
  In-Reply-To: <026d01c794b6$14f29770$800101df@srinilaptop>

* 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