[ADMIN] SSL Connections from Windows Clients

2009-03-03 Thread Richard Stephan
I am having a problem getting the Windows client to work with my Solaris database using SSL connections. In the postgresql\8.3\bin directory there are the libpq.dll andssleay32.dll libraries. I am fairly certain by the tests I have conducted that the client is trying to use SSL but the error i

Re: [ADMIN] Backing up postgresql database

2009-03-03 Thread Scott Marlowe
On Tue, Mar 3, 2009 at 5:51 PM, Jakov Sosic wrote: > Scott Marlowe wrote: > >> That might not be much smaller if you're doing a lot of updates / >> inserts / deletes.  Also, SQL ain't the same as what was committed. If >> you insert now() it won't be the same when you run it in two days. > > Well

Re: [ADMIN] Backing up postgresql database

2009-03-03 Thread Jakov Sosic
Scott Marlowe wrote: > That might not be much smaller if you're doing a lot of updates / > inserts / deletes. Also, SQL ain't the same as what was committed. If > you insert now() it won't be the same when you run it in two days. Well I think I miscalculated a little bit... It's more like a 120

Re: [ADMIN] Backing up postgresql database

2009-03-03 Thread Scott Marlowe
On Tue, Mar 3, 2009 at 4:49 PM, Jakov Sosic wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Kevin Grittner wrote: > >> What you are copying is all the information required to restore the >> database to the state it was in after the commit of any one of these >> transactions.  Out of c

Re: [ADMIN] Backing up postgresql database

2009-03-03 Thread Jakov Sosic
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kevin Grittner wrote: > What you are copying is all the information required to restore the > database to the state it was in after the commit of any one of these > transactions. Out of curiosity, how much space would you have thought > that would ta

Re: [ADMIN] Backing up postgresql database

2009-03-03 Thread Kevin Grittner
>>> Jakov Sosic wrote: > I have a problem with WAL files... I have a fairly busy server, with > lots of transactions every second. Database is backend for Zabbix > monitoring application, and it writes performance counters of 500+ > hosts every few seconds. > > I'm trying to implement "Continuou

[ADMIN] Backing up postgresql database

2009-03-03 Thread Jakov Sosic
Hi! I have a problem with WAL files... I have a fairly busy server, with lots of transactions every second. Database is backend for Zabbix monitoring application, and it writes performance counters of 500+ hosts every few seconds. DB is approx 150GB. I'm trying to implement "Continuous Archiving"

[ADMIN] How to change pg_largeobject tablespaces?

2009-03-03 Thread Nelson Gonzaga
Hi, I create a lot of tablespaces and now I like to split tables, indexes and lo in many HD, but I don´t get to change the tablespace of the pg_largeobject: alter table pg_largeobject set tablespace tbs_lo; ERROR:  permission denied: "pg_largeobject" is a system catalog How to avoid this error o

[ADMIN] Troubles with pgagent

2009-03-03 Thread Alejandro D. Burne
Trying to install pgagent on Centos 5.2, (pgadmin 1.8.4). I compiled wxGTK without problems and pgadmin ok too; but when I run pgagent gives: /usr/local/pgadmin3/bin/pgagent: error while loading shared libraries: libwx_baseu-2.8.so.0: cannot open shared object file: No such file or directory look