Re: Query running for 12 hours

2018-05-30 Thread Adrian Klaver
Is it possible that parallel query: https://www.postgresql.org/docs/10/static/when-can-parallel-query-be-used.html <https://www.postgresql.org/docs/10/static/when-can-parallel-query-be-used.html> is in use?     --     Adrian Klaver adrian.kla...

Re: Pgagent is not reading pgpass file either in Windows or Linux.

2018-05-30 Thread Adrian Klaver
On 05/30/2018 08:48 AM, nageswara Bandla wrote: On Tue, May 29, 2018 at 6:15 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 05/29/2018 03:57 PM, nageswara Bandla wrote: #1. Windows: My guess because the LocalSystem user does not have permi

Re: LDAP authentication slow

2018-05-30 Thread Adrian Klaver
the problem is. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Insert UUID GEN 4 Value

2018-05-31 Thread Adrian Klaver
the input syntax for the uuid field. INSERT INTO enrollmentinfo (id, created, modified, secure_id, relationship, tuition_bill) SELECT your_id_returning_function_or_a_literal_value(), current_timestamp, current_timestamp, uuid_generate_v4(), 'some relationship', 'some tuition bill text'; ...modified with real values, of course... That should get you over the hump. Good luck on your project! CG -- Adrian Klaver adrian.kla...@aklaver.com

Re: Insert UUID GEN 4 Value

2018-05-31 Thread Adrian Klaver
how to use this in INSERT statement. I am getting an error of invalid input systex for UUID. So please show what: SELECT uuid_generate_v4(); is actually returning. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Insert UUID GEN 4 Value

2018-05-31 Thread Adrian Klaver
On 05/31/2018 06:39 AM, Tom Lane wrote: Adrian Klaver writes: My suspicion is it had to do with this from a post upstream: "When I tried it, I am getting an error: Invalid input syntax for UUID: uuid_generate_v4()," Yeah. We haven't seen the actual query yet, but I'm b

Re: Insert UUID GEN 4 Value

2018-05-31 Thread Adrian Klaver
iZYdFuGGkMT27zsp-mR1SjAzbGEg%40mail.gmail.com CREATE TABLE enrollmentinfo ( id integer NOT NULL, created timestamp with time zone NOT NULL, modified timestamp with time zone NOT NULL, secure_id uuid NOT NULL, relationship character varying(50) NOT NULL, tuition_bill character varying(255) NOT NULL ); So which is correct? -- Adrian Klaver adrian.kla...@aklaver.com

Re: unable to write 'raise' messages to log file?

2018-05-31 Thread Adrian Klaver
5, t = test testwithbasictypearguments 0 (1 row) -- Adrian Klaver adrian.kla...@aklaver.com

Re: unable to write 'raise' messages to log file?

2018-05-31 Thread Adrian Klaver
On 05/31/2018 12:15 PM, Olivier Gautherot wrote: On Thu, May 31, 2018 at 3:07 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 05/31/2018 11:20 AM, Ian Bell wrote: I am having considerable difficulty logging information in PL-pgSQL functions by usi

Re: unable to write 'raise' messages to log file?

2018-05-31 Thread Adrian Klaver
Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: 31 May, 2018 15:07 To: i...@ianbellsoftware.com; pgsql-general@lists.postgresql.org Subject: Re: unable to write 'raise' messages to log file? On 05/31/2018 11:20 AM, Ian Bell wrote: I am having c

Re: now getting log messages!

2018-05-31 Thread Adrian Klaver
udes all the levels that follow it. The later the level, the fewer messages are sent to the log. The default is WARNING. Note that LOG has a different rank here than in client_min_messages. Only superusers can change this setting. " Thank you for your help. Ian -- Adrian Klaver adrian.kla...@aklaver.com

Re: Sort is generating rows

2018-05-31 Thread Adrian Klaver
and joining using an equality? For now, the more currency rates, the slowest the query. There's not that much currency rates (1k in this case), as you can only have one rate per day per currency. Have a nice day, Nicolas. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Sort is generating rows

