Re: Example setup for Odyssey connection pooler?

2018-06-27 Thread Adrian Klaver
t the folks at Yandex at the email listed here: https://github.com/yandex opensou...@yandex-team.ru On 27-06-18 14:53, Adrian Klaver wrote: On 06/27/2018 04:37 AM, Pablo Hendrickx wrote: Hi Postgres! The installation instructions for Odyssey are very clear and helpful, but there are no

Re: Database name with semicolon

2018-06-27 Thread Adrian Klaver
p. NCC Group is the trading name of NCC Services Limited (Registered in England CRN: 2802141). The ultimate holding company is NCC Group plc (Registered in England CRN: 4627044). This email may be confidential and/or legally privileged. -- Adrian Klaver adrian.kla...@aklaver.com

Re: pgp_sym_decrypt() - error 39000: wrong key or corrupt data

2018-06-27 Thread Adrian Klaver
On 06/27/2018 09:55 AM, Moreno Andreo wrote: Il 22/06/2018 19:56, Adrian Klaver ha scritto: On 06/22/2018 09:50 AM, Moreno Andreo wrote: Il 22/06/2018 15:18, Adrian Klaver ha scritto: I am at a loss now. The only thing I can think of is that data itself is actually corrupted. Maybe some

Re: plperl and plperlu language extentsions

2018-06-28 Thread Adrian Klaver
ing I deal with regularly. If it helps, here is the result of "select version();" : PostgreSQL 10.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-28), 64-bit Thanks for considering this, Niles. -- Niles Oien, National Solar Observatory, Boulder Colorad

Re: plperl and plperlu language extentsions

2018-06-28 Thread Adrian Klaver
t; wrote: Thanks for responding! I installed Postgres 10 from the PG repos. I believe the system came with Postgres 9.2 on it but I never used that. Postgres 10 is first in the path. On Thu, Jun 28, 2018 at 7:03 AM, Adrian Klaver mailto:adrian.kla...@aklaver.com>>

Re: CSV export bug?

2018-06-29 Thread Adrian Klaver
el Hill Public Library 100 Library Drive   Chapel Hill, NC 27514 Phone: 919-969-2032 |Fax: 919-968-2838 tbabi...@townofchapelhill.org <mailto:tbabi...@townofchapelhill.org> /Sparking Curiosity. Inspiring Learning. Creating Connections./// -- Adrian Klaver adrian.kla...@aklaver.com

Re: CSV export bug?

2018-06-29 Thread Adrian Klaver
Hill, NC 27514 Phone: 919-969-2032 |Fax: 919-968-2838 tbabi...@townofchapelhill.org Sparking Curiosity. Inspiring Learning. Creating Connections. -- Adrian Klaver adrian.kla...@aklaver.com

Re: CSV export bug?

2018-06-29 Thread Adrian Klaver
On 06/29/2018 12:53 PM, Adrian Klaver wrote: On 06/29/2018 09:29 AM, Tracy Babiasz wrote: Hi Adrian. Thanks for the response. I'm not sure how else to explain it. The report executes fine in the query tool and gives me about 300 lines in data output. It even appears to export fine. I cli

Re: Cloning schemas

2018-07-02 Thread Adrian Klaver
t about the changes in sequence metadata in PG v10. You need to update it, or talk to its author about an update.                         regards, tom lane -- Adrian Klaver adrian.kla...@aklaver.com

Re: Not able to update some rows in a table

2018-07-02 Thread Adrian Klaver
, I can see only the estimated number of rows. Counted rows are 'not counted'. -- Marco Fochesato -- Adrian Klaver adrian.kla...@aklaver.com

Re: Not able to update some rows in a table

2018-07-02 Thread Adrian Klaver
posts): 1) The schema of the table. 2) The SQL you are running. -- Marco Fochesato -- Adrian Klaver adrian.kla...@aklaver.com

Re: except all & WITH - syntax error?

2018-07-03 Thread Adrian Klaver
On 07/03/2018 02:05 AM, pinker wrote: thank you for the answer, had no idea about "syntactic precedence" thing. The order in which commands are executed in the absence of specific instructions e.g. the use of parenthesis. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Using pg Admin to create backups and restore them

