Thanks Christophe! I guess I had nothing to be worried about.
On Mon, Mar 8, 2021 at 9:46 AM Christophe Pettus wrote:
>
>
> > On Mar 7, 2021, at 17:34, Abdul Qoyyuum
> wrote:
> > Seems to get me worried. Should I be worried? Is this normal? If not,
> what should I do?
>
> It's normal. Every co
> On Mar 7, 2021, at 17:34, Abdul Qoyyuum wrote:
> Seems to get me worried. Should I be worried? Is this normal? If not, what
> should I do?
It's normal. Every connected client has an associated backend process, even if
the client isn't doing anything. That's what the "idle" state means.
Hi all, I have a database cluster running Postgresql 9.6 on RHEL 6 servers.
I've noticed a lot of idle processes in the master database as opposed to
the slave database and from the looks of pg_activity, they're all idle
statements like "SELECT 1". Forums and StackOverflow seems to suggest its
noth
Paul McGarry writes:
> Is it possible for a non-owner or non super user to be given permission to
> vacuum tables in the DB?
> My initial thought is no, but the documentation says:
> "To vacuum a table, one must ordinarily be the table's owner or a
> superuser."
The full quote is
To vacuum a
On Sun, Mar 07, 2021 at 11:45:26AM +0200, Andrus wrote:
> Should files with .deleted extension deleted manually to save disk space ?
> May of them have dates before today.
RemoveOldXlogFiles() would discard any of those .deleted files because
they don't match a legal WAL segment name, so checkpoin
Is it possible for a non-owner or non super user to be given permission to
vacuum tables in the DB?
My initial thought is no, but the documentation says:
"To vacuum a table, one must ordinarily be the table's owner or a
superuser."
Where the "ordinarily" seems to imply there might be some non-or
On 3/7/21 10:48 AM, Bysani, Ram wrote:
PostgreSQL version: 11.11
Operating system: Linux 64 bit
Description:
Greetings
We have found posts on several forums that Stored Procedures are not
supported in PostGreSQL databasel.
We looked at the documentation but it is not clear when Stored Pr
On Sun, Mar 7, 2021 at 11:49 AM Bysani, Ram wrote:
> Please provide details / clarify if Stored Procedures are available in
> versions 11.x, 12.x, 13.x Please also confirm when it was actually added.
>
> https://www.postgresql.org/docs/
>
https://www.postgresql.org/docs/current/sql-createprocedur
PostgreSQL version: 11.11
Operating system: Linux 64 bit
Description:
Greetings
We have found posts on several forums that Stored Procedures are not supported
in PostGreSQL databasel.
We looked at the documentation but it is not clear when Stored Procedure
support was added. We are awa
Hi!
On Windows, RemoveXlogFile() would still rename a given WAL segment
file with a ".deleted" suffix with ou without wal_recycle in the case
where the a recycling of a WAL segment is not necessary, for example
if max_wal_size is already full. So this has no effect.
Should files with .deleted
On Sat, Mar 06, 2021 at 07:53:11PM +0200, Andrus wrote:
> I changed wal_recycle to off. So checkpointer should no more try to rename
> wal files. Iit still tries to rename files. No idea way it does not use this
> setting:
On Windows, RemoveXlogFile() would still rename a given WAL segment
file wi
11 matches
Mail list logo
