Skip site navigation (1) Skip section navigation (2)

Re: Dumping/Restoring with constraints?

From: "Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)com>
To: "Andrew Sullivan" <ajs(at)commandprompt(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Dumping/Restoring with constraints?
Date: 2008-08-29 14:26:14
Message-ID: e373d31e0808290726x3109ef36s9234247a33a6e303@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
Thanks Andrew.

On the server (the DB to be dumped) everything is "UTF8".

On my home server (where I would like to mirror the DB), this is the output:


=# \l
            List of databases
   Name    |      Owner      | Encoding
-----------+-----------------+-----------
 postgres  | postgres        | SQL_ASCII
 pkiula    | pkiula_pkiula   | UTF8
 template0 | postgres        | SQL_ASCII
 template1 | postgres        | SQL_ASCII
(4 rows)



This is a fresh install as you can see. The database into which I am
importing ("pkiula") is in fact listed as UTF8! Is this not enough?

In response to

Responses

pgsql-admin by date

Next:From: Andrew SullivanDate: 2008-08-29 14:49:24
Subject: Re: Dumping/Restoring with constraints?
Previous:From: Andrew SullivanDate: 2008-08-29 13:34:36
Subject: Re: Dumping/Restoring with constraints?

pgsql-general by date

Next:From: Andrew SullivanDate: 2008-08-29 14:49:24
Subject: Re: Dumping/Restoring with constraints?
Previous:From: btoberDate: 2008-08-29 14:26:10
Subject: Re: pg_dumpall problem when roles have default schemas

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group