Re: [GENERAL] Run postgresql engine in readonly mode?

2008-10-11 Thread Scott Marlowe
On Sat, Oct 11, 2008 at 7:41 PM, Joshua Tolley <[EMAIL PROTECTED]> wrote: > On Thu, Oct 9, 2008 at 2:37 AM, Galland Gregoire <[EMAIL PROTECTED]> wrote: >> Hi all! >> >> I would like to run all my databases in a readonly mode just for a few >> hours (migration plan). >> >> Is it a way to tell the po

Re: [GENERAL] Run postgresql engine in readonly mode?

2008-10-11 Thread Joshua Tolley
On Thu, Oct 9, 2008 at 2:37 AM, Galland Gregoire <[EMAIL PROTECTED]> wrote: > Hi all! > > I would like to run all my databases in a readonly mode just for a few > hours (migration plan). > > Is it a way to tell the postgresql engine to run in readonly? > > Sincerly > > G.Galland > This comes up pe

Re: [GENERAL] Reg: Permission error in Windows psql while trying to read sql commands from file

2008-10-11 Thread Raj K
Since it is in windows - I could not find any specific file permission mechanisms similar to linux. (This is my first foray in windows - so I am a newbie there too ) The computer is not in a network. So, through googling, I found that to share it, we have to move it to C:\Documents and Settings\All

Re: [GENERAL] Need schema design advice

2008-10-11 Thread Jeff Soules
On Sat, Oct 11, 2008 at 1:10 PM, Matthew Wilson <[EMAIL PROTECTED]> wrote: > I need to track employees and their preferred locations, shifts, and > stations. > > For example, I need to track that Alice prefers to work the morning > shift at the west-side location, and she likes to work the cash-reg

Re: [GENERAL] Need advice on PITR Slony(?) Backups etc.

2008-10-11 Thread Scott Marlowe
On Sat, Oct 11, 2008 at 12:03 PM, Kyle Cordes <[EMAIL PROTECTED]> wrote: > We need some sage advice on how to make best use of PG/addon features (PITR, > snapshot backups, possibly Slony, etc.) for our situation. > > We don't need a full time DBA (yet), but we are looking for specific review > of o

Re: [GENERAL] Need schema design advice

2008-10-11 Thread Artacus
I need to track employees and their preferred locations, shifts, and stations. For example, I need to track that Alice prefers to work the morning shift at the west-side location, and she likes to work the cash-register station. Also, I need to track that Bob likes the west-side and north-side l

Re: [GENERAL] calling a function that takes a row type and returns a set of rows

2008-10-11 Thread Dimitri Fontaine
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, Le 11 oct. 08 à 08:18, Pavel Stehule a écrit : I'm not sure about the syntax, but LATERAL is a standard JOIN type wherein upper "nodes" are visible. no, this strange syntax is far to any standard. Solution is using dynamic cursor ala DB2 (t

Re: [GENERAL] 8.4 RPMs

2008-10-11 Thread Devrim GÜNDÜZ
On Wed, 2008-10-08 at 20:57 +0930, admin wrote: > > I'm looking for RHEL/CentOS RPMs for version 8.4 for testing purposes > (with Drupal). I can find an RPM to install a yum repo at > yum.pgsqlrpms.org, but not the RPMs themselves. I prepared packages for RHEL/CentOS 5 and Fedora 9. If you are

[GENERAL] Need advice on PITR Slony(?) Backups etc.

2008-10-11 Thread Kyle Cordes
We need some sage advice on how to make best use of PG/addon features (PITR, snapshot backups, possibly Slony, etc.) for our situation. We don't need a full time DBA (yet), but we are looking for specific review of our plans, advice, and help setting things up. I suspect this will involve some

Re: [GENERAL] PQexecParams question

2008-10-11 Thread Pavel Stehule
2008/10/11 Grzegorz Jaśkiewicz <[EMAIL PROTECTED]>: > Hey folks, > I have here piece of code, that I wrote some time ago - works fine, but I > was wondering - if it can be improved. > This is used to grab id list, not present on submited list. Query usually > looks like that; > select id from foo w

Re: [GENERAL] Reg: Permission error in Windows psql while trying to read sql commands from file

