[ADMIN] Still confusing with "LISTEN,UNLISTEN,NOTIFY" Command.

Dear expert; Anybody, please gimme the explanation of "LISTEN,UNLISTEN and NOTIFY" Command. I've been reading from the manual-help. but still confusing of when i must use this command. Or perhaps you have the Good example of using this command.   Thank's a lot.   GOD Bless You All and B

Re: [ADMIN] pg_atoi: error in.....: can't parse..."

stessy writes: > I have this error "pg_atoi: error in "PARC INDUSTRIEL": can't parse > "PARC INDUSTRIEL" " when I try to copy data from file to database. The copy is seeing the value "PARC INDUSTRIEL" while it is trying to fill a numerical column. Make sure the order and type of your columns ma

Re: [ADMIN] Prompts in psql

Sam Barnett-Cormack wrote: Is there any way to change the prompt in the psql CLI client? In the same way as one does with bash, or other shells. Ideally I want: [EMAIL PROTECTED]:database $ as the prompt. Anyone got any ideas/references? Put \set PROMPT1 '[EMAIL PROTECTED]:%~%R%# ' in your .

[ADMIN] Running postgresql on an memory stick

Hi folks, as anyone tested tunning postgresql on a memory stick ? cu -- - Enrico Weigelt== metux IT services phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932

Re: [ADMIN] Prompts in psql

Sam Barnett-Cormack wrote: > Is there any way to change the prompt in the psql CLI client? In the > same way as one does with bash, or other shells. > > Ideally I want: > > [EMAIL PROTECTED]:database $ > > as the prompt. Anyone got any ideas/references? Sure, see the psql manual page. -- Br

[ADMIN] Prompts in psql

Is there any way to change the prompt in the psql CLI client? In the same way as one does with bash, or other shells. Ideally I want: [EMAIL PROTECTED]:database $ as the prompt. Anyone got any ideas/references? -- Sam Barnett-Cormack Software Developer | Student of

[ADMIN] pg_atoi: error in.....: can't parse..."

hi all,   I have this error "pg_atoi: error in "PARC INDUSTRIEL": can't parse "PARC INDUSTRIEL" "   when I try to copy data from  file to database.   The 2 databases have the same encoding 'LATIN1'.   The data types are all the same in two tables.   These are alls requests I use to copy d

Re: [ADMIN] Replication

Thanks for all who replied. There are certain cases where multi-master rep are very implementable such as where the datasets being rep are fairly disjointed but need to be replicated for completeness in terms of reporting. But you are absolutely 110% correct. Multimaster synchro is a nightmare.