| From: | "Boban Acimovic" <acim(at)mbl(dot)is> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: [GENERAL] How to get database schema without pg_dump? |
| Date: | 2001-12-10 18:11:33 |
| Message-ID: | 006001c181a6$3892e5f0$8b00000a@acim |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
After lot of tries, it seems I resolved this problem.
First thing what I did is to hack pg_dump not to use SQL queries with
regular expressions. I tried LIKE clause, but it seems it is internally
interpreted as regular expression, so I replaced it with SUBSTR function.
This pg_dump was able to dump all databases with no problem.
Then I compiled PostgreSQL with multibyte support and created databases with
encoding LATIN1. After I filled the data back, everything looks fine. It is
working for several hours and I can't see any problems. Hopefully this is
the resolution for my problem.
Thank you Stephan for helping.
Regards,
Boban Acimovic
UNIX SysAdmin
www.mbl.is
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steven Lane | 2001-12-10 18:13:49 | Shared memory oddity |
| Previous Message | Tom Lane | 2001-12-10 15:40:58 | Re: Moving a database |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Campano, Troy | 2001-12-10 18:24:41 | PostgreSQL Outer Joins |
| Previous Message | Antonio Fiol Bonnín | 2001-12-10 18:04:24 | Re: OR-ing rows of bits |