Re: survey: pg_stat_statements total_time and entry deallocation

Hello, What about adding a log message for each entry_dealloc() execution? it could be usefull to start thinking increasing pg_stat_statements.max. is there any rule regarding the acceptable max value ? I'm playing in test with a 20 000 value without any problem, could it extendend to 100 000 ?

Re: Regarding varchar max length in postgres

On 10/5/18 8:18 AM, Durgamahesh Manne wrote: Hi please let me know the max length of varchar  & text in postgres https://www.postgresql.org/docs/10/static/datatype-character.html Regards Durgamahesh Manne -- Adrian Klaver adrian.kla...@aklaver.com

Regarding varchar max length in postgres

Hi please let me know the max length of varchar & text in postgres Regards Durgamahesh Manne

Re: COPY from a remote machine in Datastage

if you have ssh access to the client, you can do : ssh user@client_host "cat /path_to/large_file.csv" | psql -d database On Fri, Oct 5, 2018 at 9:06 AM Ravi Krishna wrote: > > We are doing a POC of using Datastage with PG using ODBC. > > Problem to solve: How to load a large CSV file us

Re: COPY from a remote machine in Datastage

> > Can you install the postgres client software (psql) on the client machine and > then have Datastage spawn "psql -c 'COPY ...'"? That is already an option for us :-)

Re: COPY from a remote machine in Datastage

On 10/05/2018 09:18 AM, Ravi Krishna wrote: Hello, if you need to use COPY command from remote machine and you use some libpq bindings (aka ruby pg gem for example), you can use functions associated with COPY command (https://www.postgresql.org/docs/10/static/libpq-copy.html). They should be

Re: COPY from a remote machine in Datastage

Can you copy your csv to postgres server? pá 5. 10. 2018 v 16:19 odesílatel Ravi Krishna napsal: > > Hello, if you need to use COPY command from remote machine and you use > some libpq bindings (aka ruby pg gem for example), you can use functions > associated with COPY command ( > https://www.po

Re: COPY from a remote machine in Datastage

> > Hello, if you need to use COPY command from remote machine and you use some > libpq bindings (aka ruby pg gem for example), you can use functions > associated with COPY command > (https://www.postgresql.org/docs/10/static/libpq-copy.html >

Re: COPY from a remote machine in Datastage

Hello, if you need to use COPY command from remote machine and you use some libpq bindings (aka ruby pg gem for example), you can use functions associated with COPY command ( https://www.postgresql.org/docs/10/static/libpq-copy.html). They should be provided by bindings of postgres library you're u

COPY from a remote machine in Datastage

We are doing a POC of using Datastage with PG using ODBC. Problem to solve: How to load a large CSV file using COPY command. The file is on the client machine. A typical SQL syntax of a copy coming from a remote machine COPY TABLE FROM STDIN WITH CSV HEADER Question is, how to make the

Prevent locked state (row lock + alter table)

Dear Members! We have a big database somewhere with more than 150 active connection. Sometimes we experienced a "lock" situation, the client's and programs are halted on a point. We investigated a little, and we recognized that this problem seems to be appears when we modify a table (alter) on h

Re: Does postgreSQL community edition supports data distribution across nodes

Also https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling and https://www.postgresql.org/docs/10/static/logical-replication.html for other options as well. On Fri, Oct 5, 2018 at 7:35 AM Fabio Pardi wrote: > Hi, > > I think you are looking for: > > https://www.postgre

Re: Does postgreSQL community edition supports data distribution across nodes

Hi, I think you are looking for: https://www.postgres-xl.org/ regards, fabio pardi On 05/10/18 11:54, deepikags wrote: > Hi, > > Does postgreSQL community edition supports data distribution across > nodes(distributed architecture) or do we need to buy licence for the same ? > > > Regards, > De

Does postgreSQL community edition supports data distribution across nodes

Hi, Does postgreSQL community edition supports data distribution across nodes(distributed architecture) or do we need to buy licence for the same ? Regards, Deepika -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Barman issue

Hello Experts, I have a server rhel 6.9 installed with barman 2.3 which is configured to take backup from Postgresql 10 installed in a remote host and the same is working. I am trying to do a poc on streaming backup and streaming wal method by making use of the pg_receivewal. I have already creat