On 2011-02-16 04:51, Greg Smith wrote:
Debian and Ubuntu installations have a unique feature where you can
have multiple PostgreSQL installations installed at the same time.
That's pretty easy to do with any Linux distribution.
--
Mail to my list address MUST be sent via the mailing list.
About a month ago I upgraded five Linux (CentOS 4.4) DB boxes (for load
balancing) from 8.3.0 to 9.0.1 in order to use replication, which I
needed for a new web/DB application. The replication configuration went
well, and all the four hot_standby servers are (streaming) replicating
just fine
Previously posted in [ADMIN]:
Two days ago I upgraded five DB boxes (for load balancing) from 8.3.0 to
9.0.1 in order to use replication. The replication configuration went
reasonably well, and now all the four hot_standby servers are
(streaming) replicating just fine from the primary DB
I'm getting this loading some large (1 million row) tables. Is this
anything to be concerned about?
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Now, that I have 8.3.0 installed running auto-vacuum, I have gotten
rid of all my scripted VACUUMs, and I would like to get rid of all the
scripted ANALYZEs as well. The 8.3 docs say:
In the default PostgreSQL configuration, /The Auto-Vacuum Daemon/
On 2008-02-07 01:17, Tino Schwarze wrote:
Hi Dean,
On Wed, Feb 06, 2008 at 06:29:02PM -0800, Dean Gibson (DB Administrator) wrote:
2. ... Should I be running INITDB w/ -locale POSIX -E UTF8, or just -locale POSIX (implying
-E SQL_ASCII)? Or does it make a difference, since I always
I got a small surprise when upgrading to 8.3.0 today (CentOS 4.4). When
I went to restore my database, PSQL complained that my CREATE
DATABASE... ENCODING 'UTF8'; wasn't valid (the new phpBB 3.0 software
enforces using UTF8). Sure enough, a bit of research showed that the
supplied