Hi Alvaro Herrera,
Since, my original plan was to run the auto-vacuum daily EXACTLY at 5 am, I
wanted to know which seconds of a minute. My query in other word was, if I set
autovacuum_naptime to 1 hr, which minute of an hour the auto-vacuum runs (oth
min, 15th min or something else).
>From th
On Wed, May 19, 2010 at 3:21 PM, Ray Stell wrote:
> On Wed, May 19, 2010 at 08:40:04AM +0300, Mikko Partio wrote:
> >
> > May 16 01:17:35 xxx postgres[25550]: [1-1] LOG: could not truncate
> > directory "pg_subtrans": apparent wraparound
> >
>
> http://archives.postgresql.org/pgsql-general/2007-
On Wed, May 19, 2010 at 10:01 PM, Tom Lane wrote:
> Mikko Partio writes:
> > got the following line at postgresql log:
> > May 16 01:17:35 xxx postgres[25550]: [1-1] LOG: could not truncate
> > directory "pg_subtrans": apparent wraparound
>
> What's in $PGDATA/pg_subtrans?
>
>
$ ls -l $PGDATA/p
On Wed, May 19, 2010 at 16:25, ALEXANDER JOSE wrote:
> I have a question, I have postgres 8.2.5 on a windows server on another
> machine and I have suse linux enterprise 10 postgres 8.4, you perform a
> backup with pgadmin 1.10 to a database and restore the database in the
> version of postgres 8.
I have a question, I
have postgres 8.2.5 on a windows server on another machine and I have
suse linux enterprise 10 postgres 8.4, you perform a backup with pgadmin
1.10 to a database and restore the database in the version of postgres 8.4
gave me many errors that could not find some functions.
Excerpts from Narasimha Murthy-VRFX87's message of mar may 18 07:04:34 -0400
2010:
> I need some more clarification. autovacuum_naptime takes one minute by
> default. In this case, which second of each minute the autovacuum
> daemon runs (provided it is enabled)?
Why does it matter which second
Mikko Partio writes:
> got the following line at postgresql log:
> May 16 01:17:35 xxx postgres[25550]: [1-1] LOG: could not truncate
> directory "pg_subtrans": apparent wraparound
What's in $PGDATA/pg_subtrans?
regards, tom lane
--
Sent via pgsql-admin mailing list (p
On Wed, May 19, 2010 at 10:38 AM, mnavahan wrote:
>
>>>I think so. Look up "SECURITY DEFINER"
>
> seems goods i need try to it ...
>
>
>>>Not that I know of. You're talking connect / disconnect triggers right?
> YES how do it ?
It's not really doable. However, it's possible that what
>>I think so. Look up "SECURITY DEFINER"
seems goods i need try to it ...
>>Not that I know of. You're talking connect / disconnect triggers right?
YES how do it ?
>>>I use nano or vi for most stuff. Both can do color coding quite nicely
for .sql files.
i need powerful IDE for i
On Wed, May 19, 2010 at 9:39 AM, mnavahan wrote:
>
> I try to move from firebird to postgresql But it seems some option to do hold
> ..
>
>
> 1. In grant section in some reason user ROLE R1 can Access to function F1
> and F1 can access to Table T1 bUT user must not be granted to work directly
> to
I try to move from firebird to postgresql But it seems some option to do hold
..
1. In grant section in some reason user ROLE R1 can Access to function F1
and F1 can access to Table T1 bUT user must not be granted to work directly
to table T1
In firebird ,I can invoke grant to object
To avoid to delete registers I created one trigger activated "before delete"
with lines like that:
UPDATE tableX set dtExc = 'now', userExc = current_user where idTableX =
OLD.idTableX;
return NULL;
but, I need do the same for many tables and I don't catch how.
I created an sql variable to constr
On Wed, May 19, 2010 at 08:40:04AM +0300, Mikko Partio wrote:
>
> May 16 01:17:35 xxx postgres[25550]: [1-1] LOG: could not truncate
> directory "pg_subtrans": apparent wraparound
>
http://archives.postgresql.org/pgsql-general/2007-06/msg01050.php
--
Sent via pgsql-admin mailing list (pgsql-a
13 matches
Mail list logo
