From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | What is this...? |
Date: | 1998-03-08 22:50:20 |
Message-ID: | Pine.NEB.3.95.980308174817.29397E-100000@hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I might have missed somethign with all the dump/reload discussions that
went on, but what is:
postgres(at)zeus> psql -e -f db.dump template1
\connect template1
connecting to new database: template1
select datdba into table tmp_pguser from pg_database where datname =
'template1';
QUERY: select datdba into table tmp_pguser from pg_database where
datname = 'template1';
SELECT
delete from pg_user where usesysid <> tmp_pguser.datdba;
QUERY: delete from pg_user where usesysid <> tmp_pguser.datdba;
DELETE 0
drop table tmp_pguser;
QUERY: drop table tmp_pguser;
DROP
copy pg_user from stdin;
QUERY: copy pg_user from stdin;
Enter info followed by a newline
End with a backslash and a period on a line by itself.
>>
And then it just stops...?
This is using pg_dump/pg_dumpall from 6.2.1, before shutting down v6.2.1,
to create the db.dump file...
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 1998-03-08 22:59:29 | Is it just me...? |
Previous Message | Bruce Momjian | 1998-03-08 19:48:31 | Re: [DOCS] Re: pgsql-docs-digest V1 #312 |