postgres updating problem
От | Marco Giardini |
---|---|
Тема | postgres updating problem |
Дата | |
Msg-id | 20001010162611.B24453@tecnogi.com обсуждение исходный текст |
Список | pgsql-general |
I'm trying to update to the debian potato distribution from the previous slink debian. Everything is fine but postgresql. As described in the debina documentation, i did: # su - postgres $ postgresql-dump -t db.out -cilfdp $PGDATA/../data.save Actualli i have database named tecnogi on this server but i get the following error: On the basis of this dump, is it OK to delete the old database? [y/n] y Destroying old database... We are initializing the database system with username postgres (uid=31). This user will own all the files and must also own the server process. Creating Postgres database system directory /var/lib/postgres/data/base Creating template database in /var/lib/postgres/data/base/template1 Creating global classes in /var/lib/postgres/data/base Adding template1 database to pg_database... Vacuuming template1 Creating public pg_user view Creating view pg_rules Creating view pg_views Creating view pg_tables Creating view pg_indexes Loading pg_description Reloading databases... -- postgresql-dump on Tue Oct 10 12:58:38 CEST 2000 from version 6.3 \connect template1 connecting to new database: template1 select datdba into table tmp_pg_shadow from pg_database where datname = 'template1'; QUERY: select datdba into table tmp_pg_shadow from pg_database where datname = 'template1'; SELECT delete from pg_shadow where usesysid <> tmp_pg_shadow.datdba; QUERY: delete from pg_shadow where usesysid <> tmp_pg_shadow.datdba; DELETE 4 drop table tmp_pg_shadow; QUERY: drop table tmp_pg_shadow; DROP copy pg_shadow from stdin; QUERY: copy pg_shadow from stdin; \connect template1 tecnogi connecting to new database: template1 as user: tecnogi create database tecnogi with encoding='SQL_ASCII'; QUERY: create database tecnogi with encoding='SQL_ASCII'; ERROR: createdb: database 'tecnogi' already exists ERROR: createdb: database 'tecnogi' already exists \connect tecnogi tecnogi FATAL 1: Database tecnogi does not exist in pg_database connecting to new database: tecnogi as user: tecnogi FATAL 1: Database tecnogi does not exist in pg_database Could not connect to new database. exiting Reload failed postgres@tecnogi:~$ pq_recvbuf: unexpected EOF on client connection Please let me know. Thanks .oesse. -- ------------------------------------------------------------------ Marco Giardini TecnoGi spa Tel. +39 0321 885422 Strada per Gravellona Fax +39 0321 885333 Borgolavezzaro (NO) http://www.tecnogi.com Key fingerprint = B5 B4 AA 91 89 50 43 8F B1 6B C6 8C 34 79 5A 7F
В списке pgsql-general по дате отправления: