Re: Code of Conduct plan

2018-09-14 Thread Adrian Klaver
At any rate, whether I like it or not the CoC is here to stay. I just feel a dissenting opinion is important to the conversation. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Adrian Klaver adrian.kla...@aklaver.com

Re: Slow shutdowns sometimes on RDS Postgres

2018-09-14 Thread Adrian Klaver
On 9/14/18 8:43 AM, Jeremy Schneider wrote: Hi Chris - this is an interesting one that we do see from time to time; seems worth responding here as actually our best understanding right now is that this is something in community code, not AWS-specific. On 9/13/18 16:10, Adrian Klaver wrote

Re: Query act different when doing by hand and by using a driver in app

2018-09-14 Thread Adrian Klaver
hout having all possible queries logged in? If it is a SELECT query then no. Thank you Ido -- Adrian Klaver adrian.kla...@aklaver.com

Re: Slow shutdowns sometimes on RDS Postgres

2018-09-14 Thread Adrian Klaver
ll kinds of stories we don't find on the lists yet.  :) Hopefully we're all getting better about closing the loop and sharing stuff back - that's part of the value large fleet operators can and should bring to the community. Hopefully sooner rather then later. -Jeremy -- Adrian Klaver adrian.kla...@aklaver.com

Re: column information from view

2018-09-14 Thread Adrian Klaver
cols.table_name = 'c_data' AND cols.table_name = cl.relname ORDER BY cols.ordinal_position::INT; ordinal_position | column_name | col_description --++- 1 | source_id | NULL 2 | geography_desc | NULL Thanks, -- Seb -- Adrian Klaver adrian.kla...@aklaver.com

Re: column information from view

2018-09-14 Thread Adrian Klaver
On 9/14/18 3:17 PM, Sebastian P. Luque wrote: On Fri, 14 Sep 2018 14:47:07 -0700, Adrian Klaver wrote: SELECT cols.ordinal_position, cols.column_name, col_description(cl.oid, cols.ordinal_position::INT) FROM pg_class cl, information_schema.columns cols WHERE cols.table_catalog='aquacu

Re: Code of Conduct plan

2018-09-15 Thread Adrian Klaver
s on a point of principle, then I wish you well. That is your right. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Code of Conduct plan

2018-09-15 Thread Adrian Klaver
at their absence will be keenly felt. In practice, therefore, democracy is going to win out. That's both good and bad. It's good because nobody wants a CoC witch-hunt, and it's bad because there's probably some behavior which legitimately deserves censure and will escape it. +1 -- Adrian Klaver adrian.kla...@aklaver.com

Re: Pgbouncer and postgres

2018-09-17 Thread Adrian Klaver
users.txt "pgbouncer" "***" I tried to change the listen address to 127.0.0.1 or to the IP of the VM. Nothing changed. Can anyone help? Thanks -- Adrian Klaver adrian.kla...@aklaver.com

Re: Pgbouncer and postgres

2018-09-17 Thread Adrian Klaver
1.0.2k-fips 26 Jan 2017 I can connect via telnet on that port, but we I try with anything else (like Apache) it makes pgbouncer crashing. Are there log entries from that? Il giorno lun 17 set 2018 alle ore 15:44 Adrian Klaver mailto:adrian.kla...@aklaver.com>> ha scritto: On 9/17/1

Re: Pgbouncer and postgres

2018-09-17 Thread Adrian Klaver
On 9/17/18 7:19 AM, Nicola Contu wrote: I'm not aware of any update installed. There were like 600+ updates in fact. These are the logs when connecting via telnet : How about those from when Apache tries to connect and pgbouncer crashes? Connection closed by foreign host. -- A

Re: Pgbouncer and postgres

2018-09-17 Thread Adrian Klaver
psql command? Il giorno lun 17 set 2018 alle ore 16:23 Adrian Klaver mailto:adrian.kla...@aklaver.com>> ha scritto: On 9/17/18 7:19 AM, Nicola Contu wrote: > I'm not aware of any update installed. There were like 600+ updates in fact. > > These are