2018-06-01 Thread Adrian Klaver
                                     Index Cond: (currency_id = pp.currency_id)                                              Filter: (((company_id = s.company_id) OR (company_id IS NULL)) AND (daterange(name, COALESCE(date_end, (now())::date)) @> (COALESCE((s.date_order)::timestamp

Re: RPM Packaging Question - Fedora 28 & Postgis

2018-06-01 Thread Adrian Klaver
302 New Mill Lane • Exton, PA 19341 • (610) 524-7260 -- Adrian Klaver adrian.kla...@aklaver.com

Re: RPM Packaging Question - Fedora 28 & Postgis

2018-06-01 Thread Adrian Klaver
l.org/account/signup/ or third party accounts, see below: https://www.postgresql.org/account/auth/4/ -John John Woltman TPI • 302 New Mill Lane • Exton, PA 19341 • (610) 524-7260 On Fri, Jun 1, 2018 at 1:12 PM, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 06/01/201

Re: VBA to connect to postgresql from MS Access

2018-06-02 Thread Adrian Klaver
range paramaters. I want to use VBA to relink all tables and use DSN less connection string. Please help, Best, Jacek -- Adrian Klaver adrian.kla...@aklaver.com

Re: notes from transition to relkind='p'

2018-06-03 Thread Adrian Klaver
o the indeterminate future). Well they are two different cases, so I am not sure they could be combined. Cheers, Justin -- Adrian Klaver adrian.kla...@aklaver.com

Re: Code of Conduct plan

2018-06-03 Thread Adrian Klaver
behavior is called out in detail in the paragraphs above it. regards, tom lane [1] https://www.postgresql.org/message-id/56a8516b.8000...@agliodbs.com -- Adrian Klaver adrian.kla...@aklaver.com

Re: Code of Conduct plan

2018-06-03 Thread Adrian Klaver
ity in favor. From what I remember of the online discussion the opinion was evenly split on the need for a CoC. served by re-litigating that point. regards, tom lane -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to get postmaster shut down time in postgres?

2018-06-04 Thread Adrian Klaver
is shut down The log when it was next started up: 2018-06-04 05:46:33.118 PDT-0LOG: database system was shut down at 2018-06-03 21:11:41 PDT Thanks in Advance. Regards, Pavan -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Adrian Klaver adrian.kla

Re: VBA to connect to postgresql from MS Access

2018-06-04 Thread Adrian Klaver
following the below does use a DSN. What are the parameters for the DSN PostgreSQL35W? ODBC;DSN=PostgreSQL35W;DATABASE=AccessTest;SERVER=localhost;PORT=5432;*CA=d;A7=100;B0=255;B1=8190;BI=0;C2=;CX=1c305008b;A1=7.4* Why? Best, Jacek -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to get postmaster shut down time in postgres?

2018-06-04 Thread Adrian Klaver
ction to do this. Looks like you will need to parse the log file. The main reason for my requirement is to find the time swing between server stop and start. Thanks in advance. Regards, Pavan -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Adrian K

Re: [HACKERS] Code of Conduct plan

2018-06-04 Thread Adrian Klaver
forcible red tape. The core team does have enforcement tools at its disposal.  They are at least being open about the circumstances and extents under which they would leverage those tools. David J. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Pgagent is not reading pgpass file either in Windows or Linux.

2018-06-04 Thread Adrian Klaver
o restart the system to let it see environment changes.  PITA. Yes, I did. But no luck..I guess, we have to live with this problem for pgagent running as a Local System account. We need to run pgagent service as  "Logon user account" and provide user logon credentials for running pgagent service. In Linux case, pgagent is not even reading .pgpass itself. The issue here is that the logs (debug level log) are no help. It don't have much information. Which password file it is trying to read. George -- Adrian Klaver adrian.kla...@aklaver.com

Re: Which backend using which pg_temp_N schema?

2018-06-05 Thread Adrian Klaver
t. Can you explain more about what you are trying to do? A quic \df for functions with names likely to be fruitful revealed nothing. Did likewise for sysinfo views. Am I missing it or does feature not exist? Thx -- Adrian Klaver adrian.kla...@aklaver.com

Re: Code of Conduct plan

2018-06-05 Thread Adrian Klaver
it turns out to be a net loss, we'll modify it or abandon it. Good to hear this is considered an experiment. To that end will there be quarterly/yearly reports, suitably anonymized, that spell out the activity that took place with reference to the CoC? regards, tom lane -- Adrian Klaver adrian.kla...@aklaver.com

Re: Pgagent is not reading pgpass file either in Windows or Linux.

2018-06-05 Thread Adrian Klaver
taddr=127.0.0.1  host=localhost dbname=linuxpostgresdb user=postgres port=5432 Well so much for that idea. Will have to see what the answer to the filed issue is. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Code of Conduct plan

2018-06-05 Thread Adrian Klaver
human resources, marketing, etc. (in addition to the likely much easier to find developers, DBAs and IT managers) would be valuable too. Oh, please no that would be a trip down the rabbit hole. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Which backend using which pg_temp_N schema?

2018-06-06 Thread Adrian Klaver
On 06/05/2018 04:49 PM, Jerry Sievers wrote: Adrian Klaver writes: On 06/05/2018 02:53 PM, Jerry Sievers wrote: Was just studying a legacy DB to learn about temp table activity. Felt like being able to tie temp schemas to live backends s/b useful but then didn't find a function/vie

Re: Failover replication building a new master

2018-06-06 Thread Adrian Klaver
ithout doing a new BaseBackup from S2 to the other servers? Thanks Tom -- Adrian Klaver adrian.kla...@aklaver.com

Re: Slow planning time for simple query

2018-06-06 Thread Adrian Klaver
system. Any ideas of what else we could try?  A PL function that caches the query plan works, but that is just a workaround. Thanks! Jeremy -- Adrian Klaver adrian.kla...@aklaver.com

Re: Which backend using which pg_temp_N schema?

2018-06-06 Thread Adrian Klaver
On 06/06/2018 08:54 AM, Jerry Sievers wrote: Adrian Klaver writes: On 06/05/2018 04:49 PM, Jerry Sievers wrote: Adrian Klaver writes: On 06/05/2018 02:53 PM, Jerry Sievers wrote: Was just studying a legacy DB to learn about temp table activity. Felt like being able to tie temp schemas

Re: Which backend using which pg_temp_N schema?

2018-06-06 Thread Adrian Klaver
On 06/06/2018 02:00 PM, Jerry Sievers wrote: Adrian Klaver writes: On 06/06/2018 08:54 AM, Jerry Sievers wrote: Adrian Klaver writes: Yep thanks... but IMO something that simply exposes whatever internal registry of temp schemas/PIDs (which I presume must exist) to DBA SQL avoids any

Re: Microsoft buys GitHub, is this a threat to open-source

2018-06-07 Thread Adrian Klaver
/ -- Adrian Klaver adrian.kla...@aklaver.com

json_populate_recordset

2018-06-07 Thread Adrian Klaver
From here: https://www.postgresql.org/docs/10/static/functions-json.html select * from json_populate_record(null::myrowtype, '{"a": 1, "b": ["2", "a b"], "c": {"d": 4, "e": "a b c"}}') What is the null::myrowtype doing? Thanks, -- Adrian Klaver adrian.kla...@aklaver.com

Re: Service pgpool

2018-06-07 Thread Adrian Klaver
me like a start script using SYSV init in a systemd system and systemd not liking it. Thanks a lot -- Adrian Klaver adrian.kla...@aklaver.com

Re: json_populate_recordset

2018-06-07 Thread Adrian Klaver
On 06/07/2018 09:56 AM, Pavel Stehule wrote: 2018-06-07 18:51 GMT+02:00 Adrian Klaver <mailto:adrian.kla...@aklaver.com>>: From here: https://www.postgresql.org/docs/10/static/functions-json.html <https://www.postgresql.org/docs/10/static/functions-json.html>

Re: Query hitting empty tables taking 48 minutes

2018-06-07 Thread Adrian Klaver
cution time: 1951.564 ms Please keep my CC of my work e-mail present. Best, Robert -- Adrian Klaver adrian.kla...@aklaver.com

Re: Query hitting empty tables taking 48 minutes

2018-06-07 Thread Adrian Klaver
On 06/07/2018 12:11 PM, Rob Sargent wrote: What's the url doing in "blob_id = ds3.blob.id <http://ds3.blob.id";? I have run into this before, it is an email artifact. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Query hitting empty tables taking 48 minutes

2018-06-07 Thread Adrian Klaver
On 06/07/2018 11:55 AM, Robert Creager wrote: On Jun 7, 2018, at 12:40 PM, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 06/07/2018 11:17 AM, Robert Creager wrote: I have a system running FreeBSD 11.1-STABLE, PostgreSQL 9.6.8,Java OpenJDK 1.8.0_131, jdbc 9.3-1104-jdb

Re: Can you make a simple view non-updatable?

2018-06-08 Thread Adrian Klaver
NOTICE: Read only view DELETE 0 The reason I want this:  It will help me encode into my schema the distinction between views that are supposed to behave like full-fledged "subtypes" of a larger relation and need to be updatable, vs those that are merely a report / literally just a "view". Thanks! Ryan -- Adrian Klaver adrian.kla...@aklaver.com

Re: Code of Conduct plan

2018-06-08 Thread Adrian Klaver
ease don't lump all Americans together as we come from many paths and often disagree on what is correct, which is what motivates my reservations about the CoC. Cheers, Gavin -- Adrian Klaver adrian.kla...@aklaver.com

Re: (2^63 - 1)::bigint => out of range? (because of the double precision)

2018-06-08 Thread Adrian Klaver
ocumentation, "The [SQL] standard's AS expression is not supported." Another "why is it so?" question, btw. ;-) Where in the docs are you seeing this? -- Adrian Klaver adrian.kla...@aklaver.com

Re: (2^63 - 1)::bigint => out of range? (because of the double precision)

2018-06-08 Thread Adrian Klaver
t. bigint is the default. The data type determines the default minimum and maximum values of the sequence. " -- Adrian Klaver adrian.kla...@aklaver.com

Re: Multiple PostgreSQL instances on one machine

2018-06-08 Thread Adrian Klaver
eloftype | 0 relowner| 10 relam | 0 relfilenode | 1836555 reltablespace | 1836554 -- Adrian Klaver adrian.kla...@aklaver.com

Re: (2^63 - 1)::bigint => out of range? (because of the double precision)

2018-06-09 Thread Adrian Klaver
On 06/09/2018 05:24 AM, Alexey Dokuchaev wrote: On Fri, Jun 08, 2018 at 10:30:45AM -0700, Adrian Klaver wrote: My guess is because sequences are often used to provide numbers for a PRIMARY KEY and NO CYCLE is a heads up for key duplication before the PK code kicks in. OK, but what about

Re: pg_upgrade and wraparound

2018-06-09 Thread Adrian Klaver
lly upgraded with pg_upgrade using similar parameters from older versions (at least 2 times, something like 9.1 -> 9.3, 9.3 -> 9.6). The database is around 700 GB and has very many pg_largeobjects in it. What could be the reason of this and how can I perform my upgrade? Thanks in advance,

Re: Fwd: compressed bits in sql table

2018-06-09 Thread Adrian Klaver
is the field type? 3) Are you referring to the TOAST table? Thanks, Sandeep -- Adrian Klaver adrian.kla...@aklaver.com

Re: Fwd: compressed bits in sql table

2018-06-09 Thread Adrian Klaver
the field? it is related to my application. thanks, Sandeep On Sun, Jun 10, 2018 at 4:04 AM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 06/09/2018 02:40 PM, SANDEEP GOURNENI wrote: > > Hi all, > > How can we read compressed bits

Re: Sort is generating rows

2018-06-10 Thread Adrian Klaver
name> <= COALESCE(s.date_order::timestamp with time zone, now()) AND (res_currency_rate.date_end IS NULL OR res_currency_rate.date_end > COALESCE(s.date_order::timestamp with time zone, now())) -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_upgrade and wraparound

2018-06-10 Thread Adrian Klaver
) Package Repo? b) Source File source? 3) Where there any issues with 9.6 cluster before you tried to upgrade from it? Thanks in advance, Alexander -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_upgrade and wraparound

