Re: [GENERAL] v8.3.4 metadata changes while users active

2012-04-05 Thread Martin Gregorie
On Thu, 2012-04-05 at 03:17 +, Gauthier, Dave wrote: > H... I don't have root access :-( > In that case, ask your sysadmin to grant you sudo access to iptables or, if he thinks that is excessive, to write a wrapper script that enables/disables just that port and give you sudo access to th

Re: [GENERAL] Versioned, chunked documents

2012-04-01 Thread Martin Gregorie
Correction interpolated - see below On Mon, 2012-04-02 at 00:22 +0100, Martin Gregorie wrote: > On Mon, 2012-04-02 at 00:38 +0200, Ivan Voras wrote: > > Hi, > > > > I have documents which are divided into chunks, so that the (ordered) > > concatenation of chunks make

Re: [GENERAL] Versioned, chunked documents

2012-04-01 Thread Martin Gregorie
On Mon, 2012-04-02 at 00:38 +0200, Ivan Voras wrote: > Hi, > > I have documents which are divided into chunks, so that the (ordered) > concatenation of chunks make the whole document. Each of the chunks may > be edited separately and past versions of the chunks need to be kept. > > The structure

Re: [GENERAL] Help in Parsing PG log usings CSV format

2012-03-22 Thread Martin Gregorie
On Thu, 2012-03-22 at 09:32 +, Arvind Singh wrote: > Help needed in parsing PostgreSQL CSV Log > Hello friends, > I am working an a section of application which needs to Parse CSV Logs > generated by PostgreSql server. > - The Logs are stored C:\Program Files\PostgreSQL\9.0\data\pg_log > - The

Re: [GENERAL] copy in date string "00-00-00 00:00:00"

2012-03-15 Thread Martin Gregorie
On Wed, 2012-03-14 at 21:52 -0700, Mark Phillips wrote: > I am not familiar with sed, except for some trivial bits I nicked off > the web. Enough to know it works, and to be dangerous. Nonetheless, > using SED may be the way to go as there are two tables that contain a > bit over 3,000,000 rows eac

Re: [GENERAL] How to find compiled-in default port number?

2012-03-13 Thread Martin Gregorie
On Tue, 2012-03-13 at 11:16 +0200, Виктор Егоров wrote: > Greetings. > > Is there a way to find out the compiled-in port number? > Two ways, with Postgres running: - Scan the server's ports with nmap. - as root on the server, run "lsof | less" and look at the Postgres process(es). Both are fa

Re: [GENERAL] Matching on keyword or phrases within a field that is delimited with an "or" operator "|"

2012-03-12 Thread Martin Gregorie
On Mon, 2012-03-12 at 15:57 -0700, Jim Ostler wrote: > I have a table that is around 20 GB, so I need to optimize as best as > possible the matching with another table on keywords across multiple > fields. I have around 10 fields that have keywords or phrases > delimited with the "or" operator "|"

Re: [GENERAL] Error installing postgresq91-python package

2012-03-12 Thread Martin Gregorie
On Sat, 2012-03-10 at 14:08 -0800, PgSQL wrote: > >>>If the OP can identify and download the relevant .rpm file > Have you checked the CentOS bugzilla to see if the yum failure has been reported? You should raise a bug report if it isn't there: if nobody reports a bug its unlikely to get fixed. >

Re: [GENERAL] Error installing postgresq91-python package

2012-03-10 Thread Martin Gregorie
On Sat, 2012-03-10 at 13:28 -0800, Adrian Klaver wrote: > On 03/10/2012 09:59 AM, PgSQL wrote: > > Thanks. > > > > You can see: > > > > root@s1 [/000/yuyuyum/2012/2012]# yum install mx > > Traceback (most recent call last): > > File "/usr/bin/yum", line 4, in ? > > import yum > > File "/usr/lib/pyt

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

2012-03-07 Thread Martin Gregorie
On Wed, 2012-03-07 at 09:38 -0500, Gary Chambers wrote: > Martin, > > > 6) The next scheduled backup using pg_dumpall failed immediately because > > it couldn't find 'template1'. > > The template1 database is the default database to which pg_dumpall attempts > to connect. If you use the -l or --

[GENERAL] Fixing the loss of 'template1'

2012-03-07 Thread Martin Gregorie
In the course of migrating from (I think) Postgres 8.4 under Fedora 12 to Postgres 9.1 under Fedora 16 I managed to loose 'template1' and associated data. The immediate effect is that, although my schema and data seem to be intact and are working correctly, pg_dumpall refused to run because it can'

Re: [GENERAL] Complex transactions without using plPgSQL Functions. It is possible?

2012-03-07 Thread Martin Gregorie
On Wed, 2012-03-07 at 14:19 +0400, Sergey Konoplev wrote: > On Tue, Mar 6, 2012 at 11:30 PM, Andre Lopes wrote: > > This is the plPgSQL code that I need to write in Python. It is > > possible to do this without using PlPgSQL? > Have you looked at pyodbc? ODBC will usually accept statements allow