| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2008-08-29 14:49:24 | Re: Dumping/Restoring with constraints? |
| Previous Message | Andrew Sullivan | 2008-08-29 13:34:36 | Re: Dumping/Restoring with constraints? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2008-08-29 14:49:24 | Re: Dumping/Restoring with constraints? |
| Previous Message | btober | 2008-08-29 14:26:10 | Re: pg_dumpall problem when roles have default schemas |