Re: [GENERAL] setting Postgres client

Markova, Nina wrote: Thanks Richard. I specified the host IP ( I use the default 5432 port), got error: psql: could not connect to server: Connection refused Is the server running on host "192.168.XX.XXX" and accepting TCP/IP connections on port 5432? The only tcp lines in my

[GENERAL] 8.3.x log maintenance

Hi, I have postgres logging into data/pg_log/ which works great. My question is there and option that tells postgres to only keep the last "n" log files? Or does someone have a script that be run daily to remove the older log files so that I only end up with "n" log files? Thanks, Steve log_

Re: [GENERAL] 8.3.x log maintenance

Tom Lane wrote: Steve Clark <[EMAIL PROTECTED]> writes: I have postgres logging into data/pg_log/ which works great. My question is there and option that tells postgres to only keep the last "n" log files? The usual solution is to choose a filename pattern that will

[GENERAL] " " around fields with psql

Hello, Is there a way with psql to get column output to be "data1","data2",...,"datan" I tried -F "," but that left off the first and last quote. I can't seem to find a way in the man page. Thanks, -- Stephen Clark *NetWolves* Director of Technology Phone: 813-579-3200 Fax: 813-882-0209 Email:

Re: [GENERAL] " " around fields with psql

On 02/10/2012 02:12 PM, Scott Marlowe wrote: On Fri, Feb 10, 2012 at 11:26 AM, Steve Clark wrote: Hello, Is there a way with psql to get column output to be "data1","data2",...,"datan" I tried -F "," but that left off the first and last quote. I

Re: [GENERAL] " " around fields with psql

On 02/13/2012 02:13 PM, Merlin Moncure wrote: On Sat, Feb 11, 2012 at 2:03 AM, Jasen Betts wrote: On 2012-02-10, Steve Clark wrote: Is there a way with psql to get column output to be "data1","data2",...,"datan" assuming you are trying to be compatible with

Re: [GENERAL] Fixing the loss of 'template1'

On 03/07/2012 09:43 AM, Marti Raudsepp wrote: On Wed, Mar 7, 2012 at 16:23, Martin Gregorie wrote: Is it possible to reinstate 'template1' and all its works without reinitialising the database from scratch. It was suggested to me that running "initdb" might fix it while leaving my data in place

[GENERAL] cast needed - but where and why?

Hello list, I am getting the following error after upgrading from 7.4.6 to 8.3.6 and can't figure out what is wrong. Any help would be greatly appreciated. from our program: sqlcode=-400 errmsg='column "event_ref_log_no" is of type integer but expression is of type text' in line 4138. from pg_

Re: [GENERAL] cast needed - but where and why?

Tom Lane wrote: Steve Clark writes: I am getting the following error after upgrading from 7.4.6 to 8.3.6 and can't figure out what is wrong. Any help would be greatly appreciated. 2009-04-02 10:45:10 EDT:srm2api:ERROR: column "event_ref_log_no" is of type integer but expres

Re: [GENERAL] recover corrupt DB?

Craig Ringer wrote: Peter Eisentraut wrote: On Thursday 23 April 2009 18:30:27 Dan Armbrust wrote: I had a test system (read as not backed up, sigh) which had the disk go full while PostgreSQL was loaded, consequently, PostgreSQL will no longer start. It is logging an error about detecting an

Re: [GENERAL] easy entry forms on a pg database

Scott Mead wrote: On Fri, May 15, 2009 at 1:11 PM, Raphael Bauduin > wrote: Hi, Are there any tool/libs to easily and rapidly generate web-based entry forms for tables in a postgresql database? I used this once for a quick project: http://www.sqlmae

<    1   2