Re: Extract transactions from wals ??

I think he wants to see data from different tables at different timestamp (like flashback query in Oracle). As per my understanding question here is can PITR be done for specific table and for specific timestamp. On Fri, Nov 22, 2019 at 2:37 PM Laurenz Albe wrote: > On Thu, 2019-11-21 at 17:35 +

Re: UPDATE on 20 Million Records Transaction or not?

om members_temp ; drop table members_temp; Regards, Ganesh Korde. On Tue, Jun 23, 2020 at 9:06 PM Ron wrote: > > I'd make a copy of the table, and test how long the various methods take. > > On 6/23/20 10:17 AM, Jason Ralph wrote: > > > > Hello List, > > Po

Re: psql asks for password despite configuring trust authentication

Please make sure you are not using -w option while connecting through psql. On Thu, 29 Oct 2020, 11:30 pm Atul Kumar, wrote: > hi, > > My problem is, that I am always asked for password when trying to > interact with the database or access it, although the authentication > is set to trust for al

Re: PostgreSQL HA

You can go for BDR from 2nd Quadrant. On Sat, 26 Dec 2020, 4:17 pm venkata786 k, wrote: > Hi Team, > > Could you please share postgresql's best active(R/W)-active(R/W) (multi > master replication) solutions. > My Team is thinking about implementing active-active replacing > master-slave. > > Reg

Re: Insertion time is very high for inserting data in postgres

On Wed, 10 Feb 2021, 1:56 pm prachi surangalikar, < surangalikarprachi...@gmail.com> wrote: > Hello Team, > Greetings! > > We are using Postgres 12.2.1 for fetching per minute data for about 25 > machines but running parallely via a single thread in python. > But suddenly the insertion time has in

Re: Streaming replication between different OS

Should not be a problem if both OS archtecture (32 bit/ 64 bit) are same. On Mon, 22 Feb 2021, 11:48 am Atul Kumar, wrote: > Hi, > > > I have postgres 9.6 cluster running on Centos 6.8, so I just wanted to > know that can I configure streaming replication with same postgres version > i.e 9.6 run

Re: Who am I? Where am I connected?

\conninfo will show you desired details Regards, Ganesh Korde. On Wed, 18 May 2022, 3:38 pm Dominique Devienne, wrote: > LibPQ has various defaults for the host, user, and DB name. > There's also the password file, the service file and service name. > In the example below, I ca

Re: pg_receivewal/xlog to ship wal to cloud

On Tue, 19 Jul 2022, 2:09 am Alan Hodgson, wrote: > On Mon, 2022-07-18 at 15:55 -0400, neslişah demirci wrote: > > Hi all, > > > > Wondering if anyone has any experience of using pg_receivewal/xlog > > to ship wal files to GCP/S3? > > > > I use archive_command to send WAL to S3. It works fine. I

Re: get user info on log

Hi, You can use log_line_prefix in postgresql.conf to log the user name into the logs. Regards, Ganesh Korde. On Fri, 16 Sep 2022, 6:31 pm Marcos Pegoraro, wrote: > Em qui., 15 de set. de 2022 às 12:59, Adrian Klaver < > adrian.kla...@aklaver.com> escreveu: > >> test(5

Re: Who altered the database?

you for the answer! > > Best regards > > dd > > > You can use different options in log_line_prefix parameter in postgresql.conf You can also log connection and disconnection, each has separate parameter in configuration file. Regards, Ganesh Korde. >

Re: Any insights on Qlik Sense using CURSOR ?

sql ! > > Best regards, > Franck > > Have you tried setting the parameter below? log_statement = 'all' you will get all queries logged into log files. Regards, Ganesh Korde.

Re: Doubt on pgbouncer

Try using HAProxy. Regards, Ganesh Korde. On Sat, 3 Jul 2021, 9:06 pm Rama Krishnan, wrote: > > Hi Team, > > How can I split read and write queries using pgbouncer > > Regards > > A.Rama Krishnan > > > <https://www.avast.com/sig-email?utm_medium=email&am

Re: pg_restore (fromuser -> touser)

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

ERROR: ImportError: No module named 'psutil'

the internet but nothing helped. Problem is with the psutil module only. Please let me know if I am missing anything. Any help will be much appreciated. Regards, Ganesh Korde.

Re: ERROR: ImportError: No module named 'psutil'

Ok, thanks guys. Let me check that. On Sun, Aug 1, 2021 at 10:05 PM Tom Lane wrote: > Adrian Klaver writes: > > In that vein the OP could run: > > > DO $$ > > import sys > > plpy.notice(sys.version) > > $$ LANGUAGE plpython3u; > > > in the database to see what plpython3u is actually p

Re: Cannot find hstore operator

fraid that RETUR NEW; is specific to plpgsql... > > I'm still on v12, so cannot test v14 yet. We planned to move to v14, > for lz4 and built-in uuid-creation function, > but if we could get rid of the `SET search_path` workaround in our > trigger functions, that would be even more motivation. > > I'd really like my DDL statements to NOT contain schema-specific names, > to ensure proper name resolution independent of the search_path and > completely "self-contained" in the schema itself. > Is there any way to achieve that, beside our current `SET search_path` > workaround? > > Thanks, --DD > This might help. Alter user SET search_path TO myschema,public; No need to set search_path every time. Regards, Ganesh Korde.