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