Re: dumping the schema

From: Shridhar Daithankar <shridhar(at)frodo(dot)hserus(dot)net>
To: "raptor(at)tvskat(dot)net" <raptor(at)tvskat(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: dumping the schema
Date: 2004-07-23 09:34:49
Message-ID: 4100DBB9.4000904@frodo.hserus.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

raptor(at)tvskat(dot)net wrote:
> How to DUMP the Database schema, (so later can get it back i.e recreate everything).
> I need only the schema (tables, users, groups etc..) now (not the data, is it any different if i want the data too).

http://www.postgresql.org/docs/7.4/static/app-pgdump.html

Check --schema-only/--data-only options.

> the dump should be in order so that i can just execute it...

psql dbname < dump.file

This is the simplest way of restoring a dump.

> One more thing I created db and tables with default config (with pgadmin3) i.e. owner postgres,
> Now I want to switch all to other user I just created, can I do it "at once" or I
> have to go and edit permission of every table...

Dump the schema and hand-edit it to change ownership.

> Can I remove any access to the DB for "postgres" and "public" and leave such access to
> my new user OR they should stay for some db-functionality..

Well, you better leave those users and accesses in place on system objects at
least. For use defined table, you can fiddle around as you please.

HTH

Shridhar

In response to

Browse pgsql-general by date

  From Date Subject
Next Message CSN 2004-07-23 09:48:01 select, columns, and aliases
Previous Message raptor@tvskat.net 2004-07-23 08:49:14 dumping the schema