Re: [GENERAL] postgre vs MySQL

2008-03-14 Thread Thomas Harold
Leif B. Kristensen wrote: On Friday 14. March 2008, Adrian Klaver wrote: Years ago I played around with MySQL because that was what everybody was using. The problem was it did not do what I wanted and Postgres did. That pretty much sums up my experiences too. Back in 2002 when I started

[GENERAL] Running PostgreSQL in a Xen DomU?

2006-09-14 Thread Thomas Harold
We're slowly trying to move away from hardware dependence for our servers and it looks like Xen is the path. Our primary goal is that if a particular server fails, we can simply migrate the guest OSs to another Xen node and the users will not experience any downtime. Plus it should allow us

Re: [GENERAL] Access to postgres conversion

2011-06-02 Thread Thomas Harold
On 5/25/2011 3:42 PM, akp geek wrote: Dear all - I would like to know if any one has migrated database from MS access to Postgres . We use postgres 9.0.2 on solaris . Are there any open source tools that you have used to do this task. Can you please share your experiences ? I

Re: [GENERAL] Call for design: PostgreSQL mugs

2013-09-12 Thread Thomas Harold
On 9/3/2013 6:08 PM, Andreas 'ads' Scherbaum wrote: PostgreSQL folks! We are looking for the next big thing. Actually, it's a bit smaller: a new design for mugs. So far we had big blue elephants, small blue elephants, frosty elephants, white SQL code on black mugs ... Now it's time to design

Re: [GENERAL] PG replication across DataCenters

2013-12-09 Thread Thomas Harold
On 11/22/2013 5:57 AM, Albe Laurenz wrote: Kaushal Shriyan wrote: I have read on the web that Postgresql DB supports replication across data centers. Any real life usecase examples if it has been implemented by anyone. Well, we replicate a 1 TB database between two locations. It is a fairly

Re: [GENERAL] PG replication across DataCenters (section 25 in the manual)

2013-12-09 Thread Thomas Harold
On 12/9/2013 11:24 AM, Ben Chobot wrote: Out of curiosity what did you find unclear about http://www.postgresql.org/docs/9.3/static/different-replication-solutions.html? Perhaps the Per-table granularity line in the matrix (Table 25-1) might be better written as: Synchronization

[GENERAL] PHP and PostgreSQL 9.0, pg_connect fails to connect

2011-04-27 Thread Thomas Harold
I'm having trouble figuring out where this one is going wrong. It's a brand new install of PostgreSQL 9.0 from PGDG on a RHEL5 box, running Apache 2.2 and PHP 5.3 (from IUS). - PostgreSQL 9.0 is running and listening on the localhost. I can run pgAdmin III and connect to it over a SSH

Re: [GENERAL] PHP and PostgreSQL 9.0, pg_connect fails to connect

2011-04-27 Thread Thomas Harold
On 4/27/2011 9:16 AM, Thomas Harold wrote: - SELinux is running, but there are no denied messages in /var/log/audit/audit.log and no setroubleshooting alerts in /var/log/messages either. Well, interestingly enough it is SELinux getting in the way, but not logging anything. Temporarily

Re: [GENERAL] PHP and PostgreSQL 9.0, pg_connect fails to connect

2011-04-27 Thread Thomas Harold
On 4/27/2011 11:42 AM, Thomas Harold wrote: On 4/27/2011 9:16 AM, Thomas Harold wrote: - SELinux is running, but there are no denied messages in /var/log/audit/audit.log and no setroubleshooting alerts in /var/log/messages either. Well, interestingly enough it is SELinux getting in the way

Re: [GENERAL] PHP and PostgreSQL 9.0, pg_connect fails to connect

2011-04-27 Thread Thomas Harold
On 4/27/2011 12:24 PM, Michael Nolan wrote: On Wed, Apr 27, 2011 at 10:42 AM, Thomas Harold thomas-li...@nybeta.com mailto:thomas-li...@nybeta.com wrote: On 4/27/2011 9:16 AM, Thomas Harold wrote: - SELinux is running, but there are no denied messages in /var/log/audit