[GENERAL] Clone a database to other machine

2003-07-28 Thread Terence Chang
Hi there:   I am just wondering if this is a doable method to clone a database to other machine. I have three identical linux serves with postgresql server installed at the same location. I have a new customized database and initial data load into server 1. Can I just copy all of the databas

Re: [GENERAL] Can I turn the case sensitive off

2003-07-25 Thread Terence Chang
This is exactly what I was doing. I use PostgreSQL Manager Pro. The tool covert all my column name and table name in the double quote. So I have all my column/table/function created in upper case (Oracle habit). Now, I have to quote all of them. I should stay with psql, I guess. :-) Thanks! At le

Re: [GENERAL] Can I turn the case sensitive off

2003-07-24 Thread Terence Chang
I am still getting the error. would this matter with 7.3.3 on windows with cygwin? My query only works when I quote the field. Also I have to always use the schema name in the where clause. Is there any way that I can set default schema to "app_v08" but not public? Thank you very much! My table u

Re: [GENERAL] Where is the physical files of database that I just

2003-07-17 Thread Terence Chang
ginal Message - From: "scott.marlowe" <[EMAIL PROTECTED]> To: "Terence Chang" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, July 17, 2003 7:35 AM Subject: Re: [GENERAL] Where is the physical files of database that I just > On Wed, 16 Jul 2

Install new language - Prev: Re: [GENERAL] Are you frustrated with PostgreSQL

2003-07-16 Thread Terence Chang
t me offline. My client would love to get some help from you on administration/backup/restore stuff as an extra resource. Can you image that I got my PostgreSQL setup and running in few hours. Cool! Thanks! This mailling list is great! You people are great! Terence Chang ---