Re: [ADMIN] two instances of Postgres in the same server

Ronaldo <[EMAIL PROTECTED]> writes: > I need to install a Postgres 8 server in the same host that already exist a > Postgres 7 instance. > If any know how to do this please help us. Give them separate install directories, separate data directories, and different port numbers, and you're good to go

[ADMIN] Altering WAL Segment File Size

Dear Sir,           How can I altered the WAL segment file size when building the server. The default size was  16 MB.     I want only 1 MB size…       Waiting for your kind reply   Regards Dhanesh     Dhanesh Prabha P.V WIPRO Technologies, Sar

[ADMIN] two instances of Postgres in the same server

Title: Mensagem Please,   I need to install a Postgres 8 server in the same host that already exist a Postgres 7 instance. If any know how to do this please help us.   Thanks   Ronaldo da Silva Santos (0xx51)3341-9955 www.shoppingbrasil.com.br www.informabrasil.com.br  

Re: [ADMIN] Vacuum Full Analyze Stalled

Thanks Tom... The Linux box was completely idle (as you already guessed). There were multiple locks on the table(s) in question. And to answer your question, we are heavily using domain types. I suspect (to refresh your memory) that the problem reported earlier was from Kevin Grittner. Do

Re: FW: [ADMIN] truncate error

On Tue, Oct 04, 2005 at 10:01:42AM -0600, Sidar López Cruz wrote: > Yo primero hice truncate a la tabla derivada y luego a la tabla maestra y > PostgreSQL no me lo permitia, entonces hice DELETE sobre la tabla maestro y > si pudo borrar los registros, aun no se porque pasa eso. Hola, el idioma d

Re: [ADMIN] Altering WAL Segment File Size

Out of curiosity, why do you feel the need to change this? On Tue, Oct 04, 2005 at 07:43:02PM +0530, Sivakumar K wrote: > I believe the parameter which needs to be changed is > XLOG_SEG_SIZE inside src/include/pg_config_manual.h. > > Also go through the comments embedded i

Re: [ADMIN] archive_command

On Tue, 4 Oct 2005, Simon Riggs wrote: What would constitute an intermediate rebuild? Of course the system is up and live and having data added to it. How would one restore from multiple timelines? This is only if you are back up and working on the went-down box: intermediate rebuild: I mea

Re: [ADMIN] Altering WAL Segment File Size

[EMAIL PROTECTED] wrote: > > > Dear Sir, > How can I altered the WAL segment file size when building > the server. The default size was 16 MB. > > I want only 1 MB size… > What are you trying to achieve? May be you are looking in the wrong direction. Regards Gaetano

Re: [ADMIN] archive_command

On Tue, 2005-10-04 at 08:03 -0700, Jeff Frost wrote: > >> Is there any possible way to replay the other WAL files after the Sep 21 > >> switchover/switchback? I'm going to guess this is similar to having > >> another > >> timeline. > > > > That may be your exact case, it depends upon how you did

FW: [ADMIN] truncate error

Yo primero hice truncate a la tabla derivada y luego a la tabla maestra y PostgreSQL no me lo permitia, entonces hice DELETE sobre la tabla maestro y si pudo borrar los registros, aun no se porque pasa eso. From: Alvaro Herrera <[EMAIL PROTECTED]> To: Sidar López Cruz <[EMAIL PROTECTED]> CC:

Re: [ADMIN] archive_command

Jeff Frost wrote: > On Sun, 2 Oct 2005, Simon Riggs wrote: > >> Probably the best idea is to backup the last WAL file for each timeline >> seen. Keep track of that, so when the current file changes you'll know >> which timeline you're on and stick to that from then on. Or more simply, >> put some

Re: [ADMIN] Vacuum Warning

Prasanth <[EMAIL PROTECTED]> writes: > I got this message in my daily vacuum. Is it some thing to worry about? > What exactly does this mean? > vacuumdb: vacuuming database "test_server" > WARNING: relation "account_lists" page 189 is uninitialized --- fixing This can happen after a crash; it's

Re: [ADMIN] archive_command

On Tue, 4 Oct 2005, Simon Riggs wrote: Now here's the problem...the servers switched roles on Sep 21. We switched them back a little while after that. When I went to replay the WAL files using the Sep 15 base backup, it happily played back the WAL files to Sep 21 and stopped. I presume that th

Re: [ADMIN] truncate error

On Tue, Oct 04, 2005 at 08:40:31AM -0600, Sidar López Cruz wrote: > PostgreSQL 8.1 beta 2 raise error on truncating tables with foreign keys, > try this to see !!! Hum, what were you trying to show us? Truncating tables with foreign keys is supposed to work as long as you truncate the referenced

[ADMIN] truncate error

PostgreSQL 8.1 beta 2 raise error on truncating tables with foreign keys, try this to see !!! _ Consigue aquí las mejores y mas recientes ofertas de trabajo en América Latina y USA: http://latam.msn.com/empleos/

[ADMIN] Vacuum Warning

Hi, I got this message in my daily vacuum. Is it some thing to worry about? What exactly does this mean? vacuumdb: vacuuming database "test_server" WARNING: relation "account_lists" page 189 is uninitialized --- fixing Thanks, -Prasanth. ---(end of broadcast)---

Re: [ADMIN] Altering WAL Segment File Size

    I believe the parameter which needs to be changed is XLOG_SEG_SIZE inside src/include/pg_config_manual.h.     Also go through the comments embedded in the file.       Please feel free to correct me.     Regards, Siva Kumar.K -Original Message-

[ADMIN] Altering WAL Segment File Size

          Dear Sir,           How can I altered the WAL segment file size when building the server. The default size was  16 MB.     I want only 1 MB size…       Waiting for your kind reply   Regards Dhanesh     Dhanesh Prabha P.V WIPRO

Re: [ADMIN] archive_command

On Mon, 2005-10-03 at 20:00 -0700, Jeff Frost wrote: > On Sun, 2 Oct 2005, Simon Riggs wrote: > > > Probably the best idea is to backup the last WAL file for each timeline > > seen. Keep track of that, so when the current file changes you'll know > > which timeline you're on and stick to that from