Re: [ADMIN] Problem when migrating my BB.DD Postgresql 7.2.3 to

On Sun, 6 Jul 2003 [EMAIL PROTECTED] wrote: > I have two system. The first system have RetHat 7.2 and Postgresql 7.2.3, my > other system (the second) have RedHat 7.2 and Postgresql 7.3.2. > > I have expoted the data base of my first system (Postgresql 7.2.3)with command > pg_dump data_base name >

Re: [ADMIN] Migrating from 7.1 to 7.2 using pg_dump/pg_restore

В Пнд, 07.07.2003, в 00:01, Soeren Laursen пишет: > Hi, > > I am not sure how and where I should use the \encoding latin1 > > Something like, > > psql test01 > \encodinng latin1 > \q > > pg_restore . Ah. Load the backup in a non-unicode database, dump it using the text format (i.e. not th

[ADMIN] Problem when migrating my BB.DD Postgresql 7.2.3 to Postgresql 7.3.2

Hi, I have two system. The first system have RetHat 7.2 and Postgresql 7.2.3, my other system (the second) have RedHat 7.2 and Postgresql 7.3.2. I have expoted the data base of my first system (Postgresql 7.2.3)with command pg_dump data_base name > export.dmp. I later import (the file export.dm

Re: [ADMIN] Migrating from 7.1 to 7.2 using pg_dump/pg_restore fails - UNICODE error

Hi, I am not sure how and where I should use the \encoding latin1 Something like, psql test01 \encodinng latin1 \q pg_restore . Regards Søren, > В Вск, 06.07.2003, в 19:57, Soeren Laursen пишет: > > > pg_restore: ERROR: copy: line 1, Invalid UNICODE character sequence > > foun

Re: [ADMIN] Migrating from 7.1 to 7.2 using pg_dump/pg_restore

В Вск, 06.07.2003, в 19:57, Soeren Laursen пишет: > pg_restore: ERROR: copy: line 1, Invalid UNICODE character sequence > found (0xf87665) > No need to say that the new database is created with UNICODE > encoding?! use \encoding latin1 once when you import the data. That'll convert the data f

Re: [ADMIN] Pls. help me to clarify my doubts.

<[EMAIL PROTECTED]> wrote: > > hi, > > > > Sir, i follow your procedure of Postgres installation (version 7.1.3) > > on linux 2.4.7-10. > > > > I want to know how to enable syslog and mention the log information > > will store in /var/postgreslog directory path.. > > not sure abt 7.1.3 , but in 7

[ADMIN] Migrating from 7.1 to 7.2 using pg_dump/pg_restore fails - UNICODE error

Hi All, I am upgrading my server 7.1 (a debian potato) to a new server 7.2 (a debian woody). On the 7.1 server I had a script that took a backup of my databases each day using pg_dump: /usr/local/pgsql/bin/vacuumdb -z -h localhost -U postgres $i >/dev/null 2>&1 /usr/local/pgsql/bin/pg_dump -b -F

[ADMIN] Problem after deleting pg_trigger

I was importing a database and acidently duplicated all my triggers. I was searching for a way to delete the duplicated triggers and found the table pg_trigger. I tought that if I deleted all the records in that table, I could recreate the triggers. So I executed the command DELETE FROM pg_trigger.