Re: [GENERAL] pg_dump -t <> pg_restore -t

Richard Huxton wrote: > alexandre - aldeia digital wrote: >> Hi, >> >> If I do: >> >> pg_dump -Fc -t TABLE database > table-custom.sql >> >> The pg_dump returns the DDL of the table, the data and the DDL for >> indexes and PK. If I use -s,

[GENERAL] pg_dump -t <> pg_restore -t

Hi, If I do: pg_dump -Fc -t TABLE database > table-custom.sql The pg_dump returns the DDL of the table, the data and the DDL for indexes and PK. If I use -s, only the structure is returned but it's include all elements. But if I do: pg_dump -Fc database > backup-custom.file pg_restore -Fc -t T

[GENERAL] differences between pg_dump and pg_restore with -t

Hi, If I do: pg_dump -Fc -t table database > table.sql The pg_dump returns the DDL of the table, the data and the DDL for indexes and PK. If I use -s, only the structure, but all is returned. But if I do: pg_dump -Fc database > backup.file pg_restore -Fc -t table backup.file > table.sql On

[GENERAL] differences between pg_dump and pg_restore with -t

Hi, If I do: pg_dump -Fc -t table database > table.sql The pg_dump returns the DDL of the table, the data and the DDL for indexes and PK. If I use -s, only the structure, but all is returned. But if I do: pg_dump -Fc database > backup.file pg_restore -Fc -t table backup.file > table.sql Only

Re: [GENERAL] pg_dump error codes

Michael Fuhr wrote: On Mon, Jan 02, 2006 at 08:45:28AM -0200, alexandre - aldeia digital wrote: In my Linux bash backup scripts, I wish to send an e-mail when an error occurs in pg_dump proccess. And if possible, I want to send the error output via e-mail. Anybody knows how to capture the

[GENERAL] pg_dump error codes

Hi, (maybe an idiot question) In my Linux bash backup scripts, I wish to send an e-mail when an error occurs in pg_dump proccess. And if possible, I want to send the error output via e-mail. Anybody knows how to capture the output and send this to an e-mail ONLY if an error occurs ? Thank

Re: [GENERAL] Killing process through of a function

Hi Michael, The software was generated by a CASE tool (genexus) and it's does not permit any modification. IBM DB2 have functions that allow the DBA to disconnect some clients. This is very usefull for database maintenance without giving a shell to him. VACUUM FULL is other "application" thats

[GENERAL] Killing process through of a function

Hi, Can I kill a postgres user process inside a function (SP)? Sometimes, the java program that our company uses stay in "idle in transaction" and every day, I need to import a text data to some tables in DB. This import make a TRUNCATE in this tables and I need to kill the remaining process bef

Re: [GENERAL] Error al Subir base de datos

Hi, You need to create you database with an enconding like LATIN1: createdb -E latin1 mydb Alexandre Juan Jose Siles Salinas wrote: Cuando subo la base de datos con pg_restore -d mydb < mydb.tar restablece toda la informacion pero los acentos y ñ muestran caracteres en otra codificacion como pue

[GENERAL] Index, Tablespace and performance

Hi, I have a 4 x SCSI in RAID 10 (PG 7.4.6) with a regular performance. My database have 55 Gb of data. In PG 8, moving the indexes to a separeted disk (or array) can (generally) improve the performance if the system make a heavy use of indexes ? Thanks Alexandre ---(end