Re: Failure of postgres_fdw because of TimeZone setting

Adnan Dautovic writes: > I have some trouble using postgres_fdw in order to display some data from a > Postgres database I do not control in a Postgres database that I do control. Hmm ... > * PostgreSQL version number you are running: > remote: "PostgreSQL 9.4.13 on x86_64-apple-darwin20.2.0,

Re: Moving delta data faster

On Thu, Apr 4, 2024 at 10:16 AM Adrian Klaver wrote: > On 4/3/24 20:54, yudhi s wrote: > > On Thu, Apr 4, 2024 at 2:41 AM Adrian Klaver > > wrote: > > > >> Thank you Adrian. > > > > And one thing i forgot to mention this target postgresql database would > >

Failure of postgres_fdw because of TimeZone setting

Hi everyone, I have some trouble using postgres_fdw in order to display some data from a Postgres database I do not control in a Postgres database that I do control. I filled out the form from the wiki below and would appreciate any tips. * A description of what you are trying to achieve and

Re: Moving delta data faster

On 4/3/24 20:54, yudhi s wrote: On Thu, Apr 4, 2024 at 2:41 AM Adrian Klaver > wrote: On 4/3/24 13:38, yudhi s wrote: >   Hi All, >   It's postgresql database version 15.4. We have a requirement in which > we will be initially moving full

Re: Moving delta data faster

On Thu, Apr 4, 2024 at 2:41 AM Adrian Klaver wrote: > On 4/3/24 13:38, yudhi s wrote: > > Hi All, > > It's postgresql database version 15.4. We have a requirement in which > > we will be initially moving full table data for 3-4 tables, from source > > database to target(i.e. postgres) . Maxim

Re: recovery.signal not being removed when recovery complete

On Tue, Mar 26, 2024 at 06:22:32PM -0400, Isaac Morland wrote: > I use a script to restore a backup to create a testing copy of the > database. I set the following in postgresql.auto.conf: > > recovery_target = 'immediate' > recovery_target_action = 'promote' Why not, after a pg_basebackup -R I a

Re: could not open file "global/pg_filenode.map": Operation not permitted

On Sat, Mar 23, 2024 at 3:01 AM Nick Renders wrote: > We now have a second machine with this issue: it is an Intel Mac mini running > macOS Sonoma (14.4) and PostgreSQL 16.2. > This one only has a single Data directory, so there are no multiple instances > running. BTW if you're running databas

Re: Moving delta data faster

On 4/3/24 13:38, yudhi s wrote:  Hi All,  It's postgresql database version 15.4. We have a requirement in which we will be initially moving full table data for 3-4 tables, from source database to target(i.e. postgres) . Maximum number of rows will be ~10million rows in those tables. Then sub

Re: could not open file "global/pg_filenode.map": Operation not permitted

On Thu, Apr 4, 2024 at 3:11 AM Nick Renders wrote: > In the macOS Finder, when you show the Info (command+i) for an external drive > (or any partition that is not the boot drive), there is a checkbox "Ignore > ownership on this volume" in the Permissions section. I think it is by > default "on"

Moving delta data faster

Hi All, It's postgresql database version 15.4. We have a requirement in which we will be initially moving full table data for 3-4 tables, from source database to target(i.e. postgres) . Maximum number of rows will be ~10million rows in those tables. Then subsequently these rows will be inserted/u

Re: Timestamp conversion Error in dynamic sql script

This one worked. Thank you so much. On Wed, Apr 3, 2024 at 2:27 AM Erik Wienhold wrote: > On 2024-04-02 22:08 +0200, sud wrote: > > On Tue, Apr 2, 2024 at 7:46 PM Greg Sabino Mullane > > wrote: > > > > Now this block seems to be failing near the "LIKE" operator. Isn't it > > allowed to add the

Re: could not open file "global/pg_filenode.map": Operation not permitted

On 29 Mar 2024, at 4:25, Thomas Munro wrote: > > I don't have any specific ideas and I have no idea what "ignore > ownership" means ... what kind of filesystem is running on it? For > the simple SSD, is it directly connected, running a normal Apple APFS > filesystem, or something more complicated?

Query regarding new version of shared library with older binary

Hi All, I have following query: Our application is compiled with postgres SQL Client C++(11.18) and it is dynamically linked with postgres shared library(version libpq.so.5.11). But where this application runs at customer production system new version of libpq(libpq.so.5.13) available. This new