Re: [ADMIN] What is wrong ?

how to unsubscribe from this mailing list

Re: [ADMIN] WAL files backup

pedro noticioso wrote: > Muchas gracia a todos los queme han respondido hasta > ahora > Thanks to all who have repplied so far Pedro, I don't think you're doing anyone (nor yourself) any favors by writing both in spanish and english in this list. This list is english only. If you want to write i

[ADMIN] What is wrong ?

I have created a rule on a table as folows: CREATE OR REPLACE RULE edw_item_avail_200606 AS ON INSERT TO edw_item_avail WHERE "substring"(new.amc_week_id::text, 1, 6) = '200606'::text DO INSTEAD INSERT INTO mpartition.edw_item_avail_200308 (item_avail_key, prod_dim_id, amc_week_id,

Re: [ADMIN] rename a cluster

Bruce Momjian <[EMAIL PROTECTED]> writes: > Peter Eisentraut wrote: >> Renaming the directory is OK. Just make sure your init script or >> whatever finds it. > Oh, and make sure the postmaster isn't running when you do the rename. While that's surely good practice, I don't think it's actually c

Re: [ADMIN] Isolated databases or instances

Scott, We will try the single PostgreSQL instance with 3 databases configured in it. Nigel D. Henry State of New Mexico Computer Software Engineer Children, Youth, & Family Division [EMAIL PROTECTED] (505) 841-6631 Confidentiality Notice: This e-mail, including all attachments, is for t

Re: [ADMIN] WAL files backup

Muchas gracia a todos los queme han respondido hasta ahora Thanks to all who have repplied so far Ok entonces regreso y reinicio al procedimiento completo para tratar de atinarle a lo que puede ser el problema. Ok so I go back and retry the complete procedure to try to pin point what might be the

Re: [ADMIN] Isolated databases or instances

On Fri, 2007-02-16 at 16:30, Henry, Nigel, CYFD wrote: > More information: > > As stated, this is going to be a SLES 9.3 environment -- 64-bit. > VMWare, for now, is out of the question because we currently only have > IBM HS20 blades which are unable to host the 64-bit environment in > VMWare.

Re: [ADMIN] WAL files backup

On 2/16/07, Andy Shellam (Mailing Lists) < [EMAIL PROTECTED]> wrote: Why bother trying to delete WAL files older than the .backup file? When PostgreSQL is in recovery mode it knows which WAL files are necessary to perform the recovery. Also, the documentation recommends excluding the pg_xlog

Re: [ADMIN] Isolated databases or instances

More information: As stated, this is going to be a SLES 9.3 environment -- 64-bit. VMWare, for now, is out of the question because we currently only have IBM HS20 blades which are unable to host the 64-bit environment in VMWare. So we're running the OS on bare metal. As I mentioned in my or

Re: [ADMIN] Isolated databases or instances

If you really need three discrete instances, you might want to look at using vmware to set up three separate virtual machines, each with their own IPs etc... on that one box. This was my thought; depending on how much RAM you have in each blade, you could have two virtual servers on each blad

Re: [ADMIN] rename a cluster

On Fri, Feb 16, 2007 at 04:35:40PM -0500, Bruce Momjian wrote: > Peter Eisentraut wrote: > > Renaming the directory is OK. Just make sure your init script or > > whatever finds it. > > Oh, and make sure the postmaster isn't running when you do the rename. Right, there are a few operational con

Re: [ADMIN] Isolated databases or instances

On Fri, 2007-02-16 at 15:16, Tom Lane wrote: > Scott Marlowe <[EMAIL PROTECTED]> writes: > > On Fri, 2007-02-16 at 13:18, Henry, Nigel, CYFD wrote: > >> We are at the beginning of the building of a 3-tier > >> development/test/uat environment. We would like some advice on how > >> the PostgreSQL

Re: [ADMIN] rename a cluster

Peter Eisentraut wrote: > Ray Stell wrote: > > What I was trying to get at is, is mv of the dir ok or > > is there something else that needs to be considered? Thx. > > Renaming the directory is OK. Just make sure your init script or > whatever finds it. Oh, and make sure the postmaster isn't r

Re: [ADMIN] Isolated databases or instances

Scott Marlowe <[EMAIL PROTECTED]> writes: > On Fri, 2007-02-16 at 13:18, Henry, Nigel, CYFD wrote: >> We are at the beginning of the building of a 3-tier >> development/test/uat environment. We would like some advice on how >> the PostgreSQL database should be configured for this environment. >

Re: [ADMIN] Isolated databases or instances

On Fri, 2007-02-16 at 13:18, Henry, Nigel, CYFD wrote: > We are at the beginning of the building of a 3-tier > development/test/uat environment. We would like some advice on how > the PostgreSQL database should be configured for this environment. > > The environments will be installed on three

[ADMIN] Isolated databases or instances

From: Henry, Nigel, CYFD Sent: Fri 2/16/2007 12:18 PM To: pgsql-admin@postgresql.org Subject: Isolated databases or instances We are at the beginning of the building of a 3-tier development/test/uat environment in SUSE Linux Enterprise v9.3. We would like s

[ADMIN] Isolated databases or instances

We are at the beginning of the building of a 3-tier development/test/uat environment. We would like some advice on how the PostgreSQL database should be configured for this environment. The environments will be installed on three blades of an IBM Blade Center. Due to budget restrictions, w

Re: [ADMIN] Debug (is it PostgreSQL?)

A quick Google search reveals it looks like PgAdmin's job scheduling queue: http://archives.postgresql.org/pgadmin-support/2006-06/msg5.php Might be worth asking on [EMAIL PROTECTED] Andy. Ezequias Rodrigues da Rocha wrote: My Linux is reporting the following message: DEBUG: Connection

[ADMIN] Debug (is it PostgreSQL?)

My Linux is reporting the following message: DEBUG: Connection stats: total - 1, free - 0, deleted - 0 DEBUG: Checking for jobs to run DEBUG: Sleeping... DEBUG: Clearing inactive connections DEBUG: Connection stats: total - 1, free - 0, deleted - 0 DEBUG: Checking for jobs to run DEBUG: Sleeping

Re: [ADMIN] pg_xlog and the WAL files

"Achakzai, Omar" <[EMAIL PROTECTED]> writes: > 1. What happens when the file system on which the pg_xlog directly resides,= > completely fills up? Does PostgreSQL wait until free space is available ag= > ain?=20 I believe it'll PANIC and shut down. You won't lose any committed transactions ... b

[ADMIN] pg_xlog and the WAL files

Hi, I have two questions about PostgreSQL: 1. What happens when the file system on which the pg_xlog directly resides, completely fills up? Does PostgreSQL wait until free space is available again? 2. Our PostgreSQL database (version 8.1.4.) generates almost 20 GB of WAL files per hour! Wha

Re: [ADMIN] WAL files backup

Chad Wagner wrote: On 2/15/07, *Eduardo J. Ortega* <[EMAIL PROTECTED] > wrote: After erasing the "less than names" WAL files, we add to tar the remaining WAL records (0003B, 0003C and so on on the example). The more WAL files you have after 0003B,

Re: [ADMIN] WAL files backup

On 2/15/07, Eduardo J. Ortega <[EMAIL PROTECTED]> wrote: After erasing the "less than names" WAL files, we add to tar the remaining WAL records (0003B, 0003C and so on on the example). The more WAL files you have after 0003B, the more up to date DB you get after restore (since it has more WAL