run this coversion command
time iconv -c -f UTF8 -t UTF8 -o newdump.sql olddump.sql
Josh O'Brien
Mario Splivalo wrote:
Hello.
I have a database created with -E UTF-8. I need to transfer it to
pg8.1.2.
First I dumped the database:
pg_dump -v -E UTF-8 the_database > the_database.psql
Hello all,
I am upgrading from postgresql v. 7.4 to 8.1. I dump my database in
plain text format and run the iconv command to fix the UTF8. When i
restore everything is populating but two tables. I was wondering if
anyone knows what would cause this. Thanks in advance.
Josh O'
Hello all,
I am upgrading from postgresql version 7.4 to 8.1 and i'm having a
problem with pg_restore. It is not recognizing the \N command as
inserting a null value. Does anyone know how to fix this?
Thanks in advance
begin:vcard
fn:Joshua O'Brien
n:O'Brien;Joshua
org:Zedx Inc.
title:Databa
Hello all
I'm trying to restore in a cluster using pg_restore and i'm receiving an
error from my recoverylog saying that there is no last checkpoint for my
backend. How can I alter pg_restore to make it work or do i have any
other options. Tahnk you in advance.
begin:vcard
fn:Joshua O'Brien
Hello all,
I was justwondering if anyone is using continuents p/cluster and could
give me info on there personal experience. Thank you
begin:vcard
fn:Joshua O'Brien
n:O'Brien;Joshua
org:Zedx Inc.
title:Database Administrator
version:2.1
end:vcard
---(end of broadcast)-
Hello all,
I was just wondering if anyone is using Steeleyes LifeKeeper for linux,
and if you had any feedback for my on its performance.
Thank you
Joshua O'Brien
---(end of broadcast)---
TIP 4: Have you searched our list archives?
Hello all
I was just wondering if anyone could tell me if there is any seamless
way to upgrade from 7.4 to 8.1 without performing a full dump/restore.
Thanks
Joshua O'Brien
DBA
Zedx Inc.
begin:vcard
fn:Joshua O'Brien
n:O'Brien;Joshua
org:Zedx Inc.
title:Database Administrator
version:2.1
end:v