2008-10-11 Thread Raymond O'Donnell
On 11/10/2008 18:38, Raj K wrote: > testdb=# \i c:\testdb.txt > c:: Permission denied Apologies for the silly question, but did you actually check the permissions on the file to see if you are allowed to read it? Ray. -- Raymond O'D

[GENERAL] PQexecParams question

2008-10-11 Thread Grzegorz Jaśkiewicz
Hey folks, I have here piece of code, that I wrote some time ago - works fine, but I was wondering - if it can be improved. This is used to grab id list, not present on submited list. Query usually looks like that; select id from foo where id not in ($1, $2, $3...); and I was wondering, is it poss

[GENERAL] Reg: Permission error in Windows psql while trying to read sql commands from file

2008-10-11 Thread Raj K
Hi all, I am a DB newbie and I am facing an issue. I installed postgresql in windows - and now I am facing an issue while trying to read sql commands from file. testdb=# \i c:\testdb.txt c:: Permission denied I tried moving the file to the shared folder, but of no use. testdb=# \i

Re: [GENERAL] Starting PostgreSQL

2008-10-11 Thread Tom Lane
admin <[EMAIL PROTECTED]> writes: > I continually get this message: > psql: could not connect to server: No such file or firectory > Is the server running locally and accepting > connections on Unix domain socket "/tmp/.s.PDSQL.0"? If it's really saying .0, and not .5432, then the problem is on t

[GENERAL] Need schema design advice

2008-10-11 Thread Matthew Wilson
I need to track employees and their preferred locations, shifts, and stations. For example, I need to track that Alice prefers to work the morning shift at the west-side location, and she likes to work the cash-register station. Also, I need to track that Bob likes the west-side and north-side lo

Re: [GENERAL] Starting PostgreSQL

2008-10-11 Thread Adrian Klaver
On Saturday 11 October 2008 7:33:20 am admin wrote: > Sorry folks, a perennial one I'm sure ... > > I have read the manual and Googled for a couple of hours but still can't > connect to PostgreSQL 8.3.4 (the PGDG RPMs running on an up to date > CentOS 5.2). > > I continually get this message: > > p

Re: [GENERAL] Starting PostgreSQL

2008-10-11 Thread Devrim GÜNDÜZ
On Sun, 2008-10-12 at 00:03 +0930, admin wrote: > psql: could not connect to server: No such file or firectory > Is the server running locally and accepting > connections on Unix domain socket "/tmp/.s.PDSQL.0"? Socket file name is wrong -- and the port... -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org

[GENERAL] Starting PostgreSQL

2008-10-11 Thread admin
Sorry folks, a perennial one I'm sure ... I have read the manual and Googled for a couple of hours but still can't connect to PostgreSQL 8.3.4 (the PGDG RPMs running on an up to date CentOS 5.2). I continually get this message: psql: could not connect to server: No such file or firectory Is

Re: [GENERAL] drupal 6.x fixes for PostgreSQL 8.3 available

2008-10-11 Thread Ivan Sergio Borgonovo
On Sat, 11 Oct 2008 16:14:30 +0400 (MSD) Oleg Bartunov <[EMAIL PROTECTED]> wrote: > Hi there, > I know there are many people having problem with Drupal and > PostgreSQL. My former colleague Alex Tutubalin just piblished > several fixes for Drupal 6.5, see > http://groups.drupal.org/node/15793 It

[GENERAL] drupal 6.x fixes for PostgreSQL 8.3 available

2008-10-11 Thread Oleg Bartunov
Hi there, I know there are many people having problem with Drupal and PostgreSQL. My former colleague Alex Tutubalin just piblished several fixes for Drupal 6.5, see http://groups.drupal.org/node/15793 Regards, Oleg __

Re: [Pkg-postgresql-public] [GENERAL] Re: Postgres major version support policy on Debian

2008-10-11 Thread Martin Pitt
Scott Marlowe [2008-10-10 15:43 -0600]: > This is certainly not true for slony on ubuntu. On Ubuntu there's a > slony1-bin package that has the common files, and then there's > postgresql-8.x-slony1 package for each pgsql version that has the > scripts to make that version happy. The only differe