[ADMIN] data transfer/migrate from win to linux

Hello. After looking for a way to transfer PostgreSQL/PostGIS data from windowsXP to linux (Ubuntu 7.10), I did not find it. Please, does anyone know an easy way or free tool for it. Thanks in advance Best regards Antonio

[ADMIN] pg_dumpall --exclude

I've inherited an application that creates a temp schema and stores a table for each user there. The data is temporary and does not need to be backed up. I run pg_dumpall each night. I can't just delete the tables because users may be working during the backup. Any suggestion on how to exclude

Re: [ADMIN] data transfer/migrate from win to linux

> After looking for a way to transfer PostgreSQL/PostGIS data from windowsXP > to linux (Ubuntu 7.10), I did not find it. > Please, does anyone know an easy way or free tool for it. Are pg_dump/pg_restore somehow insufficient for your needs? (http://www.postgresql.org/docs/current/interactive/ba

Re: [ADMIN] pg_dumpall --exclude

Richard Ray wrote: > I've inherited an application that creates a temp schema and stores > a table for each user there. > The data is temporary and does not need to be backed up. > I run pg_dumpall each night. > I can't just delete the tables because users may be working during the > backup. > An

[ADMIN] find the sequence name from schema, table, field

Hi, I have to go to the well and ask you guys how in the he_l I can determine the sequence name if I only have the schema name (normally 'public'), the table name, and the field name (normally the PK). Below is the current SQL I'm using but it does not account for field data types that are not

[ADMIN] Postgres replication

Dear All I have a application running at various locations with backend as postgres Slony is configured at all locations for replication at local site anda central server where each site has its own database instance. Now we wish to merge data collected from all the sites into one database inst