Hi all,
I am currently using postgresql 9.2 installation.
While taking base backups using pg_basebackup utility, I noticed that
permissions of the directory which i specify for base backup are set to
777. Does postgesql need such lenient permissions to work, coz 777 on Db
directory seems a securit
Hello People,
I need some clarification on Continuous Archiving and Point-In-Time
Recovery (PITR).
I have been able to replicate a postgresql 8.4 database from one machine
to another using rsync and wal files.
I do this as follows (Using debian gnu/linux squeeze):
In *master* i have the followi
Rafael Domiciano wrote:
> PostgreSQL 9.2.2 on x86_64-unknown-linux-gnu, compiled by gcc
> (GCC) 4.4.6 20120305 (Red Hat 4.4.6-4), 64-bit
> CentOS release 6.3 (Final)
> Since 2 weeks I'm get stucked in a very strange situation: from
> time to time (sometimes with intervals less than 10 minutes),
*
*
On Mon, Jul 15, 2013 at 11:24 PM, Mónica Gamarra
wrote:
> Hello,
> I am planning to upgrade our databases from 9.0.4 to 9.1.3
> and I found a problem while upgrading one database that has
> many tablespaces. The upgrade fails with the following error
>
> "Cannot migrate to/from the same syste
Hello,
I am planning to upgrade our databases from 9.0.4 to 9.1.3
and I found a problem while upgrading one database that has
many tablespaces. The upgrade fails with the following error
"Cannot migrate to/from the same system catalog version
when using tablespaces"
Why 9.0.4 and 9.1.3 are same
On Mon, Jul 15, 2013 at 1:47 AM, Bruce Momjian wrote:
>> In future I suggest you to use --check (from docs: check clusters
>> only, don't change any data) when performing pg_upgrade first. I will
>> show you all the errors but will not affect your cluster. And you can
>> use safe it on a running i
Joshua,
We are running centos 6.2. Could you provide some insight or point in the
direction of your methodology for such implementation?
Thanks
JT
On Mon, Jul 15, 2013 at 9:15 AM, Joshua D. Drake wrote:
>
> On 7/15/2013 8:55 AM, Jorge Torralba wrote:
>
>> I have a master and a slave running s
On 15-07-2013 19:14, Eduardo Morras wrote:
On Mon, 15 Jul 2013 10:16:19 -0300
Rafael Domiciano wrote:
I'm not a Linux expert, I'm a BSD man, but
a) do you have an interrupt storm?
b) what does postgres do before the hang?
c) do you have anyother software running? Including contrib modules. It
On 7/15/2013 8:55 AM, Jorge Torralba wrote:
I have a master and a slave running streaming replication between the
two servers. I would like to setup some kind of third machine to play
the role of observer node to monitor the replication and do the
automatic fail over. However, I can't find an
I have a master and a slave running streaming replication between the two
servers. I would like to setup some kind of third machine to play the role
of observer node to monitor the replication and do the automatic fail over.
However, I can't find any documentation or suggestions on such an
impleme
Hello,
it seems ( for quite some time now ) that PostgreSQL is using the -c option of iconv when exporting data to a different encoding:
http://www.gnu.org/savannah-checkouts/gnu/libiconv/documentation/libiconv-1.13/iconv.1.html
- e.g. the Euro sign is removed when exporting LATIN1 databas
On Mon, Jul 15, 2013 at 7:14 PM, Eduardo Morras wrote:
> On Mon, 15 Jul 2013 10:16:19 -0300
> Rafael Domiciano wrote:
>
> I'm not a Linux expert, I'm a BSD man, but
>
> a) do you have an interrupt storm?
> b) what does postgres do before the hang?
> c) do you have anyother software running? Incl
On Mon, 15 Jul 2013 10:16:19 -0300
Rafael Domiciano wrote:
I'm not a Linux expert, I'm a BSD man, but
a) do you have an interrupt storm?
b) what does postgres do before the hang?
c) do you have anyother software running? Including contrib modules. It may be
a dns lookup timeout (watch port 53
>
> > Hello,
> >
> > I was just wondering: Is it possible to restore a specific table from an
> > online backup?
> > Or is it only possible if we first restore the backup, replay all the
> > logs,
> > and then take the table files?
> >
>
> It depends on how you do the copy. To do comados with SQL,
> Hello,
>
> I was just wondering: Is it possible to restore a specific table from an
> online backup?
> Or is it only possible if we first restore the backup, replay all the
> logs,
> and then take the table files?
>
It depends on how you do the copy. To do comados with SQL, you can find to
wit
Hello all you guys,
I've sent the same problem in performance list. Some answered me, but
didn't resolved the situation.
Since 2 weeks I'm get stucked in a very strange situation: from time to
time (sometimes with intervals less than 10 minutes), the server get
"stucked"/"hang" (I dont know how t
Hello,
I was just wondering: Is it possible to restore a specific table from an
online backup?
Or is it only possible if we first restore the backup, replay all the logs,
and then take the table files?
wkr,
Bert Desmet
On Sun, Jul 14, 2013 at 10:42:22PM -0700, Sergey Konoplev wrote:
> On Thu, Jul 11, 2013 at 9:55 PM, Wells Oliver wrote:
> > Command executed:
> >
> > time \
> > /usr/lib/postgresql/9.2/bin/pg_upgrade -k \
> > -b /usr/lib/postgresql/9.1/bin \
> > -B /usr/lib/postgresql/9.2/bin \
> > -d
18 matches
Mail list logo