Re: Pg_rewind cannot load history wal

On Sat, Aug 04, 2018 at 07:44:59AM +0100, Simon Riggs wrote: > I think the problem is that writing the online checkpoint is deferred > after promotion, so this is a timing issue that probably doesn't show > in our regression tests. Somewhat. It is a performance improvement of 9.3 to let the start

Re: Pg_rewind cannot load history wal

On 3 August 2018 at 21:59, Michael Paquier wrote: > On Wed, Aug 01, 2018 at 09:09:30PM +, Richard Schmidt wrote: >> Our procedure that runs on machine A and B is as follows: >> >> 1. Build new databases on A and B, and configure A as Primary and B >> as Standby databases. >> 2. Make so

Re: Eror while dropping a user

=?iso-8859-9?B?RXJ0YW4gS/zn/Gtv8Gx1?= writes: > Using PostgreSQL 9.6.9 on Linux amd64 platform. > 2018-08-03 23:24:03.901Drop user failed: SQL Error: ERROR: role > "pars.test" cannot be dropped because some objects depend on it > AYRINTI: 1 object in database postgres I see you've resolved

RE: Eror while dropping a user

> -Original Message- > From: Ertan Küçükoğlu > Sent: Friday, August 3, 2018 11:42 PM > To: pgsql-gene...@postgresql.org > Subject: Eror while dropping a user > > Hello, > > Using PostgreSQL 9.6.9 on Linux amd64 platform. > > I have two users that I cannot drop from the system. I revoked a

RE: Eror while dropping a user

> From: Alessandro Aste > Sent: Saturday, August 4, 2018 12:02 AM > To: Ertan Küçükoğlu > Cc: pgsql-gene...@postgresql.org > Subject: Re: Eror while dropping a user > > You can run this query to itendify the relations owned by the users you're > not allowed to drop, > just replace ('', 'us

Re: Sv: WAL-dir filling up with wal_level = logical

On Fri, Aug 03, 2018 at 12:40:16PM +0200, Andreas Kretschmer wrote: > On 3 August 2018 12:33:26 CEST, Andreas Joseph Krogh > wrote: >>Hm, a co-worker noticed that we have max_wal_size = 16GB, that might be >>the >>reason:-) > > Yes ;-) Worth mentioning that this is a soft size, and not a hard

Re: Eror while dropping a user

You can run this query to itendify the relations owned by the users you're not allowed to drop, just replace ('', 'username2' ..'userN' ) with the your role names . Then, once you have identified the tables/objecst change the owner like this: ALTER TABLE OWNER TO ; and try to drop the use

Re: Pg_rewind cannot load history wal

On Wed, Aug 01, 2018 at 09:09:30PM +, Richard Schmidt wrote: > Our procedure that runs on machine A and B is as follows: > > 1. Build new databases on A and B, and configure A as Primary and B > as Standby databases. > 2. Make some changes to the A (the primary) and check that they ar

RE: How to prevent "no wait lock" after a connection drop

> -Original Message- > From: Tom Lane > Sent: Wednesday, August 1, 2018 1:34 AM > To: Ertan Küçükoğlu > Cc: pgsql-gene...@postgresql.org > Subject: Re: How to prevent "no wait lock" after a connection drop > > =?iso-8859-9?B?RXJ0YW4gS/zn/Gtv8Gx1?= writes: > > What I observe during my te

Eror while dropping a user

Hello, Using PostgreSQL 9.6.9 on Linux amd64 platform. I have two users that I cannot drop from the system. I revoked all permissions from tables, sequences, functions. They do not own any objects. My log lines are as following: 2018-08-03 23:24:03.897There are 2 users that needs to be remove

Re: List of objects owned by a schema/owner

Thanks Tom for giving me the lead. I’ll take a look. On Fri, Aug 3, 2018 at 10:52 AM Tom Lane wrote: > Tiffany Thang writes: > > Does anyone have a query that will list all the objects (composite types, > > sequences, tables, triggers, functions, indices, etc) owned by a schema > or > > owner?

Re: how to install pgcrypto

The psql command is a client - an "interactive terminal". It provides a command-line version of pgAdmin. See here for other client applications: https://www.postgresql.org/docs/10/static/reference-client.html The "create extension..." command is one that you give to either psql or pgAdmin; t

RE: how to install pgcrypto