2018-06-10 Thread Adrian Klaver
select oid, datname from pg_database;   oid  |  datname ---+---  13011 | template0  16400 | bof  13012 | postgres  16401 | sslentry      1 | template1 (5 rows) -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_upgrade and wraparound

2018-06-10 Thread Adrian Klaver
has the large objects? As for the prepared transactions - no, I don't have them, our application doesn't use this functionality. Did you check this view to confirm?: https://www.postgresql.org/docs/10/static/view-pg-prepared-xacts.html Just trying to eliminate possibilities. -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_upgrade and wraparound

2018-06-11 Thread Adrian Klaver
d | prepared | owner | database -+-+--+---+------ (0 rows) -- Adrian Klaver adrian.kla...@aklaver.com

Re: Fwd: Add to watchdog cluster request is rejected by node

2018-06-11 Thread Adrian Klaver
is not set up for watchdog mode. Have you looked at this: http://www.pgpool.net/docs/latest/en/html/example-watchdog.html If that does not help then I would suggest asking here: https://www.pgpool.net/mailman/listinfo/pgpool-general * * pgpool-II version :* *pgpool-II version 3.7.3 (amefuriboshi)* * Thanks. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Sort is generating rows

2018-06-11 Thread Adrian Klaver
On 06/10/2018 11:47 PM, Nicolas Seinlet wrote: Hi, a currency rate can have no company, and is then applicable to currencies which have no rate specific for the company. I see. So what happens if, for testing purposes, you eliminate the r.company_id IS NULL OR part? -- Adrian Klaver

