Hi Mark,
Il 12/11/10 03:31, mark ha scritto:
I have listed what I think I will be doing with regards to initdb. if anyone
sees problems with the following mixture during my dump -> init-> restore I
would be most keen in hearing about it.
FYI, PostgreSQL 8.4 introduced database level collation.
Hi all,
So today while I investigating some slow queries I found out that some time
ago some of our databases (due, innocently I suspect, to upgrades or
hardware migrations) are now not using C as lc_ctype. And why some 'things'
got a lot slower...
To correct this problem it seems like I am going
On Fri, 2010-11-12 at 01:34 +0100, Michal Seidl wrote:
> Hello,
> I would like to set up database as private as much as possible. The
> basic problem is that default access for 'PUBLIC' allows any user to get
> information about other existing databases, users, schemas, tables etc.
>
> I think o
Hello,
I would like to set up database as private as much as possible. The
basic problem is that default access for 'PUBLIC' allows any user to get
information about other existing databases, users, schemas, tables etc.
I think of something like
REVOKE ALL ON SCHEMA pg_catalog FROM PUBLIC
REVO
Dragos Valentin Moinescu wrote:
> How can I easile migrate the 2 slaves on the new master without
> creating a new base backup (which unfortunately takes too long as
> the databases contain arround 200GB)?
Have you tested rsync using a daemon from the new master (after
pg_start_backup) to the
Hello,
I have an issue with the following architecture:
1. master
3. slaves with streaming replication (used for backup and read-only queries)
When the master goes offline, 1 of the slaves must become master. Thus
I am creating trigger_file and the slave becomes the master.
The problem is that t
Actually, if you are using DRBD as shared disk HA solution (am I correct or
you are using postgresql replication, like streaming and hot standby?),
then all the PG_DATA directory has to be on DRBD.
So, if you power off your 1st node and start your second (pointing the same
DRBD PG_DATA direct
