Re: Something else about Redo Logs disappearing

On Thu, Jun 11, 2020 at 10:53:15PM +0200, Laurenz Albe wrote: ! On Thu, 2020-06-11 at 22:35 +0200, Magnus Hagander wrote: ! > I believe somebody around that time also wrote a set of bash scripts that can be used in a pre/post-backup-job combination with the current APIs. ! ! https://github.com/cy

Re: Returning SELECTed rows immediately instead of all at the end?

On 6/13/20 12:10 AM, Tom Lane wrote: Ron writes: I'm running amcheck on a set of indices (test machine, not prod) and want to track the progress.  Is there a SELECT clause that makes rows display as they are created, or do I have to explicitly call bt_index_check() from a shell script or SQL fu

Re: Returning SELECTed rows immediately instead of all at the end?

On 6/13/20 12:04 AM, David G. Johnston wrote: On Friday, June 12, 2020, Ron > wrote: I'm running amcheck on a set of indices (test machine, not prod) and want to track the progress.  Is there a SELECT clause that makes rows display as they are created

Re: Something else about Redo Logs disappearing

On Sat, 2020-06-13 at 05:24 +0200, Peter wrote: > ! https://github.com/cybertec-postgresql/safe-backup > > Ah, thank You, very nice. > > I've never seen anybody coding bash - it is strongly shunned in the > Berkeley community. Strange, but then I don't move in these circles. > Some Questions:

A query in Streaming Replication

Hello, I use streaming replication in async mode. When master gets down, slave will be promoted using a trigger file. During this process ".partial" file will be created and a WAL file with same ID will be created in a different time line in slave. When master comes back as slave, it will be

Re: Fwd: not able to give usage access to public schema

On 6/13/20 10:33 AM, sekhar chandra wrote: Adrian - when I follow the same steps what you did . in my case , the result is false. grant usage on schema public to role_test ; GRANT SELECT rolname, has_schema_privilege('role_test', 'public', 'usage') from pg_roles where rolname = 'role_test';

Re: pg_dump of database with numerous objects

On Wed, Jun 3, 2020 at 04:10:55PM -0400, Alvaro Herrera wrote: > On 2020-May-31, t...@exquisiteimages.com wrote: > > > I am now needing to upgrade to a new version of PostgreSQL and I am running > > into problems when pg_upgrade calls pg_dump. pg_dump stalled at: "pg_dump: > > saving database def

Re: pg_dump of database with numerous objects

On Sun, May 31, 2020 at 02:02:08PM -0700, Adrian Klaver wrote: > On 5/31/20 1:38 PM, Christophe Pettus wrote: > > > > > > > On May 31, 2020, at 13:37, Adrian Klaver > > > wrote: > > > > > > Just a reminder that the OP's original issue was with using pg_upgrade. > > > > True, although IIRC pg_

Re: Fwd: not able to give usage access to public schema

On 6/13/20 10:33 AM, sekhar chandra wrote: Adrian - when I follow the same steps what you did . in my case , the result is false. grant usage on schema public to role_test ; GRANT SELECT rolname, has_schema_privilege('role_test', 'public', 'usage') from pg_roles where rolname = 'role_test';

Re: Oracle vs. PostgreSQL - a comment

On Wed, Jun 3, 2020 at 08:53:45PM +0200, Andreas Joseph Krogh wrote: > I agree these are all technical issues, but nevertheless - "implementation > details", which DBAs don't care about. What's important from a DBA's > perspective is not whether WAL is cluster-wide or database-wide, but whether >

Re: Oracle vs. PostgreSQL - a comment

On Tue, Jun 2, 2020 at 03:45:08PM -0400, Ravi Krishna wrote: > > > > > Generally speaking, I discourage having lots of databases under one PG > > cluster for exactly these kinds of reasons. PG's individual clusters > > are relatively lightweight, after all. > > > > Plus PG does not directly s

Re: Something else about Redo Logs disappearing

