postgres updating problem

From: Marco Giardini <marco(dot)giardini(at)tecnogi(dot)com>
To: pgsql-general(at)hub(dot)org
Subject: postgres updating problem
Date: 2000-10-10 14:26:11
Message-ID: 20001010162611.B24453@tecnogi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)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

Browse pgsql-general by date

  From Date Subject
Next Message Daryl Chance 2000-10-10 14:30:08 Re: Delphi PostgreSQL Forum
Previous Message Efrain Caro 2000-10-10 14:22:29 Re: Delphi PostgreSQL Forum