[ADMIN] WAL backup

Hi all I'm not sure I understand http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html My problem: I've huge database ~ 1To (soon 2 To) and I need backup. I can use pgdump because it's too long to do the backup. So I like to use

Re: [ADMIN] force varchar column to be lowercase

Kevin Kempter schrieb: Can I use a check constraint, or something other than a function to force a column to be lowercase only? Thx in advance try to use regexp in your CHECK CONSTRAINT: CHECK (column::bpchar ~ '^[a-z]+$'::bpchar::text) Cheers Andy -- Sent via pgsql-admin mailing list

Re: [ADMIN] force varchar column to be lowercase

On Tue, Jul 28, 2009 at 11:15 AM, Andreas Wenka.w...@netzmeister-st-pauli.de wrote: Kevin Kempter schrieb: Can I use a check constraint, or something other than a function to force a column to be lowercase only? Thx in advance try to use regexp in your CHECK CONSTRAINT: CHECK

Re: [ADMIN] force varchar column to be lowercase

Greg Stark schrieb: On Tue, Jul 28, 2009 at 11:15 AM, Andreas Wenka.w...@netzmeister-st-pauli.de wrote: Kevin Kempter schrieb: Can I use a check constraint, or something other than a function to force a column to be lowercase only? Thx in advance try to use regexp in your CHECK CONSTRAINT:

Re: [ADMIN] WAL backup

On Tue, Jul 28, 2009 at 1:46 AM, Albert Shih albert.s...@obspm.fr wrote: Hi all I'm not sure I understand http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html My problem: I've huge database ~ 1To (soon 2 To) and I need backup. I can use pgdump because

Re: [ADMIN] General queries regarding backup

Anyone ? On Wed, Jul 22, 2009 at 10:55 AM, Deepak Baladeepak.bal...@gmail.com wrote: Hi everyone, I have some queries regarding the PITR backup procedure on Postgres 8.3. Here are the steps I follow for backup 1. I set up WAL archiving and checked that this is working. 2. Execute SELECT

Re: [ADMIN] WAL backup

Le 28/07/2009 à 06:05:07-0600, Greg Spiegelberg a écrit On Tue, Jul 28, 2009 at 1:46 AM, Albert Shih albert.s...@obspm.fr wrote: Hi all I'm not sure I understand        http://www.postgresql.org/docs/8.3/interactive/ continuous-archiving.html My problem:  

[ADMIN] Postgres/C'ish question

If I execute a command-line C program that is in charge of running a postgres function that will execute a .so written in C multiple times. my question is this: if there is unfreed memory allocated from the .so after the execution of one function call from postgres through this script, will that

[ADMIN] Problem to compiling with SunStudio

Hey, thanks for the answer, but I can't solve the problemHow can I tell Sunstdio to use the right path??? readline is a package with ist installed under /opt/sfw. Here are the paths /opt/sfw/include and /opt/sfw/lib which include readline. In which way must I change the