What is this...?
От | The Hermit Hacker |
---|---|
Тема | What is this...? |
Дата | |
Msg-id | Pine.NEB.3.95.980308174817.29397E-100000@hub.org обсуждение исходный текст |
Ответы |
Re: [HACKERS] What is this...?
Re: [HACKERS] What is this...? |
Список | pgsql-hackers |
I might have missed somethign with all the dump/reload discussions that went on, but what is: postgres@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...
В списке pgsql-hackers по дате отправления: