Re: [GENERAL] Security setup.

2011-09-11 Thread Sim Zacks
The problem with trust is that it means that any user can type in any other users login name and get access without knowing his password. Even if your app is the only access point to the database, you still have to worry about a user installing psql or other client onto his desktop and accessin

Re: [GENERAL] Security setup.

2011-09-11 Thread Sim Zacks
On 09/11/2011 02:58 PM, mgo...@isstrucksoftware.net wrote: Sim, Thanks, our users can only get to the application(s) they have on their citrix menu. They are locked out of the servers otherwise. I haven't had a problem in the past 20 years with another db back end but I do think that on th

[GENERAL] writing block 6850 of relation 1663/17231/1259

2011-09-11 Thread Mudit Mishra
Sorry forgot to change title. Any help will be greatly received! -Original Message- From: Mudit Mishra Sent: 11 September 2011 14:39 To: pgsql-general@postgresql.org Subject: RE: [GENERAL] COPY FROM (query) in plpgsql Hi All, Can anyone help me to fix this issue? I keep getting foll

[GENERAL] Locale for Error Messages

2011-09-11 Thread George Sexton
I run a SAS application that uses PostgreSQL. I'm working on enhancing my support for other languages. One of the things I noticed is that I'm getting my errors (say a unique key constraint) in English. This is expected. I know I'm not doing anything to change the locale. I'd like to figure out

Re: [GENERAL] Security setup.

2011-09-11 Thread Chris Travers
On Sun, Sep 11, 2011 at 12:44 AM, Sim Zacks wrote: > The problem with trust is that it means that any user can type in any other > users login name and get access without knowing his password. Even if your > app is the only access point to the database, you still have to worry about > a user insta

Re: [GENERAL] writing block 6850 of relation 1663/17231/1259

2011-09-11 Thread Bruce Momjian
Mudit Mishra wrote: > Sorry forgot to change title. > > Any help will be greatly received! > > > -Original Message- > From: Mudit Mishra > Sent: 11 September 2011 14:39 > To: pgsql-general@postgresql.org > Subject: RE: [GENERAL] COPY FROM (query) in plpgsql > > Hi All, > > Can anyone

[GENERAL] pg_dump with select command

2011-09-11 Thread Adarsh Sharma
Dear all, Today I need some part ( subset ) of some tables to another database to a remote server. I need to take backup of tables after satisfying a select query. Is there any option to specify query in pg_dump command.I researched in the manual but not able to find that. Please let me know

[GENERAL] servoy-postgresql plugin

2011-09-11 Thread Rogel Nocedo
Hi! Is there a way that I can use the postgresql commands like pg_dump etc in servoy? I am tasked to do a restore/backup database utility programmatically for our users. It's a little painful to do a select for the table and insert scripts based on the resultset. Thanks and Regards, Roge

Re: [GENERAL] pg_dump with select command

2011-09-11 Thread Ondrej Ivanič
Hi, On 12 September 2011 15:03, Adarsh Sharma wrote: > Today I need some part ( subset ) of some tables to another database to a > remote server. > I need to take backup of  tables after satisfying a select query. > > Is there any option to specify query in pg_dump command.I researched in the >

Re: [GENERAL] servoy-postgresql plugin

2011-09-11 Thread Simon Riggs
On Mon, Sep 12, 2011 at 5:25 AM, Rogel Nocedo wrote: > Is there a way that I can use the postgresql commands like pg_dump etc in > servoy?  I am tasked to do a restore/backup database utility > programmatically for our users.  It’s a little painful to do a select for > the table and insert script

[GENERAL] (replication) Detecting if server a slave, or a master in recovery

2011-09-11 Thread Toby Corkindale
Hi, What is the correct way to tell what mode a replicated Pg server is currently in, via a database connection? I can take a guess if it's the master or a slave by using the pg_current_xlog_location() and pg_last_xlog_replay_location() functions. However it occurs to me that a master server