Re: Pgbouncer and postgres

2018-09-17 Thread Adrian Klaver
-dev1 ~]# psql -U ncontu -p 6543 cmd3dev psql: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. So what does the pgbouncer log show when you do above? Il giorno lun 17 set 2018 alle ore 17:35 Adrian Klaver

Re: Pgbouncer and postgres

2018-09-17 Thread Adrian Klaver
ub.com/pgbouncer/pgbouncer/issues -- Adrian Klaver adrian.kla...@aklaver.com

Re: Pgbouncer and postgres

2018-09-17 Thread Adrian Klaver
gets around to connecting to the actual database. Sure, thanks for your help. I will create an issue there. Il giorno lun 17 set 2018 alle ore 18:07 Adrian Klaver mailto:adrian.kla...@aklaver.com>> ha scritto: On 9/17/18 8:59 AM, Nicola Contu wrote: > Yeah, I replaced the IP

Re: Converting to number with given format

2018-09-19 Thread Adrian Klaver
flow.com/questions/18882942/postgresql-convert-a-string-with-commas-into-an-integer Thanks Gabriel Fürstenheim -- Adrian Klaver adrian.kla...@aklaver.com

Re: Converting to number with given format

2018-09-19 Thread Adrian Klaver
t should be false (it should be 9.134). Also it is completely dependent on the number of digits. So for example: SELECT to_number('19,134','9V3') Is 1, not 19.134 or even 19 We probably ought to back this question up and ask what is you want to achieve in genera

Re: Pgbouncer and postgres

2018-09-19 Thread Adrian Klaver
9 0t0 665436 pipe Thanks -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Adrian Klaver adrian.kla...@aklaver.com

Re: Converting to number with given format

2018-09-19 Thread Adrian Klaver
set in the database. I know of no way to pass the information in with the format string. Off the top of my head I would say that this conversion would need to be done at point of input. Have user select their decimal and group separators and then convert to a universal format. Nice thing of

Re: Pgbouncer and postgres

2018-09-19 Thread Adrian Klaver
re used and the config.log(or equivalent) -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Adrian Klaver adrian.kla...@aklaver.com

Re: PostgreSQl, PHP and IIS

2018-09-21 Thread Adrian Klaver
played by php when I try and run any pg php functions. Can anyone please shed any light on what more I need to do? So what is the error you are getting? Or to put it another way, what is not happening? Regards, Mark -- Adrian Klaver adrian.kla...@aklaver.com

Re: New behavior with JDBC 42.2.5

2018-09-21 Thread Adrian Klaver
ou do some version of this?: psql postgresql://localhost:5432/test?sslmode=require psql postgresql://localhost:5432/test?sslmode=disable thanks -- Adrian Klaver adrian.kla...@aklaver.com

Re: New behavior with JDBC 42.2.5

2018-09-21 Thread Adrian Klaver
e ssl} property is empty or set to {@code true} it implies {@code verify-full}. * Default mode is "require" Thanks for your help. -- Adrian Klaver adrian.kla...@aklaver.com

Re: postgresql systemd service fails to start only on boot but not manually

2018-09-22 Thread Adrian Klaver
the systemd script? What does the log show when you do a successful manual start? What does the system log show when the Postgres reboot startup fails? Thanks. -- Adrian Klaver adrian.kla...@aklaver.com

Re: PostgreSQl, PHP and IIS

2018-09-22 Thread Adrian Klaver
the postgresql installation to the root folder of the PHP installation. I have added the bin folder of the postgresql installation to the Windows system search path. " I would say add the lib/ of the Postgres install to the search path. __ -Original Message- From: Adrian Klaver Sent:

Re: PostgreSQl, PHP and IIS

2018-09-23 Thread Adrian Klaver
soft.com/en-us/iis/application-frameworks/install-and-configure-php-on-iis/install-and-configure-php Cheers, Mark __ -----Original Message- From: Adrian Klaver Sent: 22 September 2018 16:45 To: Mark Williams ; pgsql-general@lists.postgresql.org Subject: Re: PostgreSQl, PHP and IIS On 9/22/1

