From: | jwieck(at)debis(dot)com (Jan Wieck) |
---|---|
To: | scrappy(at)hub(dot)org (The Hermit Hacker) |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] What is this...? |
Date: | 1998-03-09 08:27:47 |
Message-ID: | m0yBxuW-000BFRC@orion.SAPserv.Hamburg.dsh.de |
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;
^^^^^^^ COPY into a view? Cool!
> 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...
>
>
>
>
>
So we missed something when renaming pg_user into pg_shadow.
Damn.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======================================== jwieck(at)debis(dot)com (Jan Wieck) #
From | Date | Subject | |
---|---|---|---|
Next Message | Maurice Gittens | 1998-03-09 10:07:25 | Re: [HACKERS] newoid in invapi.c |
Previous Message | Herouth Maoz | 1998-03-09 07:47:51 | Re: [QUESTIONS] Testing Postgresql v6.3 |