[pgadmin-support] pg_twophase and pg_subtrans

2012-01-19 Thread paddy carroll
The implementation is a database firewall where postgres gets used between our corporate and production network environments on a Linux (RHEL 4.8) platform. Were transitioning from 8.3.7 to 9.x. and were also implementing a link to postgres from SQL server 2005 using the PGNP OLE DB driver from p

Re: [pgadmin-support] Connecting to postgresql with pdadmin III - sucess !!!

2012-01-19 Thread Raymond O'Donnell
On 19/01/2012 18:58, David M. Gullever wrote: > Thanks Dave for the reply, > > Sorry you must think I'm a 24 Carat Moron but since there is no > documentation, this is actually becoming interesting - especially since > thousands of users before me have started-up with pdadmin apparently without >

Re: [pgadmin-support] Connecting to postgresql with pdadmin III - sucess !!!

2012-01-19 Thread David M. Gullever
Thanks Dave for the reply, Sorry you must think I'm a 24 Carat Moron but since there is no documentation, this is actually becoming interesting - especially since thousands of users before me have started-up with pdadmin apparently without problems. But my thoughts at the moment are as follows...

Re: [pgadmin-support] Connecting to postgresql with pdadmin III

2012-01-19 Thread Raymond O'Donnell
On 19/01/2012 12:57, David M. Gullever wrote: > This explains the Host field but not the Name field. Perhaps those > that wrote this help document thought that this was obvious but IS > IT ??? Up till now I thought I was trying to connect to a Database on > my local machine but perhaps pgadmin III

[pgadmin-support] column level privilages error

2012-01-19 Thread bdmyt...@eranet.pl
HI all, I think, there is little bug in column privilage mechanism. The bug occures when You try to set column privilages using user name who has no rights to do this. For table there is no tab "Privilages", for columns it exists and accepts configuration. Even when You accept Your configuration

Re: [pgadmin-support] Connecting to postgresql with pdadmin III

2012-01-19 Thread Dave Page
On Thu, Jan 19, 2012 at 12:57 PM, David M. Gullever wrote: > > So my pgadmin questions at this stage are... > 1. Do I have to Add a server before adding a database (and what would be the > name of the Server) Yes, and whatever you like - it's just a name for you to identify the server (i.e. "Deve

[pgadmin-support] Connecting to postgresql with pdadmin III

2012-01-19 Thread David M. Gullever
Thanks Dave Page, Kevin Grittner & Walter Hurry for the replies since I had so many problems last time I am really doing this step-by-step. Before I want to add any users I simply want to get (and understand) my connections right. My step-by-step plan looks like this... 1. do installations (on my