Re: [ADMIN] pg_hba.conf is driving me nuts

Peter Eisentraut a écrit : Julio Leyva wrote: also make sure you started postgesql with -i option, so you can connect from the lan He said he had set listen_addresses to '*', which is equivalent. to allow every one : hostall all 0.0.0.0 0.0.0.0

Re: [ADMIN] improve performance in a big table

, olivier boissard [EMAIL PROTECTED] wrote: A.Burbello a écrit : Hi people, I have a case and I got a doubt what should be the best ways. One table has more than 150 million of rows, and I thought that could divided by state. For each row has person ID, state and other informations

Re: [ADMIN] improve performance in a big table

? Olivier -- Olivier BOISSARD [EMAIL PROTECTED] CERENE SERVICES SA 3, rue Archimède 10600 La Chapelle-Saint-Luc - France Tel : 33 (0)3 25 74 11 78 Fax : 33 (0)3 25 78 39 67 Ce message peut contenir des informations confidentielles et/ou protégées. Il est à l'usage exclusif

[ADMIN] except command

Hello I tried to use the except command in postgresql 8.1 I don't understand as it works When I read doc , I understand that it was like a difference betwwen two queries However , It looks as if the 2nd part was ignored I tried to test by dblink a query unising except on the same database

Re: [ADMIN] database encryption

Bruce Momjian a écrit : Michael Fuhr wrote: On Thu, Feb 08, 2007 at 09:13:48AM +0100, Olivier Boissard wrote: I was thinking about a system in which only the php programs will be able to manage stored informations. In case of theft or unexpected access to servers nobody could be able

Re: [ADMIN] database encryption

Andrew Sullivan a écrit : On Wed, Feb 07, 2007 at 11:23:03AM +0100, Olivier Boissard wrote: I saw on the web that there is a contrib (pgcypto) but I can't estimate its efficiency Well, it works for some people. What are you trying to accomplish with database encryption? A I

[ADMIN] database encryption

Hello, I'd like to know which solutions exist encrypt postgresql database ? Did you already use an encryption method ? I saw on the web that there is a contrib (pgcypto) but I can't estimate its efficiency Olivier begin:vcard fn:Olivier Boissard n:Boissard;Olivier org:Cerene Services

Re: [ADMIN] table comparison

Guillaume Lelarge a écrit : Olivier Boissard a écrit : I'd like to compare postgresql tables content between 2 servers after a replication. Do you know which tools can do this ? If you don't mind using a non-free product, there are DB Comparer for PostgreSQL (http://sqlmanager.net/fr

[ADMIN] table comparison

Hello I'd like to compare postgresql tables content between 2 servers after a replication. Do you know which tools can do this ? I tried pg_comparator but not succeed to make it running. When I wrote replication , I 'd to tell you that I made my own scripts to do it as I don't know how to

Re: [ADMIN] Suggestions needed about how to dump/restore a database

Chris Hoover a écrit : One other option is to shut the database down competely, and then do a copy of the file system the new server. I have done this when I need to move a very large database to a new server. I can copy 500GB's in a couple of hours, where restoring my large databases

Re: [ADMIN] call an external script from pgsql

Peter Eisentraut wrote: Am Donnerstag, 2. März 2006 16:53 schrieb Olivier Boissard: I would like to call an external shell script from a trigger. I use actually pgplsh. It works fine but there is a lot of problem with special characters. Details please. In addition I can

[ADMIN] dump and constraints

I' d like to know if it's possible to deactivate all constraints for a database dump and reactivate them after restoration complete thanks begin:vcard fn:Olivier Boissard n:Boissard;Olivier org:Cerene Services adr:;; 3 rue Archimede;La Chapelle Saint Luc;;1;France email;internet:[EMAIL