Re: pgAdmin v4: The application server could not be contacted.

2018-09-24 Thread Adrian Klaver
uld to ask here: https://postgresrocks.enterprisedb.com/t5/EDB-Postgres/bd-p/EDBPostgres /Richard -- Adrian Klaver adrian.kla...@aklaver.com

Re: using the nextval('sequence_name') in sql, the result maybe is not right

2018-09-26 Thread Adrian Klaver
;) order by id2; id1 | id2 -+- 47 | 47 The sequence catches up with the values because there are duplicate 47 values in id2. Thanks,     Wanglin -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to maintain the csv log files in pg_log directory only for past 30 days

2018-09-28 Thread Adrian Klaver
tion = 'on', correct? -- Michael -- Adrian Klaver adrian.kla...@aklaver.com

Re: Why my query not using index to sort?

2018-09-28 Thread Adrian Klaver
ready in sorted order)? -- Adrian Klaver adrian.kla...@aklaver.com

Re: regarding bdr extension

2018-09-28 Thread Adrian Klaver
directory OS and version? How are you installing BDR, from package or source? What was the exact command that led to the error? Does opt/PostgreSQL/10/share/postgresql/extension/bdr.control exist? Regards Durgamahesh Manne -- Adrian Klaver adrian.kla...@aklaver.com

Re: Why my query not using index to sort?

2018-09-28 Thread Adrian Klaver
fferent plan. Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company. www.2ndQuadrant.com <http://www.2ndQuadrant.com> -- Adrian Klaver adrian.kla...@aklaver.com

Re: Why my query not using index to sort?

2018-09-28 Thread Adrian Klaver
? Thanks, Arup Rakshit a...@zeit.io <mailto:a...@zeit.io> -- Adrian Klaver adrian.kla...@aklaver.com

Re: Why my query not using index to sort?

2018-09-28 Thread Adrian Klaver
-performance Thanks, Arup Rakshit a...@zeit.io <mailto:a...@zeit.io> -- Adrian Klaver adrian.kla...@aklaver.com

Re: ORM

2018-09-28 Thread Adrian Klaver
any frameworks between the database and the end user? 4) Is an ORM even necessary? TIA --- El software de antivirus Avast ha analizado este correo electrónico en busca de virus. https://www.avast.com/antivirus -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to maintain the csv log files in pg_log directory only for past 30 days

2018-09-29 Thread Adrian Klaver
lto:mich...@paquier.xyz>> wrote: On Fri, Sep 28, 2018 at 06:19:16AM -0700, Adrian Klaver wrote: > If log_truncate_on_rotation = 'on', correct? Yup, thanks for precising. -- Michael -- Regards, Raghavendra Rao J S V Mobile- 8861161425 -- Adrian Klaver adrian.kla...@aklaver.com

Re: Postgres trigger side-effect is occurring out of order with row-level security select policy

2018-09-29 Thread Adrian Klaver
N NEW; END; $$ LANGUAGE plpgsql; CREATE TRIGGER reproTrigger BEFORE INSERT ON a FOR EACH ROW EXECUTE PROCEDURE reproHandler(); Resulted in: test=# INSERT INTO a VALUES ('fails') returning id; NOTICE: inside trigger handler id --- fails (1 row) INSERT 0 1 test=# select * from a; id --- fails (1 row) Carl Sverre http://www.carlsverre.com -- Adrian Klaver adrian.kla...@aklaver.com

Re: ORM

2018-09-29 Thread Adrian Klaver
On 9/29/18 6:47 AM, marcelo wrote: On 28/09/2018 21:39 , Adrian Klaver wrote: On 9/28/18 3:49 PM, marcelo wrote: For a new big and convoluted project I (am/was) using Devart´s LinqConnect as ORM. But today I experienced some inexplicable "object reference not set to an instance of an o

