[ADMIN] PostgreSQL default data location

2005-06-09 Thread James Herbers
To make a long story short how do I change the default data diretory for PostgreSQL? What did I do wrong? James Herbers ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [ADMIN] PostgreSQL default data location

2005-06-10 Thread James Herbers
Override defaults from /etc/sysconfig/postgresql if file is present [ -f /etc/sysconfig/postgresql.d/${NAME} ] && \ . /etc/sysconfig/postgresql.d/${NAME} James Herbers ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please sen

Re: [ADMIN] select * and save into a text file failed

2005-06-10 Thread James Herbers
From a client machine try the program Aqua Data Studio (http://aquafold.com/) it has a nice export feature to export to text files. James Herbers Lee Wu wrote: Hi, When I try to save a query result into a text file from “select * from a_table”, once I got: out of memory for query result

Re: [ADMIN] SQL Server 2000 to PostgreSQL 8.0.3

2005-08-09 Thread James Herbers
[EMAIL PROTECTED] wrote: Greetings. I am having difficulty moving a SQL Server 2000 database over to PostgreSQL 8.0.3. In SQL Server, I am performing a backup of the database I want to move. I save that backup on my Desktop. That backup is in Microsofts own format, PostgreSQL will not be

Re: [ADMIN] MS Access and PostgreSQL

2006-04-07 Thread James Herbers
Microsoft has a KB article here - http://support.microsoft.com/kb/q128809/ - you may want to look at. I found the best way to avoid this was to use pass-through queries. J Herbers C K wrote: > Dear Friends, > I am here for a problem regarding MS Access and PostgreSQL connection > through ODBC. I

Re: [ADMIN] initdb problem

2007-06-19 Thread James Herbers
No MAC expert but try this when changing to the postgres user: su - postgres the hyphen gives you an environment for the postgres user. J. Herbers Quoting Joe Barwell <[EMAIL PROTECTED]>: Hello people, Having installed the universal binary for pg 8.2.4 on my mac running 10.3.9, I'm now try