[ADMIN] Transaction ID overrun problem on greenplum

2012-05-18 Thread Little, Douglas
Hello, Apologies in advance for asking here and not on the greenplum forum, but I'm asking here because I think the PG community understands pg better than Greenplum. We run Greenplum 4.1 which is based on PG 8.2.15 We recently had a problem where the transaction ID overflowed an internal buff

Re: [ADMIN] Transaction ID overrun problem on greenplum

2012-05-18 Thread Scott Marlowe
Can you run db wide vacuums? That's what I'd try first. On Fri, May 18, 2012 at 10:41 AM, Little, Douglas wrote: > Hello, > > Apologies in advance for asking here and not on the greenplum forum, but > I’m asking here because I think the PG community understands pg better than > Greenplum. > > >

[ADMIN] Problem with SSL certificate setup

2012-05-18 Thread Robert Bruccoleri
Dear Colleagues, I'm trying to setup a PostgreSQL server (9.1.0) that will use SSL for I/O and for authenticating the clients. I've been able to create certificates for both server and clients that pass signature verification using 'openssl verify', but I get invalid certificate errors fro

[ADMIN] Problem with SSL certificate setup; please disregard -- solution found.

2012-05-18 Thread Robert Bruccoleri
Dear Colleagues, I found the answer to my own problem -- the root.crl (Certificate revocation list) was malformed. When I deleted the root.crl files from the client and server locations, everything works as advertised. For anyone who looked at my problem, thank you. Cheers, Bob