Re: Postgres trigger side-effect is occurring out of order with row-level security select policy

2018-09-30 Thread Adrian Klaver
, I forgot to add the policy names, sorry about that. On Sun, Sep 30, 2018 at 1:34 AM Charles Clavadetscher (SwissPUG) mailto:clavadetsc...@swisspug.org>> wrote: Hello -- Adrian Klaver adrian.kla...@aklaver.com

Re: Why my query not using index to sort?

2018-09-30 Thread Adrian Klaver
'c4f55044-3f4e-439e-a586-8b6978c7b406',

Re: libpq.dll question

2018-10-01 Thread Adrian Klaver
-- Adrian Klaver adrian.kla...@aklaver.com

Re: Why my query not using index to sort?

2018-10-01 Thread Adrian Klaver
lect * from projection where p_item_no = 2; Time: 0.463 ms -- Adrian Klaver adrian.kla...@aklaver.com

Re: libpq.dll question

2018-10-01 Thread Adrian Klaver
the Postgres install kit you refer to? I downloaded the file from https://www.postgresql.org/download/windows/ and extracted the dll file Best regards Wolfgang Hamann does not seem to help Best regards Wolfgang Hamann -- Adrian Klaver adrian.kla...@aklaver.com -- Adrian Klaver

Re: regarding bdr extension

2018-10-01 Thread Adrian Klaver
On 10/1/18 1:08 AM, Durgamahesh Manne wrote: On Fri, Sep 28, 2018 at 10:43 PM Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 9/28/18 8:41 AM, Durgamahesh Manne wrote: > Hi > > This is regarding bdr extension issue. I got below error at

Re: regarding bdr extension

2018-10-02 Thread Adrian Klaver
can use it for bdr please let me know some information about pgdg repository in detail * Does opt/PostgreSQL/10/share/postgresql/extension/bdr.control exist?    bdr.control  file not available Regards Durgamahesh Manne -- Adrian Klaver adrian.kla...@aklaver.com

Re: How can I get and handle the status of sql statements that run in plpgsql ?

2018-10-02 Thread Adrian Klaver
e below(read to bottom of the page) might help: https://www.postgresql.org/docs/10/static/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING my trials, it appears that plpgsql doesn't like "start transaction".  So how is that piece done ? Thanks in Advance for any help !

Re: metadata about creation and size of tables

2018-10-02 Thread Adrian Klaver
not null | nextval('id_test_id_seq'::regclass) | plain| | fld_1 | character varying | | | | extended | | fld_2 | boolean | | | | plain| | -- Adrian Klaver adrian.kla...@aklaver.com

Re: FTS trigger works 1 at a time, but fails with bulk insert script

2018-10-02 Thread Adrian Klaver
                LEFT JOIN ktab_tag AS tag ON tag.id <http://tag.id> = entry_tags.tag_id               WHERE entry.id <http://entry.id> = NEW.id               GROUP BY entry.id <http://entry.id>, category;               RETURN NEW;             END; */“None of you has faith until

Re: Regarding varchar max length in postgres

2018-10-05 Thread Adrian Klaver
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

Re: FTS trigger works 1 at a time, but fails with bulk insert script