Re: Catching unique_violation exception on specific column/index

2018-06-11 Thread Adrian Klaver
inality returns the total number of elements in an array across all dimensions. It is effectively the number of rows a call to unnest would yield: ..." ./danfe -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_upgrade and wraparound

2018-06-11 Thread Adrian Klaver
should start autovacuum, but I'd guess that's where things are going wrong for some reason. Alexander, could you hack things up so autovacuum logging is enabled (log_autovacuum_min_duration=0), and see whether it's triggered? I'm not entirely clear why pg_restore appears to use a separate transaction for each large object, surely exascerbating the problem. Greetings, Andres Freund -- Adrian Klaver adrian.kla...@aklaver.com

Re: Semantics around INSERT INTO with SELECT and ORDER BY.

2018-06-12 Thread Adrian Klaver
of rows is not guaranteed. On Tue, Jun 12, 2018 at 1:24 AM Ravi Krishna <mailto:sravikrish...@gmail.com>> wrote: Why is it even important?  Once you use ORDER BY clause, you are guaranteed to get the rows in the order.  Why do you need how it was inserted in the first place. -- Adrian Klaver adrian.kla...@aklaver.com

Re: PG on AWS RDS and IAM authentication

2018-06-12 Thread Adrian Klaver
r PG. IAM is a AWS feature, so you should probably talk to them to get the official word. The below would seem to indicate it is not possible: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.IAMDBAuth.html Thanks -- Adrian Klaver adrian.kla...@aklaver.com

