Re: [GENERAL] PostgreSQL 8.3.4 Solaris x86 compilation issues

2008-11-01 Thread postgres Emanuel CALVO FRANCO
do you just read FAQ_Solaris in the docs. I don't remember at all, but is explain some steps to run with SSL. 2008/11/1, Zdenek Kotala [EMAIL PROTECTED]: Hi, It is really strange. Is there any reason why you don't use integrated SSL? 64bit version is located in /usr/sfw/lib/64 Try

Re: [GENERAL] Replication with slony-I

2008-10-27 Thread postgres Emanuel CALVO FRANCO
http://slony.blogspot.com/ sorry is in spanish, but is an exelent resource, i hope it will be useful reggards 2008/10/27 Abdul Rahman [EMAIL PROTECTED]: May any one support step by step procedure for the replication with slony-I in windows xp. -- Emanuel Calvo Franco Syscope

Re: [GENERAL] How to free disk space

2008-10-21 Thread postgres Emanuel CALVO FRANCO
After run VACUUM, you must run REINDEXDB to decrease indexes. You can pg_resetxlog too, but you need restart server to do that. 2008/10/21 Ruben Blanco [EMAIL PROTECTED]: Hi: My database is growing fast taking too much disk space. How can I free disk space without performing a VACCUM FULL?

Re: [GENERAL] databases list to file

2008-10-14 Thread postgres Emanuel CALVO FRANCO
inside psql turn \o file then \l 2008/10/9 Jeff Ross [EMAIL PROTECTED]: Joao Ferreira gmail wrote: Hello all, I need to print to a file a simple list of all the databases on my postgresql. I need to do this from a shell script to be executed without human intervention I guess

Re: [GENERAL] Opteron vs. Xeon performance differences

2008-10-10 Thread postgres Emanuel CALVO FRANCO
How do you manage the wal in both servers? The version kernel is the same in both? Runs the same services? Do you make some test with Posgresql only in both servers? If the problem is the inter-CPU, i know you can specified the number of processors do you want to run dedicated to one process.

Re: [GENERAL] Opteron vs. Xeon performance differences

2008-10-10 Thread postgres Emanuel CALVO FRANCO
When i question about WAL, i mean if WAL is in other drive. You must run a benchmark more expensive to cpu for make a conclusion. Make a query that have more of 8 seconds, then you can see really if exists a diference in other way... i think you don't use the same image of the old server in the

Re: [GENERAL] [HACKERS] PostgreSQL future ideas

2008-09-29 Thread postgres Emanuel CALVO FRANCO
2008/9/27 Douglas McNaught [EMAIL PROTECTED]: On Sat, Sep 27, 2008 at 12:13 PM, Mark Mielke [EMAIL PROTECTED] wrote: If some parts of PostgreSQL are not performance bottlenecks, and they are extremely complicated to write in C, and very easy to write in something else common and simple (I've

Re: [GENERAL] Restoring a database from a file system snapshot

2008-08-27 Thread postgres Emanuel CALVO FRANCO
Sorry Alvaro, i sent to you the message ;P Is the same way (from snapshot) that use Mysql on ZFS. IF you don't change anything in the database, why it don't works? Then you restart the service with the same path. The problem it will be that you need to stop postgres BEFORE snapshot. -- Sent