2018-10-08 Thread Adrian Klaver
you think it is. Would also be helpful to see the script you wrote to do the bulk insert. */“None of you has faith until he loves for his brother or his neighbor what he loves for himself.”/* -- Adrian Klaver adrian.kla...@aklaver.com

Re: FTS trigger works 1 at a time, but fails with bulk insert script

2018-10-08 Thread Adrian Klaver
entry                 LEFT JOIN ktab_entry_tags color="#3465A4">AS entry_tags ON entry_tags.entry_id $                 LEFT JOIN ktab_tag AS tag ON tag.id <http://tag.id> = entry_tags.tag_id               WHERE entry.id <http://entry.id> = NEW.id               GROUP BY entr

Re: FTS trigger works 1 at a time, but fails with bulk insert script

2018-10-08 Thread Adrian Klaver
the above it is just a csv field value. Assuming log_statement = 'mod', I would tail the postgresql.conf file to see what is actually hitting the database. */“None of you has faith until he loves for his brother or his neighbor what he loves for himself.”/* -- Adrian Klaver adrian.kla...@aklaver.com

Re: FTS trigger works 1 at a time, but fails with bulk insert script

2018-10-08 Thread Adrian Klaver
On 10/8/18 3:54 PM, Adrian Klaver wrote: On 10/8/18 1:58 PM, Malik Rumi wrote: So what is the script you used to do the bulk INSERT? There's actually three, but they are all basically the same. The differences have to do with the source material being inserted: # usr/local/bin/pyth

Re: tds_fdw binary column

2018-10-09 Thread Adrian Klaver
S #: -1, OS Msg: , Level: 15 ^^ Have you done the above, look at the error log for the server? Time: 0.213 ms Thanks for any hints. Kind regards Ales Zeleny -- Adrian Klaver adrian.kla...@aklaver.com

Re: FTS trigger works 1 at a time, but fails with bulk insert script

2018-10-09 Thread Adrian Klaver
8 CDT [1155] LOG:  database system is ready to accept connections 2018-10-09 07:59:51.617 CDT [1274] [unknown]@[unknown] LOG:  incomplete startup packet */“None of you has faith until he loves for his brother or his neighbor what he loves for himself.”/* On Mon, Oct 8, 2018 at 6:36 PM A

Re: RHEL 7 (systemd) reboot

2018-10-09 Thread Adrian Klaver
ctm_server/tmp/upd_CMS_SYSPRM_29448. Thanks, Bryce *Bryce Pepper* Sr. Unix Applications Systems Engineer *The Kansas City Southern Railway Company * 114 West 11^th Street  |  Kansas City,  MO 64105 Office:  816.983.1512 Email: bpep...@kcsouthern.com <mailto:bpep...@kcsouthern.com&g

Re: RHEL 7 (systemd) reboot

2018-10-10 Thread Adrian Klaver
oduct? 4) What do you expect to happen vs what is happening? Bryce p.s. Do you know of any verbose logging that could be turned on to catch when pgsql is being terminated? -Original Message- From: Adrian Klaver Sent: Tuesday, October 09, 2018 7:39 PM To: Bryce Pepper ; pgsql-ge

Re: tds_fdw binary column

2018-10-10 Thread Adrian Klaver
take on my side... Hmm, some digging found this: https://github.com/tds-fdw/tds_fdw/issues/88 If your credentials allow it you might try the suggestion in the above to see if you can get a more detailed error message. Kind Regards Ales Zeleny -- Adrian Klaver adrian.kla...@aklaver.com

Re: how to cleanup archive based on datetime

2018-10-10 Thread Adrian Klaver
earch way, but it is based on the fact that every COMMIT time in wal is sequential, but it looks like not the case.. Hence I wonder what is the best practice for this task? Thank you in advance! --- Magodo -- Adrian Klaver adrian.kla...@aklaver.com

Re: RHEL 7 (systemd) reboot

2018-10-10 Thread Adrian Klaver
ata00/ctmlinux/ctm_server/scripts/shutdb ]; then echo "Stopping SQL server for CONTROL-M" /data00/ctmlinux/ctm_server/scripts/shutdb fi fi exit 0 -- Adrian Klaver adrian.kla...@aklaver.com

Re: tds_fdw binary column

2018-10-10 Thread Adrian Klaver
k messages from the SQL Server, OS #: -1, OS Msg: , Level: 16 Time: 0.249 ms The error is different, it looks tds_fdw is trying use bytea dat type fro ASE query (guess). That is what I was able to test. Kind regards Ales Zeleny st 10. 10. 2018 v 15:30 odesílatel Adrian Klaver mailto:adrian

Re: RHEL 7 (systemd) reboot

2018-10-11 Thread Adrian Klaver
figured with After= on another unit, the former is stopped before the latter if both are shut down. ..." [Service] Type=oneshot RemainAfterExit=true ExecStart=/bin/true ExecStop=/bin/bash /root/scripts/control-m_shutdown.sh TimeoutStopSec=4min [Install] WantedBy=multi-user.target [root@kcco

Re: RHEL 7 (systemd) reboot

2018-10-11 Thread Adrian Klaver
k the patching group to ensure they stop the control-m services prior to reboot. Yeah, there seems to be hidden dependencies happening. Bryce -- Adrian Klaver adrian.kla...@aklaver.com

Re: RHEL 7 (systemd) reboot

2018-10-12 Thread Adrian Klaver
inux_server.sh[10318]: Stopping CONTROL-M application Oct 11 09:20:00 kccontrolmt01 stop_ctmlinux_server.sh[10318]: SQL Server is not running. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Compile psql 9.6 with SSL Version 1.1.0

2018-10-12 Thread Adrian Klaver
se kind of comments: / They are also not needed with OpenSSL 1.1.0 anymore. (fe-secure-openssl.c)/ / / I suppose it is possible to compile the pqlib with ssl 1.1, but I can not wrap my head around it. Maybe I should set some ifdefs for the precompiler beforehand? I appreciate any help.

Re: Compile psql 9.6 with SSL Version 1.1.0

2018-10-12 Thread Adrian Klaver
x64 and with the postgresql 9.6.5 sources. (Later I would like to do this for debian also.) >Do you have the SSL dev libraries installed? No, I do not unfortunately. Thanks, Adam Adrian Klaver <mailto:adrian.kla...@aklaver.com>> ezt írta (időpont: 2018. okt. 12., P, 16:51): O

Re: Enabling autovacuum per table

2018-10-15 Thread Adrian Klaver
y setting this storage parameter to true, only to false. " Thanks, Rijo Roy Sent from Yahoo Mail on Android <https://go.onelink.me/107872968?pid=InProduct&c=Global_Internal_YGrowth_AndroidEmailSig__AndroidUsers&af_wl=ym&af_sub1=Internal&af_sub2=Global_YGrowth&af_sub3=Ema

Re: FATAL: terminating connection because protocol synchronization was lost

2018-10-15 Thread Adrian Klaver
gards. -- Shrikant Bhende +91-9975543712 -- Adrian Klaver adrian.kla...@aklaver.com

Re: FATAL: terminating connection because protocol synchronization was lost

2018-10-15 Thread Adrian Klaver
On 10/15/18 8:04 AM, Shrikant Bhende wrote: Hi Adrian, There is no explicit client its just simple restore using psql with all default settings required. psql is the client. Where is it running relative to the server locally or remote? On Mon, Oct 15, 2018 at 6:50 PM Adrian Klaver

Re: Regarding varchar max length in postgres

2018-10-15 Thread Adrian Klaver
ing open source  RDBMS  I request you all community members to provide built in bdr v3 version replication for public as multimaster replication is on high priority against other dbms -- Adrian Klaver adrian.kla...@aklaver.com

Re: Regarding varchar max length in postgres

2018-10-15 Thread Adrian Klaver
. Elements of it have found there into the community code as logical replication, but that is as far as it has gotten. You will need to take this up with 2ndQuadrant. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Filtering before join with date_trunc()

2018-10-15 Thread Adrian Klaver
eves that sequential scans are faster. (I have sometimes wished for an "explain" variant that tells me what query plan it would choose if all the tables were 100X larger.) Is there anything I can do to make this more efficient when the tables are larger? Thanks for any suggestions. Regards, Phil. -- Adrian Klaver adrian.kla...@aklaver.com

Re: FATAL: terminating connection because protocol synchronization was lost

2018-10-15 Thread Adrian Klaver
. The data looks alright, this is a client(psql) issue. So: 1) Which psql are you using the EDB or community one? 2) What is the exact psql command you are using? Thanks. On Mon, Oct 15, 2018 at 8:36 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 10/15/1

Re: Compile psql 9.6 with SSL Version 1.1.0

2018-10-16 Thread Adrian Klaver
then I could ? Thanks, Best, Adam -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Adrian Klaver adrian.kla...@aklaver.com

Re: FATAL: terminating connection because protocol synchronization was lost

2018-10-16 Thread Adrian Klaver
the same place in the restore? Thanks -- Adrian Klaver adrian.kla...@aklaver.com

Re: FATAL: terminating connection because protocol synchronization was lost

2018-10-16 Thread Adrian Klaver
2GB and toast table size is 288 GB which might have around 80 GB of dead rows. The dead rows won't show up in the dump file. I would take a look at the single table dump to get an idea of the amount of plain text data you are working with. Thanks On Tue 16 Oct, 2018, 20:23 Adrian K

Re: BUG: Incorrect working with POSIX locale if database in UTF-8 encoding

2018-10-17 Thread Adrian Klaver
://github.com/ClusterLabs/PAF/issues -- Adrian Klaver adrian.kla...@aklaver.com

Re: postgres server process crashes when using odbc_fdw

2018-10-17 Thread Adrian Klaver
with the project maintainer(s) as they are the folks that can determine whether it is fixable or not: https://github.com/ZhengYang/odbc_fdw -- Adrian Klaver adrian.kla...@aklaver.com

Re: postgres server process crashes when using odbc_fdw

2018-10-17 Thread Adrian Klaver
pay a company for support. On a related note is fdw for Oracle and SQLServer supported by the community ? For FDW info see: https://wiki.postgresql.org/wiki/Fdw -- Adrian Klaver adrian.kla...@aklaver.com

Re: convert real to numeric.

2018-10-18 Thread Adrian Klaver
::varchar::numeric workaround a good option in your opinion? Any other ideas to fix this issue? select 17637.75::real::numeric; numeric - 17637.8 select 17637.75::float::numeric; numeric -- 17637.75 Thank you, -- Adrian Klaver adrian.kla...@aklaver.com

Re: PGDG status and policy

2018-10-18 Thread Adrian Klaver
are the missing repos simply due to packagers being busy and which are by policy? I looked for a packaging policy and failed to find one. Does such a thing exist? Cheers, Steve -- Adrian Klaver adrian.kla...@aklaver.com

Re: Problem about partitioned table

2018-10-19 Thread Adrian Klaver
doc_rel - oid/) BIG QUESTION IS THAT How can I solve this problem?  What is your recommendations? Well a FK is a form of a trigger, so maybe create your own trigger on the child table(s). *PLEASE HELP ME !!!* -- */Best Regards,/* */Mehman Jafarov/* */DBA Aministrator at CyberNet L

