Re: [ADMIN] Disabling triggers with psql (gforge 7.4 to 8.2 migration)

2010-02-11 Thread Iñigo Martinez Lasala
Hi Josh. I have followed your suggestion and restored bad tables into a file. This has shortened the conversion process since I've only restored to file bad chars tables, and only 8 showed this issue. So, instead of having to fix full dump (about 45G) I only had to process 10MB (8 tables). This

[ADMIN] Replication on windows - PgAdmin

2010-02-11 Thread reshma parveen
Hi, I am struck with a problm could anyone help me out here plz.. I have a problem while replicating my database in same machine via PgAdmin on Windows, When I try to initiate a new Slony cluster in the PgAdmin interface, the status-bar says Slony-I creation scripts not available; only joining

[ADMIN] REF : MIgracion de datos ms sql server 7.0 a Postgresql 8.4 en Linux

2010-02-11 Thread Luis Dominguez
Buenos dias, estoy en estos momentos en un proceso de migracion de una base de datos de un manejador ms sql server 7.0 a postgresql vesion 8.4 pero tengo un problema con un tipo de dato el (timestamp) que en sql server 7.0 se refiere a un campo binario unico que se actualiza en forma

Re: [ADMIN] REF : MIgracion de datos ms sql server 7.0 a Postgresql 8.4 en Linux

2010-02-11 Thread Rafael
a ustedes para ver si me pueden echar una mano con este bache que tengo ahorita ¡ Saludos Luis Dominguez _ __ Información de ESET NOD32 Antivirus, versión de la base de firmas de virus 4857 (20100211) __ ESET NOD32 Antivirus ha comprobado este mensaje. http

[ADMIN] REF: Data Migration MS SQL Server 7.0 to PostgreSQL 8.4 on Linux

2010-02-11 Thread Luis Dominguez
Good morning, I am now in the process of migrating a database from a driver ms sql server 7.0 to postgresql 8.4 vesion but I have a problem with the data type (timestamp) SQL Server 7.0 that refers to a single binary field that is updated randomly by row, and this field is paramount in my

Re: [ADMIN] REF: Data Migration MS SQL Server 7.0 to PostgreSQL 8.4 on Linux

2010-02-11 Thread Kevin Grittner
Luis Dominguez b...@hotmail.com wrote: I am now in the process of migrating a database from a driver ms sql server 7.0 to postgresql 8.4 vesion but I have a problem with the data type (timestamp) SQL Server 7.0 that refers to a single binary field that is updated randomly by row, and this

Re: [ADMIN] please remove my email address

2010-02-11 Thread Dimitri Fontaine
Meehan, Steven steve.mee...@yoh.com writes: I had joined your site to post a PostgreSQL opening but had removed myself because of getting all of these emails. Yes, that's called a mailing list. That's like a free support forum, operated by mail. http://en.wikipedia.org/wiki/Mailing_list

Re: [ADMIN] REF: Data Migration MS SQL Server 7.0 to PostgreSQL 8.4 on Linux

2010-02-11 Thread Iñigo Martinez Lasala
Hola Rafael. You could generate a UUID. There is a contrib module in contrib/uuid-ossp with several functions in order to generate an UUID with different algorithms, as documentation says. If you don’t want to use these functions because you use an specific format, perhaps they could serve you

[ADMIN] New/obsolete configuration parameters

2010-02-11 Thread Igor Neyman
Is there a document desribing (ar at least listing) new/obsolete configuration parameters in postgresql.conf, when upgrading from version to version? Regards, Igor Neyman

Re: [ADMIN] pg_xlog

2010-02-11 Thread Kevin Grittner
Albert Shih albert.s...@obspm.fr wrote: How can I clean up the pg_xlog directory ? I've 710 go of those file. I've archive_mode on but not in the pg_xlog directory I've something like archive_mode = on # allows archiving to be done archive_command = 'cp -i %p

Re: [ADMIN] pg_xlog

2010-02-11 Thread Joshua D. Drake
On Thu, 2010-02-11 at 23:09 +0100, Albert Shih wrote: Hi all How can I clean up the pg_xlog directory ? I've 710 go of those file. I've archive_mode on but not in the pg_xlog directory I've something like archive_mode = on # allows archiving to be done

[ADMIN] How to manage WAL

2010-02-11 Thread Albert Shih
Hi all I would like to known what's best way to manage the WAL. Let's me explain : at beginning I do something like psql -c select pg_start_backup('complete'); rsync /pgsql backup_server: psql -c select pg_stop_backup(); and I backup

Re: [ADMIN] pg_xlog

2010-02-11 Thread Albert Shih
Le 11/02/2010 à 16:20:26-0600, Kevin Grittner a écrit Albert Shih albert.s...@obspm.fr wrote: How can I clean up the pg_xlog directory ? I've 710 go of those file. I've archive_mode on but not in the pg_xlog directory I've something like archive_mode = on

Re: [ADMIN] How to manage WAL

2010-02-11 Thread Kevin Grittner
Albert Shih albert.s...@obspm.fr wrote: I would like to known what's best way to manage the WAL. You should design a policy which meets your particular needs. We keep two PITR base backups and all the WAL files from before the start of the first (based on the information in the backup file)

Re: [ADMIN] How to manage WAL

2010-02-11 Thread Albert Shih
Le 11/02/2010 à 17:00:33-0600, Kevin Grittner a écrit Albert Shih albert.s...@obspm.fr wrote: I would like to known what's best way to manage the WAL. You should design a policy which meets your particular needs. We keep two PITR base backups and all the WAL files from before the

Re: [ADMIN] How to manage WAL

2010-02-11 Thread Alvaro Herrera
Albert Shih wrote: Le 11/02/2010 à 17:00:33-0600, Kevin Grittner a écrit Albert Shih albert.s...@obspm.fr wrote: I would like to known what's best way to manage the WAL. You should design a policy which meets your particular needs. We keep two PITR base backups and all the WAL