Skip site navigation (1) Skip section navigation (2)

Re-Init database cluster.

From: Louie Kwan <lkwan(at)nuvo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re-Init database cluster.
Date: 2004-03-17 21:45:00
Message-ID: FB4FDC17A002D711BC0C009027DE84AF027F6C54@EXCHANGE.nuvo.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi All,

I did a pg_dumpall and psql the output and created a db. Basically, I would
like to clean up  everything including users and groups.

I tried to do initdb, but it didn't work. 

My question is that can I just delete the directory where the database
cluster stored before.

I.e. rm -rf /var/lib/pgsql/data

Or I should do something else to re-init the database cluster.

Louie

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2004-03-18 03:17:02
Subject: Re: Re-Init database cluster.
Previous:From: Jack KerkhofDate: 2004-03-17 19:29:56
Subject: pgdump - What happens to data modifications (INSERT, UPDATE, DELETE) while pgdump is running?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group