Re: PGDG status and policy

2018-10-19 Thread Adrian Klaver
d now. A quick check seems to indicate it is. Cheers, Steve On Thu, Oct 18, 2018 at 3:22 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 10/18/18 3:02 PM, Steve Crawford wrote: > While looking to install version 11 I discovered that the PGDG Yum >

Re: PostgreSQL 11 and security

2018-10-19 Thread Adrian Klaver
cs/11/static/release-11.html Two sections that stand out: E.1.3.1.7. Authentication E.1.3.1.8. Permissions Best Regards Didier ROS Adrian Klaver adrian.kla...@aklaver.com

Re: How to declare PG version for compiling extensions.

2018-10-22 Thread Adrian Klaver
version to be used permanently? Tia -- Adrian Klaver adrian.kla...@aklaver.com

Re: Unavailability of Jar for connectivity in Postgres

2019-07-05 Thread Adrian Klaver
. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Converting to identity columns with domains on PK columns

2019-07-05 Thread Adrian Klaver
/fblangref25-ddl-domn.html https://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-ddl-enhance.html Thanks -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Adrian Klaver adrian.kla...@aklaver.com

Re: Converting to identity columns with domains on PK columns

2019-07-05 Thread Adrian Klaver
and Postgres on this point. To get back to the original case, is there a specific reason you want a IDENTITY column on the id field? -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Adrian Klaver adrian.kla...@aklaver.com