On Sat, Jun 13, 2020 at 01:53:28PM +0200, Laurenz Albe wrote: ! > I've never seen anybody coding bash - it is strongly shunned in the ! > Berkeley community. ! ! Strange, but then I don't move in these circles. Never mind. ! > Some Questions: ! > 1. There are explicit error messages in loc-82

Re: Something else about Redo Logs disappearing

On Thu, Jun 11, 2020 at 10:35:13PM +0200, Magnus Hagander wrote: ! > Okay. So lets behave like professional people and figure how that ! > can be achieved: ! > At first, we drop that WAL requirement, because with WAL archiving ! > it is already guaranteed that an unbroken chain of WAL is always ! >

Re: A query in Streaming Replication

Hello, Forgot to add the version details. I'm using postgres 10.7 . On Sat, Jun 13, 2020, 20:26 Sreerama Manoj wrote: > Hello, > I use streaming replication in async mode. When master gets down, > slave will be promoted using a trigger file. During this process ".partial" > file will be c

Re: Fwd: not able to give usage access to public schema

Adrian - when I follow the same steps what you did . in my case , the result is false. grant usage on schema public to role_test ; GRANT SELECT rolname, has_schema_privilege('role_test', 'public', 'usage') from pg_roles where rolname = 'role_test'; rolname | has_schema_privilege ---+

Re: Oracle vs. PostgreSQL - a comment

On 6/13/20 1:46 PM, Bruce Momjian wrote: On Wed, Jun 3, 2020 at 08:53:45PM +0200, Andreas Joseph Krogh wrote: I agree these are all technical issues, but nevertheless - "implementation details", which DBAs don't care about. What's important from a DBA's perspective is not whether WAL is cluster

Re: postgres issue

On 6/13/20 2:55 PM, Shailesh Rangani wrote: + Community DL. On Saturday, June 13, 2020, 04:39:01 PM CDT, Shailesh Rangani wrote: Hi Adrian, Please find the attached sequence. Please post output of command below as text. What does \dn+ public show? Regards Shailesh -- Adria

Re: postgres issue

On 6/13/20 3:28 PM, Shailesh Rangani wrote: \dn+ public                                           List of schemas             Name             |     Owner     |       Access privileges       |      Description -+---++--

Re: Oracle vs. PostgreSQL - a comment

On Sat, Jun 13, 2020 at 05:06:37PM -0500, Ron wrote: > On 6/13/20 1:46 PM, Bruce Momjian wrote: > > On Wed, Jun 3, 2020 at 08:53:45PM +0200, Andreas Joseph Krogh wrote: > > > I agree these are all technical issues, but nevertheless - "implementation > > > details", which DBAs don't care about. Wha

Re: Fwd: not able to give usage access to public schema

sekhar chandra writes: > Adrian - when I follow the same steps what you did . in my case , the > result is false. > grant usage on schema public to role_test ; > GRANT > SELECT rolname, has_schema_privilege('role_test', 'public', 'usage') > from pg_roles where rolname = 'role_test'; >rolname

Re: Fwd: not able to give usage access to public schema

On 6/13/20 7:15 PM, Tom Lane wrote: sekhar chandra writes: Adrian - when I follow the same steps what you did . in my case , the result is false. grant usage on schema public to role_test ; GRANT SELECT rolname, has_schema_privilege('role_test', 'public', 'usage') from pg_roles where roln

Re: postgres issue

\dn+ public                                            List of schemas            Name             |     Owner     |       Access privileges        |      Description-+---++-public rds

pg_service.conf and client support

Hello all I just found out about the pg service file. https://www.postgresql.org/docs/current/libpq-pgservice.html I don't know why it took me so long finding this. I have been looking for ways to abstract physical details of data location away for clients (much like Oracle's tnsnames). Want

Re: pg_service.conf and client support

On Saturday, June 13, 2020, Niels Jespersen wrote: > Can anyone shed som light on the ubiquitousness of support for > pg_service.conf? > AFAIK same non-support for JDBC and Node.js > Are there any other mechanisms with broader support, that can be used > instead of pg_service.conf (if support is