Re: Software that can automatically make sense of a DB's tables and ID names

2018-06-12 Thread Adrian Klaver
a dump and build SQL? Thanks, Phil. -- Adrian Klaver adrian.kla...@aklaver.com

Re: What does Natvie Posgres mean?

2018-06-12 Thread Adrian Klaver
res-native" which is described as "...a native D implementation of the Postgres frontend/backend protocol.", but I don't get the sense that this is what is being talked about. -- B -- Adrian Klaver adrian.kla...@aklaver.com

Re: Transparent partitioning

2018-06-12 Thread Adrian Klaver
e new row, an error will be reported. Partitioned tables do not support UNIQUE, PRIMARY KEY, EXCLUDE, or FOREIGN KEY constraints; however, you can define these constraints on individual partitions. " Best regards, Braulio Oliveira -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_upgrade 10.2

2018-06-12 Thread Adrian Klaver
l. To reuse the old cluster, possibly remove the .old suffix from $PGDATA/global/pg_control; you can then restart the old cluster. " -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_upgrade 10.2

2018-06-12 Thread Adrian Klaver
see the actual command you ran? -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_upgrade 10.2

2018-06-12 Thread Adrian Klaver
bug that is not finding it when it's at the end. -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_upgrade 10.2

2018-06-12 Thread Adrian Klaver
at attempt. Is that possible? I don't so because it exited before it got the upgrading part. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Logging

2018-06-12 Thread Adrian Klaver
_statements = 'mod' and I see statements in the logs. David J. -- Adrian Klaver adrian.kla...@aklaver.com

Re: First query on each connection is too slow

2018-06-13 Thread Adrian Klaver
shared hit=1 * Planning time: 2.589 ms  Execution time: 49.467 ms* (45 rows) The same problem is when connecting to PostgreSQL from Mapnik, so it's not a psql problem. We have a lot of memory (shared_buffers = 20GB, work_mem = 100MB) and a very small db (we've upload to empty db data

Re: Merging two database dumps

2018-06-13 Thread Adrian Klaver
ypical task for logical replication to me. You needs 9.4 at least. Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company. www.2ndQuadrant.com <http://www.2ndQuadrant.com> -- Adrian Klaver adrian.kla...@aklaver.com

Re: Issues on 9.5 to 9.6 Upgrade.