Re: Converting to identity columns with domains on PK columns

2019-07-05 Thread Adrian Klaver
er)> select myproc(5); myproc 5 (1 row) test_(aklaver)> select pg_typeof(myproc(5)); pg_typeof --- i32 (1 row) -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Adrian Klaver adrian.kla...@aklaver.com

Re: Converting to identity columns with domains on PK columns

2019-07-05 Thread Adrian Klaver
ission denied for table identity_test test_(production)> insert into seq_id_test (id) values(default); ERROR: permission denied for table seq_id_test A user can change the PK by using OVERRIDING SYSTEM VALUE in an INSERT. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.

Re: Converting to identity columns with domains on PK columns

2019-07-05 Thread Adrian Klaver
On 7/5/19 3:32 PM, Tom Lane wrote: Adrian Klaver writes: On 7/5/19 1:49 PM, PegoraroF10 wrote: Sorry, the example I was thinking was this one, which works on Firebird, using its way of writing, obviously. create function myproc(id integer) returns I32 language sql as 'select $1'; O

Re: pg_dump and search_path

2019-07-09 Thread Adrian Klaver
onfig for the server you are dumping to? Is that a bug?  I have seen some old posts about this issue but am not sure if there is a ticket or why it still is an issue. Thanks, Igal Sapir Lucee Core Developer Lucee.org <http://lucee.org/> -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_dump and search_path

