Re: PostgreSQL and OpenVZ - Mailing list pgsql-general

Hi,

I use this approach both for development and backup servers (with PITR). Everything runs very smoothly. You should, of
course,keep an eye on /proc/user_beancounters and diskquota to ensure that the engines have enough shared memory,
networkio (both sockets and buffer, tcp and "other") and disk space. Stock values are too low. 
 

That__s not a real problem, though, because you can adjust all the values while running the server, but be careful to
adjustshared memory before going in production, otherwise you might have to restart the database engine.
 

For production I use several medium loaded OpenVZ machines with apache webservers, but one dedicated physical machine
forthe database engine, keeping one database for each webserver. I did not use one database engine per server, because
Ithink, that it is more effective to use all its physical memory for one engine instead of dividing it into parts for
severalengines.  This is an unproven theory of mine, I did not have enough time to evaluate it.
 

In principle I found no problems other than giving the OpenVZ server enough ressources. Though I did not do any speed
comparisons"native" vs. "OpenVZ", I could do some benchmarking next week, if you need some values. 
 

For the PITR OpenVZ PostgreSQL backup server I even copy the WALs etc. using the base system into /vz/private/... while
theOpenVZ database server is down. As soon as I fire up the OpenVZ database server, it uses the copied stuff while
startingup. Because the OpenVZ server starts with the same IP like the main database server, there is no need to change
anythingelse while switching from main server to backup server.
 

Regards, Frank.



On Fri, 30 Jun 2006 18:37:27 +0400 "Ivan Zolotukhin" <ivan.zolotukhin@gmail.com> thought long, then sat down and
wrote:

> Hello,
> 
> Does anybody have experience in running PostgreSQL inside OpenVZ
> (http://openvz.org/) or any other virtual private servers solutions?
> I'm interested in both cases of running single PostgreSQL server and
> multiple PostgreSQLs on one physical machine under relatively high
> (though not IO-limited) load.
> 
> Any caveats or limitations of this approach? Any known penalties or
> problems with this tandem?
> 
> Best regards,
> Ivan Zolotukhin
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly


-- 
Frank Finner

Invenius - Lösungen mit Linux
Köpfchenstraße 36
57072 Siegen
Telefon: 0271 231 8606    Mail: frank.finner@invenius.de
Telefax: 0271 231 8608    Web:  http://www.invenius.de
Key fingerprint = 90DF FF40 582E 6D6B BADF  6E6A A74E 67E4 E788 2651