2018-06-13 Thread Adrian Klaver
SQL statement or a bug in the pgdump ? Did you analyze the database after upgrading? Or at least the tables in question? Those are very different plans. -- Don Seiler www.seiler.us <http://www.seiler.us> -- Adrian Klaver adrian.kla...@aklaver.com

Re: Using GIT to caught delta between database versions

2018-06-13 Thread Adrian Klaver
the following: p plain Output a plain-text SQL script file (the default). Best, Jacek -- Adrian Klaver adrian.kla...@aklaver.com

Re: Using GIT to caught delta between database versions

2018-06-13 Thread Adrian Klaver
: https://metacpan.org/pod/sqitchtutorial I have found it very useful. It comes down to individual preference. Best, Jacek -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to reference a composite type in schemas not "public"?

2018-06-13 Thread Adrian Klaver
tality mort ); ERROR:  type "mort" does not exist SQL state: 42704 How can I reference the created composite type correctly?? Thanks Shore -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to reference a composite type in schemas not "public"?

2018-06-14 Thread Adrian Klaver
mortality "MjorTbl"."mort" ); CREATE TYPE You might have a permissions issue. In your original post where all the commands run as the same user and from the same schema? Thanks Shore -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to reference a composite type in schemas not "public"?

2018-06-14 Thread Adrian Klaver
On 06/13/2018 10:34 PM, a wrote: Sorry I was in the wrong db last time TESTDB=# \dn ?0?2 ?0?2 ?0?2 ?0?2 ?0?2|?0?2 ?? -+-- ?0?2MjorTbl | postgres ?0?2Rate?0?2 ?0?2 | postgres ?0?2public?0?2 | postgres In addition try: \dT "MjorTbl".mort

Re: PostgreSQL Volume Question

2018-06-14 Thread Adrian Klaver
going to get from A <--> B, local or remotely or both? Is there another database or program involved in the process? Thanks in advance. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Question on Buckets and Batches in explain plan

2018-06-14 Thread Adrian Klaver
uckets: 2097152  Batches: 64 Memory Usage: 112069kB     Buffers: shared hit=1 read=1036907, temp written=643448 Thanks. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Partitioning with range types

2018-06-15 Thread Adrian Klaver
separate date columns? Thanks, Jeremy -- Adrian Klaver adrian.kla...@aklaver.com

Re: Clarifying "timestamp with time zone"

2018-06-15 Thread Adrian Klaver
the timezone zone." How should the above be clarified? even renaming the type or providing an aliased type that means the same thing, something like timestamputc.  Maybe I'm crazy but I would appreciate any feedback on this and how easily it confuses. Thanks, Jeremy -- Adrian Klaver adrian.kla...@aklaver.com

Re: Partitioning with range types

2018-06-15 Thread Adrian Klaver
On 06/15/2018 09:59 AM, Jeremy Finzel wrote: On Fri, Jun 15, 2018 at 11:23 AM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 06/15/2018 08:26 AM, Jeremy Finzel wrote: Several months ago we had some detailed discussions about whether to use separat

Re: Check to see if customer exist in second table. Help needs with psql

2018-06-17 Thread Adrian Klaver
ATE a set new_column = 'f'; UPDATE a SET new_column = 't' FROM b WHERE a.id = b.id; ROLLBACK or COMMIT depending on outcome of above. Any help is appreciate it -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f18437

Re: Clarifying "timestamp with time zone"

2018-06-18 Thread Adrian Klaver
On 06/18/2018 06:24 AM, Jeremy Finzel wrote: On Fri, Jun 15, 2018 at 2:57 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 06/15/2018 12:24 PM, Jeremy Finzel wrote: Hello! We often prefer to use timestamptz or "timestamp with time zone"

Re: Load data from a csv file without using COPY

2018-06-19 Thread Adrian Klaver
ate insert statements with pg_dump —inserts. Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll find there is no forest. -- Sent from my Android device with K-9 Mail. Please excuse my brevity. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Load data from a csv file without using COPY

2018-06-19 Thread Adrian Klaver
If you can't see the forest for the trees, cut the trees and you'll find there is no forest. -- Sent from my Android device with K-9 Mail. Please excuse my brevity. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Load data from a csv file without using COPY

2018-06-19 Thread Adrian Klaver
tool which can do the job. Basically parse the csv file and insert it to the database row by row. http://csvkit.readthedocs.io/en/1.0.3/scripts/csvsql.html thanks -- Adrian Klaver adrian.kla...@aklaver.com