2019-07-09 Thread Adrian Klaver
tore the search_path will return to whatever has been configured. -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_dump and search_path

2019-07-09 Thread Adrian Klaver
On 7/9/19 7:41 AM, Igal @ Lucee.org wrote: On 7/9/2019 7:02 AM, Adrian Klaver wrote: On 7/8/19 11:48 PM, Igal @ Lucee.org wrote: I have a custom search_path: # show search_path;     search_path --   "staging, transient, pg_catalog" (1 r

Re: execute_values

2019-07-09 Thread Adrian Klaver
st', 'f'), (3, 'dog', 't')]) -- *Gerard Weatherby*| Application Architect NMRbox | Department of Molecular Biology and Biophysics | UConn Health 263 Farmington Avenue, Farmington, CT 06030-6406 Phone: 860 679 8484 uchc.edu -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_dump and search_path

2019-07-09 Thread Adrian Klaver
On 7/9/19 4:24 PM, Igal @ Lucee.org wrote: On 7/9/2019 10:45 AM, Adrian Klaver wrote: On 7/9/19 7:41 AM, Igal @ Lucee.org wrote: On 7/9/2019 7:02 AM, Adrian Klaver wrote: On 7/8/19 11:48 PM, Igal @ Lucee.org wrote: I have a custom search_path: # show search_path;     search_path

Re: execute_values

2019-07-10 Thread Adrian Klaver
rchitect NMRbox | Department of Molecular Biology and Biophysics | UConn Health 263 Farmington Avenue, Farmington, CT 06030-6406 Phone: 860 679 8484 uchc.edu ____ From: Adrian Klaver Sent: Tuesday, July 9, 2019 4:25 PM To: Weatherby,Gerard; pgsql-general@lists

Re: pg_dump and search_path

2019-07-10 Thread Adrian Klaver
onfig('search_path', '', false); set_config (1 row) test_(postgres)# show search_path; search_path - (1 row) *Ryan Lambert* RustProof Labs -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_dump and search_path

2019-07-10 Thread Adrian Klaver
the search_path? Unfortunately in the OP's case the restore is going to overwrite the env setting. Ryan -- Adrian Klaver adrian.kla...@aklaver.com

Re: Extensions

2019-07-11 Thread Adrian Klaver
function child_fnc(character varying) depends on language plpgsql function parent_fnc() depends on language plpgsql ... rollback; Thanks, Bhargav -- Adrian Klaver adrian.kla...@aklaver.com

<    2   3   4   5   6   7   8   9   10   11   >