Re: [GENERAL] PG84 and SELinux

2010-12-03 Thread Tom Lane
"James B. Byrne" writes: > I wrote too soon. What I did was uncomment the ssl option. I > neglected to change the setting from off to on. > When I try to start the server with ssl=on it fails with this error: > Auto configuration failed > 29006:error:0E065068:configuration file routines:STR_CO

Re: [GENERAL] encode(bytea_value, 'escape') in PostgreSQL 9.0

2010-12-03 Thread Tom Lane
Florian Weimer writes: > The old 'escape' encoding used by PostgreSQL 8.4 and prior was pretty > helpful for getting human-readable strings in psql. It seems this > functionality was removed in PostgreSQL 9.0. Was this an accident or > a deliberate decision? Could we get it back, please? I thi

[GENERAL] Table design - postgresql solution

2010-12-03 Thread Miguel Vaz
Hi, I have a bit of a DB design question, associated with postgresql in particular, hopefully thinking it could solve my dilemma. This is my setup of 3 tables: Table_1 id_t1 name date_of_discovery history Table_2 id_t2 name type size Table_3 id_t3 name location color I want a solution (table

Re: [GENERAL] Looking for auto starting procedures

2010-12-03 Thread Guillaume Lelarge
Le 03/12/2010 21:22, manfred.braun a écrit : > [...] > Yes, thanks, I am just trying to lern the difference. > I am comin from Sql Server, but I am not a experienced > db developer. But in Sql Server, you may hack your tests > just in a direct statement and if it runs, wrap/put > it in the function

Re: [GENERAL] RESET ROLE and search_path, Connection pool

2010-12-03 Thread Derrick Rice
On Fri, Dec 3, 2010 at 5:13 AM, Marc Mamin wrote: > Hello, > > We are thinking about using a (java based) connection pool. > An issue is that there are many different users to connect. > My idea is to only have superuser connections in the pool > and change the connection role (with SET ROLE) eac

Re: [GENERAL] Looking for auto starting procedures

2010-12-03 Thread manfred.braun
Hello ! Yes, thanks, I am just trying to lern the difference. I am comin from Sql Server, but I am not a experienced db developer. But in Sql Server, you may hack your tests just in a direct statement and if it runs, wrap/put it in the function or procedure. Will need some time ;-) Thanks a lot!

Re: [GENERAL] PG84 and SELinux

2010-12-03 Thread James B. Byrne
On Wed, December 1, 2010 16:54, Tom Lane wrote: > "James B. Byrne" writes: >> Earlier today I attempted to upgrade a production server >> from 8.1 to 8.4 using the pgdg-84-centos.repo. I say >> attempted because I could never get it to support ssl >> connections and as that is a requirement I ha

Re: [GENERAL] how can i bugfix "idle in transaction" lockups ?

2010-12-03 Thread Merlin Moncure
On Fri, Dec 3, 2010 at 12:31 AM, Jonathan Vanasco wrote: > begin w/o commit or rollback? > > and thanks. you've been very helpful! > > On Nov 30, 2010, at 2:21 PM, Merlin Moncure wrote: > >> Begin w/o commit is a grave application error and you should >> consider reworking your code base so that i

Re: [GENERAL] "could not accept SSPI security context"

2010-12-03 Thread Brar Piening
Passing null instead of empty string for the principal shouldn't make any difference as an empty CLR-String should be marshalled to an empty (null terminated) C-String. The problem could also be in InitializeSecurityContext which happens in respnse to AuthenticationGSSContinue. If you happen

[GENERAL] encode(bytea_value, 'escape') in PostgreSQL 9.0

2010-12-03 Thread Florian Weimer
The old 'escape' encoding used by PostgreSQL 8.4 and prior was pretty helpful for getting human-readable strings in psql. It seems this functionality was removed in PostgreSQL 9.0. Was this an accident or a deliberate decision? Could we get it back, please? -- Florian Weimer BF

Re: [GENERAL] PG84 and SELinux

2010-12-03 Thread James B. Byrne
On Thu, December 2, 2010 15:32, James B. Byrne wrote: > > On Thu, December 2, 2010 15:23, Devrim GÜNDÜZ wrote: >> On Wed, 2010-12-01 at 16:54 -0500, Tom Lane wrote: >>> AFAIK, the Red Hat RPMs work out-of-the-box with SELinux; >> >> They should -- we are using the same routines for initdb'ing. >>

[GENERAL] RESET ROLE and search_path, Connection pool

2010-12-03 Thread Marc Mamin
Hello, We are thinking about using a (java based) connection pool. An issue is that there are many different users to connect. My idea is to only have superuser connections in the pool and change the connection role (with SET ROLE) each time a user pick a connection there. However, I'have notic

Re: [GENERAL] PostgreSQL 9.0 RPMs for RHEL 6 and Fedora 14 released

2010-12-03 Thread Devrim GÜNDÜZ
On Sun, 2010-11-21 at 12:39 +0300, Allan Kamau wrote: > > I am unable to obtain (using yum) a version of pgAdmin3 that can > connect fruitfully to postgreSQL 9.x. My installation reports that the > version I do have 1.10.5 is the latest. Should be fixed as of yesterday. Regards, -- Devrim GÜND