Re: PostgreSQL 9.2 high replication lag

2021-07-25 Thread Lucas
> Version 9.2 is very old and has a lot of issues related to streaming > replication. Additionally, it is already EOL. Agreed. > Furthermore, max_standby_streaming_delay has no relation with the streaming > lag. It's associated with queries conflicting with data. This parameter will > not spee

View of Union Multiple Tables - Only If table EXISTS

2021-07-25 Thread Avi Weinberg
Hi, I would like to create a view which is UNION of multiple tables with the same name from different schemas. Select col1, col2 from schemaA.table UNION Select col1, col2 from schemaB.table However, it is possible that in some of the schemas the table was not created yet. I know I can check

Re: View of Union Multiple Tables - Only If table EXISTS

2021-07-25 Thread David G. Johnston
On Sunday, July 25, 2021, Avi Weinberg wrote: > > Is it possible to write the view syntax once and it will do some type of > SELECT IF EXISTS. > > > Not with a virew. Dynamic SQL in a function can be used to build a query at runtime that includes only tables that exist. David J.

Re: pg_restore (fromuser -> touser)

2021-07-25 Thread Mayan
Thanks for your reply. Is this something that I can request as a feature add? I don't think it should be too much of effort (based on my limited source code knowledge), but I'm not familiar with the process to request a feature. Thanks, Mayan On Fri, Jul 23, 2021, 10:58 PM Ninad Shah wrote: > T

regarding sql password auth

2021-07-25 Thread Indrajit Datar
I have just downloaded the postgresql .In the SQLshell i am not able to go ahead as password is not authenticated . Can you tell me what to do next ? Below is the Screenshot ! If possible send a solution asap.

Re: regarding sql password auth

2021-07-25 Thread Vijaykumar Jain
> I have just downloaded the postgresql .In the SQLshell i am not able to go > ahead as password is not authenticated . > I am not too well versed with windows installer, but I know during installation it asks for admin username and password. The same cred should work with initial login. https://

Re: pg_restore (fromuser -> touser)

2021-07-25 Thread Vijaykumar Jain
On Sun, 25 Jul 2021 at 21:09, Mayan wrote: > Thanks for your reply. Is this something that I can request as a feature > add? I don't think it should be too much of effort (based on my limited > source code knowledge), but I'm not familiar with the process to request a > feature. > although there

Re: pg_restore (fromuser -> touser)

2021-07-25 Thread David G. Johnston
On Sun, Jul 25, 2021 at 8:39 AM Mayan wrote: > Thanks for your reply. Is this something that I can request as a feature > add? I don't think it should be too much of effort (based on my limited > source code knowledge), but I'm not familiar with the process to request a > feature. > You just did

Re: pg_restore (fromuser -> touser)

2021-07-25 Thread Ganesh Korde
You just need to export dump without any privileges. And while restoring dump use the new role. Regards, Ganesh Korde. On Mon, 26 Jul 2021, 1:01 am David G. Johnston, wrote: > On Sun, Jul 25, 2021 at 8:39 AM Mayan wrote: > >> Thanks for your reply. Is this something that I can request as a fea

Re: pg_restore (fromuser -> touser)

2021-07-25 Thread David G. Johnston
On Sun, Jul 25, 2021 at 8:02 PM Ganesh Korde wrote: > You just need to export dump without any privileges. And while restoring > dump use the new role. > You should read the body of the original email and not just the subject line. The actual question pertains to schemas - which IIUC are tightl

PostgreSQL reference coffee mug

2021-07-25 Thread Matthias Apitz
Hello, Nearly 20 years ago, I ordered some 50 vi-reference coffee mugs like this one here (not exactly the same, but to give you an idea): https://www.getdigital.eu/vi-reference-mug.html for our vi-lovers in-house and the admins of our customers. I'd like to do the same now with a reference m