Re: Load data from a csv file without using COPY

2018-06-20 Thread Adrian Klaver
necessarily the same tool for each. COPY is the only way, we will use it with something comparable on the DB2 side. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Using DSN Connection and knowing windows username

2018-06-20 Thread Adrian Klaver
are outside my experience, though. David J. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Using DSN Connection and knowing windows username

2018-06-21 Thread Adrian Klaver
alue (for inputing data user, not for others?). That would depend on where you want to input the user name and for what actions? Best, Luke -- Adrian Klaver adrian.kla...@aklaver.com

Re: Using DSN Connection and knowing windows username

2018-06-21 Thread Adrian Klaver
password used to login into Access are also recognized by Postgres. Best, Luke -- Adrian Klaver adrian.kla...@aklaver.com

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

2018-06-21 Thread Adrian Klaver
ecrypt(pgp_sym_encrypt('2018-06-21', 'AES_KEY'), 'AES'); ERROR: Wrong key or corrupt data ERROR:  Wrong key or corrupt data ** Error ** ERROR: Wrong key or corrupt data SQL state: 39000 Can't find reference anywhere... Any help would be appreciated. Thanks, Moreno.- -- Adrian Klaver adrian.kla...@aklaver.com

Re: Copies or tables in schema or copiyng of database - database versioning

2018-06-22 Thread Adrian Klaver
? 3) What is the purpose of this layout? Best, Jacek -- Adrian Klaver adrian.kla...@aklaver.com

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

2018-06-22 Thread Adrian Klaver
On 06/22/2018 01:46 AM, Moreno Andreo wrote: Il 21/06/2018 23:31, Adrian Klaver ha scritto: On 06/21/2018 08:36 AM, Moreno Andreo wrote: Hi, while playing with pgcrypto I ran into a strange issue (postgresql 9.5.3 x86 on Windows 7) Having a table with a field dateofbirth text I made

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

2018-06-22 Thread Adrian Klaver
On 06/22/2018 09:50 AM, Moreno Andreo wrote: Il 22/06/2018 15:18, Adrian Klaver ha scritto: Are you sure that the entries where not encrypted with a different key because I can't replicate.(More comments below): (other replies below, inline) I'm almost sure (you're never

Re: Using COPY to import large xml file

2018-06-24 Thread Adrian Klaver
look at: https://archive.org/download/stackexchange/beer.stackexchange.com.7z because why not? Thanks, Anto. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Using COPY to import large xml file

2018-06-25 Thread Adrian Klaver
rec[3]}\t`       + `${rec[4]}\t${rec[5]}\t${rec[6]}\t${rec[7]}\t${rec[8]}\t${rec[9]}\n`;   } The stringifyClimateRecord returns a record to be inserted as a 'line' into the stream with values separated by tabs. Records is an array of data records where each record is an array. -- regards, Tim -- Tim Cross -- Adrian Klaver adrian.kla...@aklaver.com

Re: Schema/Data conversion opensource tools from MySQL to PostgreSQL

2018-06-25 Thread Adrian Klaver
-- Adrian Klaver adrian.kla...@aklaver.com

Re: Load data from a csv file without using COPY

2018-06-25 Thread Adrian Klaver
r and make the same program do both and pick the DB by a command line switch. :) HTH, Kevin -- Adrian Klaver adrian.kla...@aklaver.com

Re: Fwd: problem with using VBA connection string to postgresql

2018-06-27 Thread Adrian Klaver
d_Connection=Yes;" dbCon.ConnectionString = strConnect dbCon.Open Dim strSQl As String strSQl = "SELECT * FROM t_cpuinfo();" rst.Open strSQl dbCon.Close End Sub error is : Linked Table connection string which is working : Why? Please help, Best, Jacek -- Adrian Klaver adrian.kla...@aklaver.com

Re: Example setup for Odyssey connection pooler?

2018-06-27 Thread Adrian Klaver
/blob/master/odyssey.conf Met vriendelijke groeten, Pablo Hendrickx Open Source DBA +32 489 73 09 37 pablo.hendri...@exitas.be <mailto:pablo.hendri...@exitas.be> Quality. Passion. Personality www.exitas.be <http://www.exitas.be/> | Veldkant 31 | 2550 Kontich -- A

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