2018-07-03 Thread Adrian Klaver
running queries from Access FE using ODBC connection. Not sure what that has to do with pg_dump. As mentioned above it is a client and run against a Postgres instance it can 'see'. Please help, Jacek -- Adrian Klaver adrian.kla...@aklaver.com

Re: problem wirh irc ffreenode

2018-07-03 Thread Adrian Klaver
n as I could join: [06:08] --> You (~aklaver@) have joined the channel #irc://irc.freenode.net/postgresql. Beest, Jacek -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to watch for schema changes

2018-07-03 Thread Adrian Klaver
-triggers.html Thank you. -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to watch for schema changes

2018-07-03 Thread Adrian Klaver
On 07/03/2018 11:15 AM, Igor Korot wrote: Adrian, On Tue, Jul 3, 2018 at 12:32 PM, Adrian Klaver wrote: On 07/03/2018 10:21 AM, Igor Korot wrote: Hi, ALL, Is there any trigger or some other means I can do on the server which will watch for CREATE/ALTER/DROP TABLE command and after

Re: How to watch for schema changes

2018-07-03 Thread Adrian Klaver
On 07/03/2018 11:41 AM, Igor Korot wrote: Adrian, On Tue, Jul 3, 2018 at 1:24 PM, Adrian Klaver wrote: On 07/03/2018 11:15 AM, Igor Korot wrote: Are you forced to work with 9.1 or can you use something from here: https://www.postgresql.org/download/macosx/ to get a newer version? FYI

Re: pg_dump out of memory

2018-07-03 Thread Adrian Klaver
ry: pg_dump -t ofrrds to dump only that table. 2) If that works then: pg_dump -T ofrrds to dump everything but that table. -Andy -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_dump out of memory

2018-07-03 Thread Adrian Klaver
On 07/03/2018 08:28 PM, Andy Colson wrote: On 07/03/2018 10:21 PM, Adrian Klaver wrote: On 07/03/2018 07:43 PM, Andy Colson wrote: Hi All, I moved a physical box to a VM, and set its memory to 1Gig.  Everything runs fine except one backup: /pub/backup# pg_dump -Fc -U postgres -f

Re: Unable to Connect to DB Instance

