It depends on the database transactional activity,
observe how many new wal files are generated during a period equivalent to
what it takes to do your base backup. I would set it to twice that number.
Take into account that a checkpoint is issued at the beginning of the
process. If you're lazy just
As far as I'm concerned, you cannot inherit role settings, only privileges.
http://www.postgresql.org/docs/9.3/static/role-membership.html
2014-06-23 20:12 GMT-05:00 Rene Romero Benavides :
> To impersonate another role, as a superuser or group member use:
> SET SESSION AUTHORIZ
To impersonate another role, as a superuser or group member use:
SET SESSION AUTHORIZATION user1;
http://www.postgresql.org/docs/9.3/static/sql-set-session-authorization.html
Regards.
2014-06-23 8:25 GMT-05:00 McGehee, Robert :
> Hi,
>
> I'm trying to set the default statement_timeout paramete
Try dumping the database, you might have a damaged table as in this case:
http://www.postgresql.org/message-id/cagwygjwpiffet_k6qvxjjqo_jrqiueu+bszr1hurrh1obv8...@mail.gmail.com
good luck.
2014-05-03 18:59 GMT-05:00 David G Johnston :
> DrakoRod wrote
> > Hi everybody!
> >
> > I have a problem
0 Stephen Frost :
> * Rene Romero Benavides (rene.romer...@gmail.com) wrote:
> > Yep, I checked:
> >
> > [postgres@uxmal standby_node]$ /bin/tar -xzf
> > /db/wal_archives/000101ED00FB.tar.gz -C
> > /db/standby_node/pg_xlog/
> > [postgres@uxmal stan
I read somewhere that in order for the extracted file to be placed at a
custom location you had to use that option -C
I'll try rewriting the command and debug it. Thanks for your comment.
2014-04-13 21:39 GMT-05:00 Stephen Frost :
> Rene,
>
> * Rene Romero Benavides (rene.rome
- Base backup taken with 9.2.6 (via pg_basebackup command)
- binaries updated to 9.2.8
- set up the base backup to replicate from the master and archives, and
started
- the restore_command option is ignored, with the following message:
2014-04-13 21:07:21.386 CDT,,,22055,,534b42d7.5627,4,,2014-04-
On Wednesday 18 July 2012 16:11:21 jg wrote:
> Hi,
>
> The PostgreSQK documentation refers to diskchecker.pl on the page
> http://brad.livejournal.com/2116715.html But on this page, the given link
> for diskchecker.pl does not exist anymore. After some unsuccessfull queries
> on Google to find the
On 01/14/2012 09:22 PM, plasmasoftware net wrote:
hello ...
i have stock table all stock in smallest unit ( PCS )
i have stock table like this
name qty unit
PCA 20 PCS
MOUSE 25 PCS
i have table unit
1 KRT = 12 PAK
1 PAK = 10 PCS
how to make select to display report stok in dbGRID like
