[ADMIN] pg_hotbackup

I have 3 database in my cluster , and would make backup online just one database ,atually i using pg_hotbackup --backupdir=/var/lib/pgsql/backups --datadir=/var/lib/pgsql/data but this command make a full backup in cluster. anybody help me! Tnks Paulo Moraes Novos endereços, o Yahoo! q

[ADMIN] MAX_CONNECTIONS ??

I need help to alter max_connections em my database, this parameter stay in defalt MAX_CONNECTIONS=100 I want to change for MAX_CONNECTIONS=300. about parameters below, need to change anything? 1 -sysctl.conf kernel.shmmax = 68719476736 kernel.shmall = 4294967296 # - Memory - 2-Postgresql.conf

Res: [ADMIN] [GENERAL] MAX_CONNECTIONS ??

Only kernel.shmmax have importance in this case? about kernel.shmmax it has configured not by me. De: Richard Huxton <[EMAIL PROTECTED]> Para: paulo matadr <[EMAIL PROTECTED]> Cc: GENERAL <[EMAIL PROTECTED]>; admin Enviadas: Quarta-feira,

[ADMIN] Tool to converter plsql in pgplsql

Hi guys, you knowns a tool for automatic converter plsql in pgplsql? this tool exist? Thanks Paulo Moraes Veja quais são os assuntos do momento no Yahoo! +Buscados http://br.maisbuscados.yahoo.com

[ADMIN] Urgente error in restore prod

Hi guys, i need urgent help with this error: pg_restore: [archiver (db)] error returned by PQputCopyData: cannot allocate memory for output buffer im my restore . any idea with solve this error? Paulo Moraes Veja quais são os assuntos do momento no Yahoo! +Buscados http://br.maisbuscados.y

[ADMIN] bytea size limit?

I everyone, need help!!! My aplication return erro: 2009-01-20 10:22:03,264 INFO [STDOUT] Caused by: org.postgresql.util. PSQLException: ERROR: invalid memory alloc request size 1705447581 TABLE batch.relatorio_gerado rege_id integer NOT NULL, fuin_id integer NOT NULL, rela_id integer NO

Res: [ADMIN] [GENERAL] bytea size limit?

My system have very large ram size, so its possible review postgresql.conf ? De: Kenneth Marshall Para: Grzegorz Ja??kiewicz Cc: paulo matadr ; pgsql-gene...@postgresql.org; admin Enviadas: Quarta-feira, 21 de Janeiro de 2009 11:06:23 Assunto: Re: [ADMIN

Res: [ADMIN] [GENERAL] bytea size limit?

,if this bigger , hangs . No able to select or others report in this table. De: Albe Laurenz Para: paulo matadr *EXTERN* ; pgsql-gene...@postgresql.org; admin Enviadas: Quarta-feira, 21 de Janeiro de 2009 14:03:17 Assunto: Re: [ADMIN] [GENERAL] bytea

Res: [ADMIN] [GENERAL] bytea size limit?

e: Albe Laurenz Para: paulo matadr *EXTERN* Cc: GENERAL ; admin Enviadas: Quinta-feira, 22 de Janeiro de 2009 6:26:26 Assunto: Re: [ADMIN] [GENERAL] bytea size limit? Please don't top post. paulo matadr wrote: >>> My aplication return erro: >>> >>> 2

[ADMIN] restore In parallel postgres 9

Hi gurus, When I try to pg_restore -d teste -v -j 16 < teste.dmp 2>> teste.log & I give error: pg_restore: opção inválida -- j Tente "pg_restore --help" para obter mais informação. How can using parallel resource in new postgres? Regards Paulo

[ADMIN] Cluster with LATIN1 and UTF-8

Hi all, Im try install postgres 9.0 on rhel and I try install cluster with 2 options of databases LATIN1 and UTF-8. It's possible? Paulo

Res: [ADMIN] Cluster with LATIN1 and UTF-8

--version psql (PostgreSQL) 8.3.5 on this version in another server, it's working.. but I cant repeat on postgres 9 . Paulo De: Gabriele Bartolini Para: paulo matadr Cc: admin Enviadas: Segunda-feira, 13 de Dezembro de 2010 13:11:20 Assunto: Re: [

Res: [GENERAL] Res: [ADMIN] Cluster with LATIN1 and UTF-8

Solved tnks... createdb -E LATIN1 -O -T template0 --lc-collate=pt_BR --lc-ctype=pt_BR Paulo De: Osvaldo Kussama Para: paulo matadr Enviadas: Segunda-feira, 13 de Dezembro de 2010 16:14:36 Assunto: Re: [GENERAL] Res: [ADMIN] Cluster with LATIN1 and

[ADMIN] 8.4 restore parallel

Hi all, I made an backup of database 8.3 test.dmp and tested restore in (8.4.5) using parallel pg_restore -d xxx -n yyy -t -j 3 < test.dmp And give error: pg_restore: [custom archiver] cannot reopen stdin pg_restore: [archiver] worker process failed: exit code 1 Why not working? Reg