postgres -d -Q
Use 'show help;' to see available commands.
copy output of show consumer command
show consumer;
Rene
From: pgsql-general-ow...@postgresql.org
on behalf of Leonardo M. Ramé
Sent: Thursday, May 19, 2016 2:43 PM
To: PostgreS
state, query_start from pg_stat_activity where state='idle in
transaction';" for checking sessions.
Rene
From: pgsql-general-ow...@postgresql.org
on behalf of Leonardo M. Ramé
Sent: Wednesday, May 18, 2016 10:23 PM
To: PostgreSql-gener
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
table.
If your main insert/update process knows into which partition to insert,
you can speed that up even more; while still beeing able to use the
automated partitioning for everything else.
LG
Rene
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
y, a table with one or only a few rows is very likely to be cached
in RAM by postgres anyway if you access it regulary. So performance
shouldn't be an issue.
LG
Rene
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgres
Alvaro Herrera wrote:
Rene Schickbauer escribió:
Hi!
I'm looking into implementing an updateable "virtual" table using pl/perl.
What i basically want to do is read out/update some external
resources. For programs using the SQL interface, this should look
just like a regular ta
no rollbacks).
I'm pretty sure i can make a table, write a bunch of functions and some
do-instead rules. But is there a more elegant/simple solution?
LG
Rene
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
15 matches
Mail list logo