CCing list. From: Charles Clavadetscher [mailto:clavadetsc...@swisspug.org] Sent: Freitag, 3. August 2018 17:20 To: 'Ze Victor Harry' Subject: RE: how to install pgcrypto Hi From: Ze Victor Harry [mailto:assayab...@gmail.com] Sent: Freitag, 3. August 2018 17:11 To: Charles Clavadetsc

Re: List of objects owned by a schema/owner

Tiffany Thang writes: > Does anyone have a query that will list all the objects (composite types, > sequences, tables, triggers, functions, indices, etc) owned by a schema or > owner? I find fragments of information here and there that query on > pg_tables, pg_views, etc. Well, you could attack i

Re: List user who have access to schema

I think this one will give you report you need: select schema_name, roleid::regrole, string_agg(member::regrole::text,',' order by member::regrole::text) users from information_schema.schemata s, pg_user u JOIN pg_auth_members a ON u.usename::text=a.roleid::regrole::text WHERE s.schema_name not

List of objects owned by a schema/owner

Hi, Does anyone have a query that will list all the objects (composite types, sequences, tables, triggers, functions, indices, etc) owned by a schema or owner? I find fragments of information here and there that query on pg_tables, pg_views, etc. Thanks.

SQL Programming Assistant for PostgreSQL

Hello all, I've released the first version of a simple tool, - pgspa, that can help one to develop in SQL for PostgreSQL. The primary goal is to provide the functional for creating the database objects from the SQL files of arbitrary directory hierarchy without worrying about both the existence of

Re: Sv: WAL-dir filling up with wal_level = logical

On 3 August 2018 12:33:26 CEST, Andreas Joseph Krogh wrote: >På fredag 03. august 2018 kl. 12:12:33, skrev Andreas Joseph Krogh < >andr...@visena.com >: >Version: PG-10.4 >  >I don't (yet) have any replication-slots configured, and hence no >standbys are >subscribed, bu

Re: WAL-dir filling up with wal_level = logical

On 3 August 2018 12:12:33 CEST, Andreas Joseph Krogh wrote: >Version: PG-10.4 >  >I don't (yet) have any replication-slots configured, and hence no >standbys are >subscribed, but I have wal_level = logical configured to be able to add > >subscribers later. I'm seeing that WAL-dir is filling up wi

Sv: WAL-dir filling up with wal_level = logical

På fredag 03. august 2018 kl. 12:12:33, skrev Andreas Joseph Krogh < andr...@visena.com >: Version: PG-10.4   I don't (yet) have any replication-slots configured, and hence no standbys are subscribed, but I have wal_level = logical configured to be able to add subscribe

WAL-dir filling up with wal_level = logical

Version: PG-10.4   I don't (yet) have any replication-slots configured, and hence no standbys are subscribed, but I have wal_level = logical configured to be able to add subscribers later. I'm seeing that WAL-dir is filling up with WAL-files (now 17GB and not declining), is this expected behavio

RE: how to install pgcrypto

Hi From: Ze Victor Harry [mailto:assayab...@gmail.com] Sent: Freitag, 3. August 2018 10:54 To: pgsql-gene...@postgresql.org Subject: how to install pgcrypto hello again I have a small problem here can someone tell me briefly how to do it? I am getting this error

how to install pgcrypto

hello again I have a small problem here can someone tell me briefly how to do it? I am getting this error When I give ant fresh_install it gives error PostgreSQL 'pgcrypto' extension installed /up to date? False (not installed) Create extension pgcrypto

Re: Who and How is responsible for released installations packages and 3rd party packs? (e.g. on https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/)

On Friday, August 3, 2018 8:08:55 AM CEST Devrim Gündüz wrote: > On Thu, 2018-08-02 at 16:26 +0300, Alexandru Lazarev wrote: > > What about 3rd party libraries like plv8 - Who and How (based on which > > criteria, which versions) build RPM and upload them there? > > Latest versions of PL/v8 does no

Re: Who and How is responsible for released installations packages and 3rd party packs? (e.g. on https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/)

Re: Devrim Gündüz 2018-08-03 <1cdedaf455c4f326f31b103ab805d48da9914cb7.ca...@gunduz.org> > > What about 3rd party libraries like plv8 - Who and How (based on which > > criteria, which versions) build RPM and upload them there? > > Latest versions of PL/v8 does not build on RHEL/Fedora anymore, at