Re: Building for 64-bit platform

2020-11-07 Thread Tom Lane
Igor Korot writes: > I build libpq with the standard configure/dmake. > Now I realize I need t build it for a 64-bit platform. > My questions are: > Is it enough to ust do Do "make distclean" at the top level, then re-configure with the new options and re-make. Maybe you can get away with a par

Building for 64-bit platform

2020-11-07 Thread Igor Korot
Hi, I build libpq with the standard configure/dmake. Now I realize I need t build it for a 64-bit platform. My questions are: Is it enough to ust do [code] cd libpq CFLAGS="-m64" LDFLAGS="-m64" ./configure dmake [/code] or I have to do: [code] dmake clean [/code] ? 2. Is my configure line abo

Re: Foreign Data Wrapper Handler

2020-11-07 Thread Adrian Klaver
On 11/7/20 12:44 PM, Susan Hurst wrote: Can anyone recommend a good online resource for learning how to set up a foreign data wrapper using a custom fdw name?  It seems the trick is to use a handler to make it work but so far the search results have been elusive for creating a fdw with a succes

Foreign Data Wrapper Handler

2020-11-07 Thread Susan Hurst
Can anyone recommend a good online resource for learning how to set up a foreign data wrapper using a custom fdw name? It seems the trick is to use a handler to make it work but so far the search results have been elusive for creating a fdw with a successful outcome. I'm using 'PostgreSQL 11.

RE: Not able to set pgaudit.log with pgaudit 1.3.2 in PostgreSQL 11.9

2020-11-07 Thread Brad Nicholson
Dhinakaran R wrote on 2020/11/07 02:03:22 PM: > > I had installed PostgreSQL 11.9 and pgaudit 1.3.2.  updated > > shared_preload_libraries, restarted PostgreSQL, created an extension for > > pgaudit and set parameters for pgaudit in postgresql.conf.  But > > surprisingly pgaudit.log is not gett

Re: Not able to set pgaudit.log with pgaudit 1.3.2 in PostgreSQL 11.9

2020-11-07 Thread Dhinakaran R
Hi Adrian There were no error messages from startup, even with debug level 1 I got only below. 2020-11-07 18:57:07.335 UTC [2290044]: LOG: database system was shut down at 2020-11-07 18:57:03 UTC 2020-11-07 18:57:07.335 UTC [2290044]: DEBUG: checkpoint record is at 0/1A3FE00 2020-11-07 18:5

Re: Not able to set pgaudit.log with pgaudit 1.3.2 in PostgreSQL 11.9

2020-11-07 Thread Adrian Klaver
On 11/7/20 10:42 AM, Dhinakaran R wrote: Hello, I had installed PostgreSQL 11.9 and pgaudit 1.3.2.  updated shared_preload_libraries, restarted PostgreSQL, created an extension for pgaudit and set parameters for pgaudit in postgresql.conf.  But surprisingly pgaudit.log is not getting picked u

Not able to set pgaudit.log with pgaudit 1.3.2 in PostgreSQL 11.9

2020-11-07 Thread Dhinakaran R
Hello, I had installed PostgreSQL 11.9 and pgaudit 1.3.2. updated shared_preload_libraries, restarted PostgreSQL, created an extension for pgaudit and set parameters for pgaudit in postgresql.conf. But surprisingly pgaudit.log is not getting picked up and neither able to set it manually. postg

Re: pg_bulkload sequential

2020-11-07 Thread Adrian Klaver
On 11/7/20 9:28 AM, Leandro Guimarães wrote: Hello,   I have a process using pg_bulkload and sometimes i have duplicated keys in my csv file that pg_bulkload uses.   My question is: pg_bulkload insert it in sequential order ?    Example, if i have the following csv file:     key_1;0.00

pg_bulkload sequential

2020-11-07 Thread Leandro Guimarães
Hello, I have a process using pg_bulkload and sometimes i have duplicated keys in my csv file that pg_bulkload uses. My question is: pg_bulkload insert it in sequential order ? Example, if i have the following csv file: key_1;0.00 key_1;100.00 And use the ON_DUPLICATE_KEEP =

Re: pgagent

2020-11-07 Thread Gabi Draghici
My bad ! I didn't read the documentation too well ... and completed the 'Host agent' with the IP instead of the hostname ! The job it's running now. Thank you for help ! Regards, Gabriel On Sat, Nov 7, 2020 at 1:29 PM Gabi Draghici wrote: > > I don't think that most of them are related to

Re: pgagent

2020-11-07 Thread Gabi Draghici
I don't think that most of them are related to pgagent, since they are coming anyway (I suppose it's about pgadmin's Dashboard). There is just one that I think it's about "Run now" : ... EET postgres postgres [2104]LOG: statement: UPDATE pgagent.pga_job SET jobnextrun=now()::timestamptz WHERE jo

Re: Reference-Partitioned Tables

2020-11-07 Thread Alvaro Herrera
On 2020-Nov-06, Сергей _ wrote: > https://docs.oracle.com/database/121/VLDBG/GUID-00923EB3-05F6-41F7-8437-E42FC9BD9571.htm#VLDBG1093 > > There is a widespread model when data related to properties of a superclass > is stored in a base table, and data related to subclasses in a detail table. > Or