Re: [ADMIN] PGadmin PostgresSQL

What do you mean by 'uploading databases'? I.e. what commands do you issue? Dick Sent from my Iphone On 31 mrt. 2012, at 03:09, Tim Dons wrote: Dear PGAdmin support, We have some troubles with uploading databases to a server of a client on the internet. If we upload the database the conn

[ADMIN] mailing CSV results

Maybe a bit off-topic for this list, but it might be convenient for other admins and users: https://confluence.terena.org/display/~visser/Mailing+CSV+files+from+PostgreSQL It saved us lots of tedious work.. DIck -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make change

Re: [ADMIN] Cannot restore dumps made with -Fc and --column-inserts

On 4 January 2012 19:14, Tom Lane wrote: > Dick Visser writes: >> Running pg on Ubuntu 10.04 64bit, which is 8.4.9 today. >> When I do a pg_dump using --column-inserts, the subsequent restore fails: > > Ugh ... I think I broke this :-(. > > As a workaround, you can as

Re: [ADMIN] List archives dead?

Hm. I swear there was a directory listing a few hours ago. I searched on Google and any links deeper in that web server gave me a 404. But nevermind, it is online again. On 4 January 2012 17:33, Tom Lane wrote: > Dick Visser writes: >> The archive lists web server seems to

[ADMIN] List archives dead?

The archive lists web server seems to have been reinstalled or something, there is no content any more, just an empty Lighty page from old years day: http://archives.postgresql.org/ No announcement on the Postgres homepage... is this scheduled maintenance? -- Dick Visser System & Networ

[ADMIN] Cannot restore dumps made with -Fc and --column-inserts

can be loaded into non-PostgreSQL databases". In any case, it would it be great to raise an error when calling pg_dump with both options. Finding out that dumps are unusable at restore time is not very nice ;-) THanks!! -- Dick Visser System & Networking Engineer TERENA Secret

[ADMIN] (no subject)

-- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] (no subject)

-- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] Background triggers?

using NOTIFY/LISTEN, but WITHOUT an external client doing the magic? Some kind of internal Postgres function that listens for any changes, and then does the magic itself, without tying up any 'real' clients for the duration of that magic? Thanks! -- Dick Visser -- Sent via pgsql-admin ma

Re: [ADMIN] binary vs. txt dumps with pg

ue. What I forgot to mention is that our backups are made with rsnapshot. This means that if files have changed, a complete copy of the file is backupped -- * *** Dick Visser TIENHUIS Networking ** * *Touwbaan 68 P: +31206843731 * * ***1018

Re: [ADMIN] upgrading a three year old server

27;UTF8-proof' from the beginning. If everything is setup correct, you might see really cool strings appear on user-filled-in forms: http://www.terena.nl/compendium/2005/basicinfo.php?nrenid=26 :) Best regards, -- **** Dick Visser TIENHUIS Networking ** * *

Re: [ADMIN] binary vs. txt dumps with pg

mp? You could work around it by disgarding the first X bytes when checksumming. Any idea what X would be? Best regards, -- * *** Dick Visser TIENHUIS Networking ** * *Touwbaan 68 P: +31206843731 * * ***1018 HS Amsterdam F: +31208641420 *

[ADMIN] binary vs. txt dumps with pg

his would be very helpfull. The txt dumps I use now are OK but are really big and slow to dump/restore. Best regards, -- **** Dick Visser TIENHUIS Networking ** * *Touwbaan 68 P: +31206843731 * * ***1018 HS Amsterdam F: +31208641420 * *