Hello Everyone,
I recently noticed the difference between PG15 and PG16 regarding *CREATEROLE
*and ADMIN OPTION.
Granting the Admin Option to another role is not allowed in PG16, whereas
it was permitted in PG15. Please help me with how we can allow them without
superuser intervention.
PostgreSQ
Hello All,
Is it possible to migrate the spannerdb database into PostgreSQL? If yes,
which tool can we refer to migrate it?
-Pawan
at 05:58:03PM +0530, Pawan Sharma wrote:
> > Is there a way to monitor the replication lag, where replica nodes are
> > configured through aws s3.
>
> You can check it on replica, by issuing:
> select now() - pg_last_xact_replay_timestamp();
>
> and it will show you, more
Hello Team,
Is there a way to monitor the replication lag, where replica nodes are
configured through aws s3.
Is not in a synced replica setup where master node will push the wal files
to aws s3 and we are taking and replaying those wal files on a replica node.
-Pawan
Yes I will show the pgadmin in stat_activity but how can block that..
I think I need to create a job to terminate the pgadmin connections and
schedule it for every 5 min and so that I will check any new connections
from pgadmin.
On Mon, 3 Feb 2020, 11:13 pm Adrian Klaver,
wrote:
> On 2/3/20 9
Hi All,
Is there any way to restrict the connection only from pgadmin??? The same
user can connect through application but can't from pgadmin.. Or any logon
triggers..???
Hi All,
Having real high CPU issue (95-98%), with SELECT statements and select
queries contains multiple AND operator, is it will cause any CPU Spike..???
apps team is using sub-partition, PG11, CPU:24, Mem: 16GB
```test=# show shared_buffers ;
shared_buffers
7680MB
(1 row)
t
Hello All,
How the Auto vacuum works on logical partition tables in PostgreSQL 11.
Currently, we are using database in PG10 with logical partition of tables
and we are facing an performance issue due to large number of bloats.
Actually we have notice that Auto vacuum in PG10 keeps vacuuming the
Ya this is because of ANALYZE.
now it's working fine.
Thanks for your support.
On Tue, Jun 25, 2019, 8:03 PM Adrian Klaver
wrote:
> On 6/25/19 7:24 AM, Pawan Sharma wrote:
> > In PostgreSQL logs it's showing select queries are running with duration
> > approx 37
In PostgreSQL logs it's showing select queries are running with duration
approx 37001.347ms
On Tue, Jun 25, 2019, 7:44 PM Adrian Klaver
wrote:
> On 6/25/19 7:06 AM, Pawan Sharma wrote:
> > Can the app connect at all?
> > - yes connection between database and app B is succ
there other error messages before or after the above?
-no there, nothing and after.
On Tue, Jun 25, 2019 at 7:25 PM Adrian Klaver
wrote:
> On 6/25/19 6:49 AM, Pawan Sharma wrote:
> > Hi All,
> >
> >
> > I have upgarded my PostgreSQL database from 10 to 11 versi
Hi All,
I have upgarded my PostgreSQL database from 10 to 11 version using pg_dump
method.
That database is used by two apps.
1. A (most of the transaction are SELECT AND INSERT)
2. B ( most of the transaction UPDATE AND DELETE)
After the upgarde I am facing *error:connection is not availa
:00:38AM +0300, Achilleas Mantzios wrote:
> > On 10/6/19 7:36 π.μ., Pawan Sharma wrote:
> >> What is the best way to upgrade from PostgreSQL 9.6 to PostgreSQL
> >> 11 instead of pg_upgrade.
> >
> > why not pg_upgrade ? If the size is near the 3TB mark as you
Hello All.
What is the best way to upgrade from PostgreSQL 9.6 to PostgreSQL 11
instead of pg_upgrade.
- Less downtime.
- Approx database size are 1-3TB.
Thanks for your help..!!!
Regards,
Pawan
Hello All,
Is it possible check privileges of all the users or roles, and what are the
objects owned by user and role with their privileges.
I am getting the output which want from
information_schema.roles_usage_grants, but as I not running the query as a
superuser so I am able to see only one sp
Hi All,
Please let me know the reasons of release upgrade failure in PostgreSQL
which you guys faced while doing it.
Example: 9.5.1 to 9.5.2
On Feb 22, 2018 11:16 AM, "Pavel Stehule" wrote:
Hi
2018-02-22 5:59 GMT+01:00 Marcin Giedz :
> Hi, there are at least 5 tools I found on the PG list but could you
> recommend well tested, free one ? we need to migrate production 30GB oracle
> 11 db to postgres 9 and are looking for best approac
Hi All,
How to Install PostgreSQL Client on SUSE Enterprise Linux Server 11.
-Pawan
18 matches
Mail list logo