2018-07-04 Thread Adrian Klaver
'information_schema' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'tables' AND relnamespace = nsp.oid LIMIT 1)) OR     (nspname LIKE '_%' AND EXISTS (SELECT 1 FROM pg_proc WHERE proname='slonyversion' AND pronamespace = nsp.oid LIM

Re: Unable to Connect to DB Instance

2018-07-04 Thread Adrian Klaver
not being able to dump at all. (You might then need to REINDEX pg_db_role_setting to get its indexes in sync with it being empty.) Whether an equally drastic answer is tolerable for your other missing table(s) depends on what they are... regards, tom lane -- Adrian Klaver adrian.kla...@aklaver.com

Re: Return select statement with sql case statement

2018-07-04 Thread Adrian Klaver
e issue with the above is that table changes from product to product1 in the OP's desired behavior so the price switch alone will not work:( -- Adrian Klaver adrian.kla...@aklaver.com

Re: Cloning schemas

2018-07-04 Thread Adrian Klaver
e 9.6 version for you. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Cloning schemas

2018-07-04 Thread Adrian Klaver
niverse Exploration Command – UXC*** Employment by invitation only! -- Adrian Klaver adrian.kla...@aklaver.com

Re: Split daterange into sub periods

2018-07-05 Thread Adrian Klaver
* Is there any operators to make the split of daterange?* * Not that I know of. -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to watch for schema changes

2018-07-05 Thread Adrian Klaver
me='public' -- Function schema AND proname = 'tag_rcv_undo' -- Function name ; Thank you. David J. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Split daterange into sub periods

2018-07-05 Thread Adrian Klaver
e: [2018-01-04,2018-01-06] [2018-01-09,2018-01-12] [2018-01-18,2018-01-19] From what I understand the OP wants, the returned periods should be: [2018-01-01,2018-01-03] [2018-01-07,2018-01-08] [2018-01-13,2018-01-17] [2018-01-20,2018-01-31] -- Adrian Klaver adrian.kla...@aklaver.com

Re: Cloning schemas

2018-07-09 Thread Adrian Klaver
art(<*/ /*>) part above. I could see where the indexes in the new schema have new names while the index comments in the old schema refer to the old name. Then you would get the error the OP showed. REINDEX VERBOSE SYSTEM ; -- *Melvin Davidson** Maj. Database & Exploration Specialist** Universe Exploration Command – UXC*** Employment by invitation only! -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to watch for schema changes

2018-07-09 Thread Adrian Klaver
On 07/09/2018 01:49 PM, Igor Korot wrote: Hi, Adrian On Tue, Jul 3, 2018 at 1:24 PM, Adrian Klaver wrote: On 07/03/2018 11:15 AM, Igor Korot wrote: Adrian, On Tue, Jul 3, 2018 at 12:32 PM, Adrian Klaver wrote: On 07/03/2018 10:21 AM, Igor Korot wrote: Hi, ALL, Is there any trigger or

Re: Cloning schemas

2018-07-09 Thread Adrian Klaver
idx --> idx_test_id_idx. So this happens: test_(postgres)# comment on index sch_test.test_idx is 'test'; ERROR: relation "sch_test.test_idx" does not exist Just some muddling do with it what you will:) -- Adrian Klaver adrian.kla...@aklaver.com

Re: Cloning schemas

2018-07-09 Thread Adrian Klaver
On 07/09/2018 03:23 PM, Adrian Klaver wrote: On 07/09/2018 02:50 PM, Melvin Davidson wrote: Adrian, The problem is that the relname/object has changed in the new schema. In this case from text_idx --> idx_test_id_idx. So this happens: test_(postgres)# comment on index sch_test.test_

Re: Reporting bug on pgAdmin 4.3

2018-07-10 Thread Adrian Klaver
o fix this?? Not enough information at this time to arrive at a fix. Thanks Shore -- Adrian Klaver adrian.kla...@aklaver.com

Re: Create DDL trigger to catch which column was altered

2018-07-10 Thread Adrian Klaver
On 07/10/2018 01:56 AM, Łukasz Jarych wrote: It is no possible? AFAIK it is not possible, per: https://www.postgresql.org/message-id/3385.1518828768%40sss.pgh.pa.us Jacek -- Adrian Klaver adrian.kla...@aklaver.com

Re: Create event triger

2018-07-10 Thread Adrian Klaver
function to add the trigger would be more involved and I do not have the time at the moment to create an example. Will see if I can come up with something later. Best, Jacek -- Adrian Klaver adrian.kla...@aklaver.com

Re: Disabling/Enabling index before bulk loading

2018-07-10 Thread Adrian Klaver
- Extract index definition and save it as a SQL somewhere, either a file or a table. 2 - Drop all indexes. 3 - Ingest data via COPY 4 - Recreate all indexes saved in (1). Is there a generic sql or script or tool to accomplish (1). thanks -- Adrian Klaver adrian.kla...@aklaver.com

Re: Reporting bug on pgAdmin 4.3

2018-07-10 Thread Adrian Klaver
le an issue here: https://redmine.postgresql.org/ You will need a Postgres community account to access. Thanks a lot! Shore -- Original -- *From: * "Adrian Klaver"; *Date: * Tue, Jul 10, 2018 09:30 PM *To: * "a"<372660...@qq.com>;

Re: Open Source tool to deploy/promote PostgreSQL DDL

2018-07-10 Thread Adrian Klaver
use scripts, but they want something open source. The above is based on scripts. Will that work for the client or do they want a GUI tool? Thanks, Neil Barrett -- Adrian Klaver adrian.kla...@aklaver.com

Re: Create event triger

2018-07-10 Thread Adrian Klaver
| integer | | | fld_1 | character varying | | | Triggers: trg_test_change AFTER UPDATE ON trg_test FOR EACH STATEMENT EXECUTE PROCEDURE ts_update() Best, Jacek wt., 10 lip 2018 o 11:29 Guillaume Lelarge -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to tell which event was fired in Trigger function

2018-07-11 Thread Adrian Klaver
org/> -- Adrian Klaver adrian.kla...@aklaver.com

Re: timestamp (military) at time zone without the suffix

2018-07-11 Thread Adrian Klaver
select now(); now --- 2018-07-11 12:44:57.757347-07 (1 row) test=> select (now() at time zone 'UTC')::timestamp(0); timezone - 2018-07-11 19:45:00 (1 row) Thanks ! -- Adrian Klaver adrian.kla...@aklaver.com

Re: timestamp (military) at time zone without the suffix

2018-07-11 Thread Adrian Klaver
utc' ; timezone - 2018-07-11 19:51:52 (1 row) -- Adrian Klaver adrian.kla...@aklaver.com

Re: timestamp (military) at time zone without the suffix

2018-07-11 Thread Adrian Klaver
On 07/11/2018 12:36 PM, David Gauthier wrote: Hi: And I want to get rid of the -04 suffix. Is there a way to do this ? For the details see: https://www.postgresql.org/docs/10/static/functions-datetime.html#FUNCTIONS-DATETIME-ZONECONVERT Thanks ! -- Adrian Klaver adrian.kla

Re: timestamp (military) at time zone without the suffix

2018-07-11 Thread Adrian Klaver
tion. https://www.postgresql.org/docs/10/static/functions-formatting.html <https://www.postgresql.org/docs/10/static/functions-formatting.html> David J. -- Adrian Klaver adrian.kla...@aklaver.com

Re: timestamp (military) at time zone without the suffix

2018-07-11 Thread Adrian Klaver
o that ? Use the data type that represents exactly that, timestamptz.  Using the timestamp data type is generally not what you want even if you can get the manipulation logic figured out. David J. -- Adrian Klaver adrian.kla...@aklaver.com

Re: timestamp (military) at time zone without the suffix

2018-07-11 Thread Adrian Klaver
         How d I do that ?     Use the data type that represents exactly that, timestamptz.  Using     the timestamp data type is generally not what you want even if you     can get the manipulation logic figured out.     David J. -- Adrian Klaver adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> -- Adrian Klaver adrian.kla...@aklaver.com

Re: Open Source tool to deploy/promote PostgreSQL DDL

2018-07-11 Thread Adrian Klaver
t: https://metacpan.org/pod/sqitchtutorial#Status,-Revert,-Log,-Repeat which I think is more accurate. I find it very handy feature when in development mode. Write script --> deploy --> test, if fails --> revert, rewrite deploy script --> deploy and so on. -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to watch for schema changes

2018-07-11 Thread Adrian Klaver
On 07/11/2018 08:46 PM, Igor Korot wrote: Hi, guys, On Mon, Jul 9, 2018 at 5:38 PM, Adrian Klaver wrote: On 07/09/2018 01:49 PM, Igor Korot wrote: Hi, Adrian On Tue, Jul 3, 2018 at 1:24 PM, Adrian Klaver wrote: On 07/03/2018 11:15 AM, Igor Korot wrote: Adrian, On Tue, Jul 3, 2018

Re: Stored function | Grayed out option when I try modify the return type

2018-07-12 Thread Adrian Klaver
one but let us directly modify the original funcA's return type. Sorry for my English (I am non English native). I don't know if I have explained my issue and my complaint correctly. Best regards. -- Adrian Klaver adrian.kla...@aklaver.com

Re: ODBC - Getting CONN ERROR: errmsg='The buffer was too small for the InfoValue'

2018-07-12 Thread Adrian Klaver
ITH_INFO; CC_set_error(conn, CONN_TRUNCATED, "The buffer was too small for the InfoValue.", func); } } So what is the locale for the third computer? Thank you. -- Edgard Battisti Guimarães -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to watch for schema changes

2018-07-12 Thread Adrian Klaver
minimum anything after the last text that you write.​ -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to watch for schema changes

2018-07-12 Thread Adrian Klaver
server, correct? Thank you. -- Adrian Klaver adrian.kla...@aklaver.com

Re: ODBC - Getting CONN ERROR: errmsg='The buffer was too small for the InfoValue'

2018-07-13 Thread Adrian Klaver
rn end if end if The ONIBUS.INI parameters file = [sqlca] dbms=ODBC DbParm=ConnectString='Driver={Postgresql Unicode};Server=localhost;Port=5432;Database=onbpdc;Uid=dba;Pwd=sql'; == -- Adrian Klaver adrian.kla...@aklaver.com

Re: Handlind booleans Postgresql-Access

2018-07-13 Thread Adrian Klaver
linke here: http://bahut.alma.ch/2006/04/access-odbc-postgresql-boolean-mess.html but this is very strange function there (which i am not understanding), why to use it? There is no other option? Because Postgres has true boolean fields and Access does not. Best, Jacek -- Adrian Klaver

Re: Handlind booleans Postgresql-Access

2018-07-13 Thread Adrian Klaver
On 07/13/2018 06:56 AM, Łukasz Jarych wrote: Hmm so maybe better is use text field here Well it really depends on what you want to do with the field. Best, Jacek -- Adrian Klaver adrian.kla...@aklaver.com

Re: User documentation vs Official Docs

2018-07-16 Thread Adrian Klaver
ontent, clean up old content Thanks! JD -- Adrian Klaver adrian.kla...@aklaver.com

Re: User documentation vs Official Docs

2018-07-16 Thread Adrian Klaver
On 07/16/2018 01:48 PM, Joshua D. Drake wrote: On 07/16/2018 01:39 PM, Adrian Klaver wrote: Not sure this is much different from the Wiki unless: The wiki is certainly "a place" that can be used for this but the wiki takes a lot of effort to find things on it, manage it etc...

Re: User documentation vs Official Docs

2018-07-16 Thread Adrian Klaver
s/other volunteers would periodically go over existing documentation to remove/update stale content. Thanks, JD Tim -- Adrian Klaver adrian.kla...@aklaver.com

Re: User documentation vs Official Docs

2018-07-17 Thread Adrian Klaver
On 07/16/2018 04:56 PM, Joshua D. Drake wrote: On 07/16/2018 04:33 PM, Adrian Klaver wrote: I did it! Want to help? I think if we got together 5-7 people and came up with a proposal we could submit to -www/-core and get some buy in. Given the really discovered existence of the tutorial

Re: watchdog issues

2018-07-17 Thread Adrian Klaver
ersions of pgpool-II trying to communicate with each other and failing. So what are the versions for each pgpool-II node? [root@test01 pgpool-II-10]# Thanks in advance, Jean -- Adrian Klaver adrian.kla...@aklaver.com

Re: Can't compile postgresql 11 on FreeBSD 11.1

2018-07-17 Thread Adrian Klaver
beta2 # thanks in advance -- Att Márcio A. Sepp -- Adrian Klaver adrian.kla...@aklaver.com

Re: control over database files

2018-07-17 Thread Adrian Klaver
. Because? In sense that is what is being done anyway: https://www.postgresql.org/docs/10/static/storage-file-layout.html -- Aaron Gray Independent Open Source Software Engineer, Computer Language Researcher, Information Theorist, and amateur computer scientist. -- Adrian Klaver adrian.kla

Re: A bit confused about "pgsql_tmp" vs "temp tablespace"

2018-07-18 Thread Adrian Klaver
d like to put anything that is "temporary" onto the NVMe drive. But I'm unsure if that is better done through a symlink for pgsql_tmp or a temp tablespace. Currently no temporary tables are used (but that might change in the future), so only intermediate results (e.g. CTEs, sorting etc

Re: Is it ok to run vacuum full verbose command for live database for the tables which has more dead tuples?

2018-07-18 Thread Adrian Klaver
ce. -- Regards, Raghavendra Rao J S V -- Adrian Klaver adrian.kla...@aklaver.com

Re: A bit confused about "pgsql_tmp" vs "temp tablespace"

2018-07-18 Thread Adrian Klaver
On 07/18/2018 06:57 AM, Thomas Kellerer wrote: Adrian Klaver schrieb am 18.07.2018 um 15:06: In the chapter "Database File layout" the pgsql_tmp is explained as follows:     Temporary files (for operations such as sorting more data than can fit in memory)     are created within P

Re: functions with side effect

2018-07-19 Thread Adrian Klaver
this is returning a session-local value, it gives a predictable answer whether or not other sessions have executed nextval since the current session did." Thanks, Torsten -- Adrian Klaver adrian.kla...@aklaver.com

Re: functions with side effect

2018-07-19 Thread Adrian Klaver
On 07/19/2018 09:43 AM, Torsten Förtsch wrote: On Thu, Jul 19, 2018 at 6:35 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 07/19/2018 07:15 AM, Torsten Förtsch wrote: > Hi, > > assuming > > SELECT nextval('s'

Re: functions with side effect

2018-07-19 Thread Adrian Klaver
On 07/19/2018 09:43 AM, Torsten Förtsch wrote: On Thu, Jul 19, 2018 at 6:35 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 07/19/2018 07:15 AM, Torsten Förtsch wrote: > Hi, > > assuming > > SELECT nextval('s'

Re: User documentation vs Official Docs

2018-07-19 Thread Adrian Klaver
Davidson** Maj. Database & Exploration Specialist** Universe Exploration Command – UXC*** Employment by invitation only! -- Adrian Klaver adrian.kla...@aklaver.com

Re: User documentation vs Official Docs

2018-07-19 Thread Adrian Klaver
On 07/19/2018 05:54 PM, Adrian Klaver wrote: On 07/19/2018 05:43 PM, Melvin Davidson wrote:  > Then again people might use shared, university or library computers Would you please be so kind as to inform us which university or library allows users to install software on a _shar

Re: User documentation vs Official Docs

2018-07-20 Thread Adrian Klaver
in --docs: https://www.postgresql.org/list/pgsql-docs/ Thanks, JD -- Adrian Klaver adrian.kla...@aklaver.com

Re: Postgres function with output parameters and resultset

2018-07-20 Thread Adrian Klaver
FOR SELECT NAME, AGE, BRANCH, TITLE FROM EMP WHERE GRADE_CD = GRADE; EXCEPTION WHEN OTHERS THEN SUCCESS_FG := 'E'; SQLCD:= SQLSTATE; ERROR_MSG := 'SP EXECUTION ABORTED 2'; RETURN; RETURN REFCUR; END; $$ LANGUAGE plpgsql; -- Adrian Klaver adrian.kla...@aklaver.com

Re: User documentation vs Official Docs

2018-07-20 Thread Adrian Klaver
e it works out well. JD -- Adrian Klaver adrian.kla...@aklaver.com

Re: copyManager Implementation :: in postgreSQL community Driver

2018-07-23 Thread Adrian Klaver
/) for the whole file or, it does convert the file data into batches and implement copy command ? From above link looks like you have your choice of using a Reader or InputStream and setting a buffer size for each. Regards Yogi -- Adrian Klaver adrian.kla...@aklaver.com

Re: Improving pg_dump performance

2018-07-23 Thread Adrian Klaver
o make it run faster, or deeper knowledge of how pg_restore works so that I could convince them to let me do the partitioned backups? Lastly, is there any way to not make the backups so large (maybe by using the --binary-upgrade option, even though the man page says, "in-place up

Re: Improving pg_dump performance

2018-07-23 Thread Adrian Klaver
8.4 database while working on the 9.6.9 database? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Connections on cluster not being logged

2018-07-23 Thread Adrian Klaver
logging on a cluster? The second node is strictly for automatice failover, so nothing is actually running there at the moment. Can you define what you mean by a cluster? Thank you in advance for any suggestions. Sandy -- Adrian Klaver adrian.kla...@aklaver.com

Re: Connections on cluster not being logged

2018-07-23 Thread Adrian Klaver
he cluster/failover is setup, as that is something folks on this list are going to ask when attempting to answer a question. Just trying to get ahead of the inevitable:) On Mon, Jul 23, 2018 at 1:04 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 07/23/2018 08:14 AM, Sa

Re: Connections on cluster not being logged

2018-07-24 Thread Adrian Klaver
AFAIK. So are you using some fork of Postgres or are there actually two data directories? log rolled over this morning, connections started getting logged.  All is good now.  Thanks for  your help. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Connections on cluster not being logged

2018-07-24 Thread Adrian Klaver
On 07/24/2018 09:47 AM, Peter J. Holzer wrote: On 2018-07-24 06:46:18 -0700, Adrian Klaver wrote: On 07/24/2018 06:25 AM, Sandy Becker wrote: There is only one set of logs since it's a hardware cluster.  The two nodes share the underlying database storage.  Not sure why, but when the

Re: Speccing a remote backup server

2018-07-24 Thread Adrian Klaver
grade.) pg_dump is a client to the server, so wherever pg_dump runs. -- Adrian Klaver adrian.kla...@aklaver.com

Re: How can i install contrib modules in pg11 via source

2018-07-24 Thread Adrian Klaver
the appropriate translations to BSD. 1) cd to contrib/hstore/ 2) make 3) sudo make install 4) In psql CREATE EXTENSION hstore; Thanks in advance. -- Att Márcio A. Sepp -- Adrian Klaver adrian.kla...@aklaver.com

Re: logical replication snapshots

2018-07-25 Thread Adrian Klaver
n that it took 3 weeks to manifest itself before, I would say give it a try and monitor $PGDATA/pg_logical/snapshots. That would help provide information for getting at the source of the problem. You can always disable the replication if it looks like it running away. Dima --

Re: Permission denied on schema for all users on insert to table with fk

2018-07-25 Thread Adrian Klaver
HERE "id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x __ __ I’ve spent a bit of time searching on different sites trying to find pointers to this particular case and haven’t found any good ideas yet for next steps on troubleshooting or pointing at root cause. Any pointers to next steps would be appreciated. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Need text wrapping inside a column to avoid record wrapping (tabular output of 'select')

2018-07-25 Thread Adrian Klaver
h, blah, blah, blah, blah, blah, blah, more-more-mmore-more-more, andmore-andmore-andmore-andmore, blah, blah, blah, blah, blah, blah, blah, blah and now she''s 123 years old', 'yellow'); \pset format wrapped select * from wrap_test ; I am not showing output as email

Re: logical replication snapshots

2018-07-25 Thread Adrian Klaver
On 07/25/2018 11:10 AM, Dimitri Maziuk wrote: On 07/25/2018 11:16 AM, Adrian Klaver wrote: Where you using pg_export_snapshot() by any chance?: If it's not in chapter 31 of TFM then I have not touched it. The only notable thing I changed from 31.9 quickstart is that replica identity is

Re: logical replication snapshots

2018-07-25 Thread Adrian Klaver
On 07/25/2018 11:10 AM, Dimitri Maziuk wrote: On 07/25/2018 11:16 AM, Adrian Klaver wrote: Where you using pg_export_snapshot() by any chance?: If it's not in chapter 31 of TFM then I have not touched it. The only notable thing I changed from 31.9 quickstart is that replica identity is

Re: Permission denied on schema for all users on insert to table with fk

2018-07-26 Thread Adrian Klaver
I am not seeing that in the schema you sent. Is there one and if so what is it's definition and that of its associated function? What does show?: select session_user, current_user; INSERT INTO results.historyitem (batchid,datasourceid,sequence_order) VALUES (6,20,1); -- Adrian Klaver adrian.kla...@aklaver.com

Re: Permission denied on schema for all users on insert to table with fk

2018-07-26 Thread Adrian Klaver
item (batchid,datasourceid,sequence_order) VALUES (6,20,1); -- Adrian Klaver adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> -- Adrian Klaver adrian.kla...@aklaver.com

Re: logical replication snapshots

2018-07-26 Thread Adrian Klaver
On 07/26/2018 10:54 AM, Dimitri Maziuk wrote: On 07/25/2018 07:57 PM, Andres Freund wrote: On 2018-07-25 12:31:01 -0700, Adrian Klaver wrote: Would "permission denied" be relevant? Logical decoding is something I am still learning. The "permission denied" would to me

Re: logical replication snapshots

2018-07-26 Thread Adrian Klaver
On 07/26/2018 02:06 PM, Dimitri Maziuk wrote: On 07/26/2018 02:54 PM, Adrian Klaver wrote: On 07/26/2018 10:54 AM, Dimitri Maziuk wrote: I'm not sure what happened, I remember the initial sync of that particular schema failing on one table only, but looking at it now, all tables are emp

Re: logical replication snapshots

2018-07-26 Thread Adrian Klaver
On 07/26/2018 03:01 PM, Dimitri Maziuk wrote: On 07/26/2018 04:39 PM, Adrian Klaver wrote: The thing that has me somewhat confused is: ERROR: permission denied for schema macromolecules I would thought the replication user could access that. The more I look at the errors, the less sense it

Re: logical replication snapshots

2018-07-26 Thread Adrian Klaver
On 07/26/2018 04:48 PM, Dimitri Maziuk wrote: On 07/26/2018 05:34 PM, Adrian Klaver wrote: On 07/26/2018 03:01 PM, Dimitri Maziuk wrote: Let me ask a different question: if I drop and re-create a published table on the publisher without doing anything to the publication and subscription

Re: Postgresql 10.4 installation issues on Ubuntu 14.05

2018-07-27 Thread Adrian Klaver
untered while processing: postgresql-10 postgresql E: Sub-process /usr/bin/dpkg returned an error code (1) thanks for any reponse. Best guess, cross contamination with the Ubuntu package(s) for Postgres. What does: dpkg -l | grep postgres show? -- Adrian Klaver adrian.kla...@aklaver.com

Re: logical replication snapshots

2018-07-27 Thread Adrian Klaver
On 07/27/2018 03:04 PM, Dimitri Maziuk wrote: On 07/26/2018 07:11 PM, Adrian Klaver wrote: On 07/26/2018 04:48 PM, Dimitri Maziuk wrote: ... The publication foopub is at this point fubar I take it? And needs to be re-created on the publisher and reconnected on the subscriber? Complete with

Re: Postgresql 10.4 installation issues on Ubuntu 14.05

2018-07-27 Thread Adrian Klaver
ecause the error message indicates its a followup error from a previous failure.   Errors were encountered while processing: postgresql-10 postgresql E: Sub-process /usr/bin/dpkg returned an error code (1) thanks. -- Adrian Klaver adrian.kla...@aklaver.com

Re: postgres with xcode

2018-07-28 Thread Adrian Klaver
was needed. But even now, when I press run I get the same error. I do not see that the LC_ALL environment variable is set, per the HINT to the FATAL message. Hoping someone can share with me how they went about with their setup. -- Sumit Chaturvedi -- Adrian Klaver adrian.kla...@aklaver.com

Re: postgres with xcode

2018-07-28 Thread Adrian Klaver
purposes. Back to the problem at hand. The error message only shows up in the section I quoted before with regards to locale handling on Macs. Are you having any issues with starting Postgres outside of xcode? On Sat, Jul 28, 2018 at 7:41 PM Adrian Klaver <mailto:adrian.kla...@aklaver.

Re: postgres with xcode

2018-07-28 Thread Adrian Klaver
multithreaded for some other reason?? That error message only shows up in one place in the code and that is when dealing with Mac locales. You can download the source from here: https://www.postgresql.org/ftp/source/ and look for yourself. -- Adrian Klaver adrian.kla...@aklaver.com

Re: postgres with xcode

2018-07-28 Thread Adrian Klaver
help may involve going to an xcode mailing list/forum and asking advice. On Sat, Jul 28, 2018 at 11:46 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 07/28/2018 11:08 AM, Sumit Chaturvedi wrote: Hello. Thanks for those pointers. Will keep them in

Re: Publication/Subscription Questions

2018-07-28 Thread Adrian Klaver
it again, then i have all data back... Thanks a lot! -- xOCh -- PAranoids Group 218 -- Adrian Klaver adrian.kla...@aklaver.com

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