Re: [ADMIN] Replication

2003-09-01 Thread Ian Huynh
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

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

2003-09-01 Thread stessy
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 todatabase. 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 data.

[ADMIN] Prompts in psql

2003-09-01 Thread Sam Barnett-Cormack
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

Re: [ADMIN] Prompts in psql

2003-09-01 Thread Bruce Momjian
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. -- Bruce

[ADMIN] Running postgresql on an memory stick

2003-09-01 Thread weigelt
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

2003-09-01 Thread Renney Thomas
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

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

2003-09-01 Thread Peter Eisentraut
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 matches.