Re: [GENERAL] pgpass file type restrictions

he latter, as if it hadn't its own problems. Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pgpass file type restrictions

SSWORD environment variable, avoiding creating .pgpass in any form? Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgres

Re: [GENERAL] Restore LargeObjects on different server

hat other databases in the new instance have consumed OIDs and some happen to be equal to the ones you want to import in a new database, that doesn't matter: similar OIDs won't conflict if they're in different databases or even the same database but different tables. Best regards, -- Dani

Re: [GENERAL] Perl script is killed by SIGPIPE

that, inherited connections can't be used simultaneously by parent and child process. In general, a child process should open and close its own connection. Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite -- Sent via pgsql-general mailing lis

Re: [GENERAL] Create Action for psql when NOTIFY Recieved

h payload "bar" received from server process with PID 20033. which just needs to be piped into another step that runs your custom action. Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite -- Sent via pgsql-general mailing lis

[GENERAL] Re: Repmgr + pgbouncer - Notification of master promotion to application level ...

Hi Andreas, in my pgbouncer configured as: ;auth_file=/test/user.txt auth_query = SELECT usename, passwd FROM pg_shadow WHERE usename=$1 Of course. When try connect with command " psql -p postgres -U dba" Print erro in screen. psql: ERROR: No such user: dba But, exists user and passwd

Re: [GENERAL] Results interpretation

om a binary cursor, I don't think there is any other way to get binary results from a PQexec() call. In particular, bytea columns come back encoded as text according to the bytea_output setting. Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVe

Re: [GENERAL] Results interpretation

format. The point is that using PQexec() does not strictly mean that the results are in text, as it depends on the query itself. This might be significant if there's a requirement that your code has to work with any query. Best regards, -- Daniel Vérité PostgreSQL-powered mailer: htt

[GENERAL] PostgreSQL and Data Warehouse optimizations

Recently, I've been doing a research about data warehouse optimizations and techniques. For example, Oracle uses parallel queries, materialized views with different refresh modes, star transformations in queries, etc. Since I've never worked with PostgreSQL in an OLAP environment, I thought maybe

Re: [GENERAL] Row based permissions: at DB or at Application level?

>How could an application which gets written from scratch use PostgreSQL to >implement >row based permissions? Are you looking for this? https://www.postgresql.org/docs/9.6/static/ddl-rowsecurity.html Regards Daniel

Re: [GENERAL] Invalid field size

nd-of-line-translation filters, dropped zero bytes, dropped high bits, or parity changes.) ... Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make chan

Re: [GENERAL] Invalid field size

tegory). And if it was a transient read error, a second run of the import could even work. I don't quite see from your posts whether that particular file to import was tried and failed only once or retried and failed again. Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org T

Re: [GENERAL] Invalid field size

nly byte is wrong in the whole file, you could theorically fix it by finding the offset of the offending length and patch the wrong byte with a 0xff value. [1] https://en.wikipedia.org/wiki/Hard_disk_drive#Error_rates_and_handling Best regards, -- Daniel Vérité PostgreSQL-powered mailer:

Re: [GENERAL] Which process is actually doing the WAL writes/calls XLogFlush?

enhance the documentation for this, at least for synchronous_commit=true? The asynchronous behavior is well documented here: https://www.postgresql.org/docs/current/static/wal-async-commit.html. Again, thanks David and Adrian for your help Kind Regards Daniel

Re: [GENERAL] Which process is actually doing the WAL writes/calls XLogFlush?

>On 06/23/2017 05:50 AM, Daniel Westermann wrote: >> Hi all, >> >> as I did not find the answer in the documentation: Which background >> process is actually doing the writes/flushes to the WAL? In the docs >> ( https://www.postgresql.org/docs

[GENERAL] Which process is actually doing the WAL writes/calls XLogFlush?

-processes-explained/) this seems not to be true, right? Why do I need the wal_writer at all then when synchronous_commit is set to something else than off? Thanks for your help Daniel

Re: [GENERAL] Suddenly - LOG: could not open file "postmaster.pid": No such file or directory

cess/user/command deletes the file and when would be obtained with: # ausearch -k pgpid Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your sub

Re: [GENERAL] storing large files in database - performance

import command and see how much time it takes? That would give a baseline to compare against. Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To mak

[GENERAL] PostgreSQL upgrade best practices, please share your thoughts

please share what issues you had when upgrading and maybe how you solved it? I'd love to include as much information as possible. Thanks in advance Daniel

Re: [GENERAL] Unable to connect to Postgresql

(). Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Unable to connect to Postgresql

pache use /var/pgsql ? Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Unable to connect to Postgresql

filesystem-root of that process with # ls -ld /proc/$PID/root It should show a soft link to the directory that corresponds to the root from the point of view of the $PID process. But again, most people would use host=localhost in this setup. Best regards, -- Daniel Vérité PostgreSQL-powered mailer: ht

Re: [GENERAL] Unable to connect to Postgresql

5432"? If apache is chrooted, or secured by other means with the similar result that it cannot access the full filesystem, that's expected. In this case, connecting to localhost with TCP/IP rather than a Unix domain socket looks like the simpler solution. Best regards, -- Daniel Véri

Re: [GENERAL] Unable to connect to Postgresql

the httpd service lives in another namespace, e.g. it's chrooted. What if you try: Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] A change in the Debian install

; Note that this also applies to the other two conf files. When using the abovementioned commands you don't need or want to do that, because /etc/postgresql// is the only place they're going to be in. Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org T

Re: [GENERAL] Query never completes with low work_mem (at least not within one hour)

Daniel Westermann <daniel.westerm...@dbi-services.com> writes: >> Thank you, Merlin. As said I know that "not in" is not a good choice in this >> case but I still do not get what is going here. Why does the >> repeatedly search for NULL values when I

Re: [GENERAL] Query never completes with low work_mem (at least not within one hour)

2017-04-05 10:33 GMT+02:00 Daniel Westermann < daniel.westerm...@dbi-services.com > : 2017-04-05 10:13 GMT+02:00 Daniel Westermann < daniel.westerm...@dbi-services.com > : BQ_BEGIN 2017-04-05 9:28 GMT+02:00 Daniel Westermann < daniel.westerm...@dbi-services.com > :

Re: [GENERAL] Query never completes with low work_mem (at least not within one hour)

2017-04-05 10:13 GMT+02:00 Daniel Westermann < daniel.westerm...@dbi-services.com > : 2017-04-05 9:28 GMT+02:00 Daniel Westermann < daniel.westerm...@dbi-services.com > : BQ_BEGIN >>what is result of EXPLAIN statement for slow and fast cases? >> >>regar

Re: [GENERAL] Query never completes with low work_mem (at least not within one hour)

2017-04-05 9:28 GMT+02:00 Daniel Westermann < daniel.westerm...@dbi-services.com > : >>what is result of EXPLAIN statement for slow and fast cases? >> >>regards >> >>Pavel For work_mem=32MB explain (analyze,verbose,buffers) select coun

Re: [GENERAL] Query never completes with low work_mem (at least not within one hour)

>>what is result of EXPLAIN statement for slow and fast cases? >> >>regards >> >>Pavel For work_mem=32MB explain (analyze,verbose,buffers) select count(user_id) from users where user_id not in ( select id from ids); QUERY PLAN

Re: [GENERAL] Query never completes with low work_mem (at least not within one hour)

le to search for >the presence of null values. Try converting the query to NOT EXISTS. Thank you, Merlin. As said I know that "not in" is not a good choice in this case but I still do not get what is going here. Why does the server repeatedly search for NULL values when I decrease work_mem and why not when increasing work_mem? Regards Daniel

[GENERAL] Query never completes with low work_mem (at least not within one hour)

gsql_tmp/pgsql_tmp17817.2 What do I miss here? Shouldn't this complete with 16MB work_mem as well, even when slower, but in less than one hour? Or is this expected? Thanks for your help Daniel

[GENERAL] Is there a reason the "-v/verbose" switch is not printed with pg_dumpall --help

org>. It is mentioned in the documentation but not in the help output Regards Daniel

Re: [GENERAL] pg_restore to a port where nobody is listening?

ase, >whereas there's no big deal with psql connecting to a default >database. Ok, makes sense. Thanks all for your answers Regards Daniel

Re: [GENERAL] pg_restore to a port where nobody is listening?

@pgbox:/home/postgres/ [PG961] pg_restore -h localhost -p === -d postgres -F d -C /var/tmp/exp/ pg_restore: [archiver (db)] connection to database "postgres" failed: invalid port number: "===" Maybe it is only me, but this is not consistent behavior, is it? Regards Daniel

Re: [GENERAL] pg_restore to a port where nobody is listening?

It does Sent from my Phone > On 21 Dec 2016, at 18:40, Andreas Kretschmer <andr...@a-kretschmer.de> wrote: > > > >> Am 21.12.2016 um 18:22 schrieb Daniel Westermann: >> >> >> Now I try to import into 9.6.1 => the instance is not running but the

[GENERAL] pg_restore to a port where nobody is listening?

n give any port to pg_restore and it just seems to be fine. Even this seems to working (the copy from stdin is displayed on the screen): postgres@pgbox:/home/postgres/ [PG961] pg_restore -h localhost -p === -F d -C /var/tmp/exp/ Thanks Daniel

Re: [HACKERS] [GENERAL] Select works only when connected from login postgres

creen emulation into which paging seems to work exactly like in a normal terminal and the emacs key bindings are turned off. Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] count(*) in binary mode returns 0

elect pg_typeof(count(1)); pg_typeof --- bigint (1 row) Can you check if your code does work when the query is simply SELECT 1::bigint ? Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite -- Sent via pgsql-general mailing list

Re: [GENERAL] Storing files: 2.3TBytes, 17M file count

geobject would likely be problematic. Ideally there should be an extension implementing something like DATALINK (SQL99), with external storage. I wonder if an extension could provide custom WAL records replicating content changes to the external storage of a standby. That would be awesome. Best regar

[GENERAL] Documentation archive links broken for 6.3 up to 7.1

Hi, just noticed that the links from 6.3 to 7.1 are broken here: https://www.postgresql.org/docs/manuals/archive/ Regards Daniel

Re: [GENERAL] initdb createuser commands

string] [-cefnrs] [+line] [+/pattern/] [file...] ... Also, the same Debian/Ubuntu systems don't have initdb or pg_ctl in the default $PATH, as these commands are superseded by different distro-specific pg_* commands . This is also something that should be considered if thinking of unifying the binari

Re: [GENERAL] Errors while installing PostGIS by an unusual method

Hi Ankit, You might have specific requirements to need PG 9.6. But if 9.5 is sufficient, it will be easier to simply do a rpm/yum install. Regards, Daniel On Tue, Oct 25, 2016 at 4:08 AM, Ankit Sablok <ankit...@buffalo.edu> wrote: > Thanks for replying Tom and Asif, I think

Re: [GENERAL] Query help

Try this: select distinct vendor_no, vendor_name from ap_vendors where vendor_no in ( select vendor_no from ap_vendors group by vendor_no having array_agg(company_code) @> ARRAY['BUR','EBC','SNJ']) On Wed, Oct 5, 2016 at 1:31 PM, Bret Stern wrote: >

[GENERAL] Maximum number of exclusive locks

why would the above formula underestimate the number of object locks actually available to a transaction? Isn't it supposed to be a hard cap for such locks? Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite -- Sent via pgsql-general ma

Re: [GENERAL] Duplicate data despite unique constraint

ber. Ensure you are still skipping indexes. Once the table is clean, drop the sequence column again and re-index. Hope this helps, Daniel On Fri, Sep 2, 2016 at 11:06 PM, Albe Laurenz <laurenz.a...@wien.gv.at> wrote: > Jonas Tehler wrote: > > We’re running Postgresql 9.4.5 on Amaz

Re: [GENERAL] Do function calls the cached?

Thanks David, Lateral did the trick: CREATE VIEW with_keywords AS SELECT x,y,z, keywords.a, keywords.b, keywords.c FROM large_table l, LATERAL extract_keywords(l.*) keywords(a,b,c) Regards, Daniel On Wed, Aug 31, 2016 at 6:46 AM, David G. Johnston < david.g.johns...@gmail.com> wrote: &g

[GENERAL] Do function calls the cached?

with a high cost. But I don't see how this has any benefit in this case other than mess up the rest of my query plan. Thanks, Daniel

Re: [GENERAL] Sequential vs. random values - number of pages in B-tree

e7] range or equally well dispersed in the [0..2**32] range, the probability of a newly inserted value to compare greater or lower to any previous values of the list should be the same, so shouldn't the page splits be the same, statistically speaking? Best regards, -- Daniel Vérité PostgreSQL-powered mai

Re: [GENERAL] Sequential vs. random values - number of pages in B-tree

https://wiki.postgresql.org/wiki/XTEA Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Merging timeseries in postgres

efault inner join, your query returns no records for the given data. David J. ​ Look at the above documentation (7.2.1.1) on full join https://www.postgresql.org/docs/9.3/static/queries-table-expressions.html select coalesce(dx,dx1)as dt, n, nx1 from test full join test1 on dx=dx1; Daniel

Re: [GENERAL] psql connection option: statement_timeout

ment_timeout=1000 -c geqo=off'" psql (9.3.13) Type "help" for help. test=> show statement_timeout ; statement_timeout --- 1s (1 row) Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite -- Sent

Re: [GENERAL] Why are no NEGATORS defined in the standard operators

OK, I file a bug report. -Ursprüngliche Nachricht- Von: Julien Rouhaud [mailto:julien.rouh...@dalibo.com] Gesendet: Samstag, 11. Juni 2016 11:28 An: Daniel Migowski <dmigow...@ikoffice.de>; pgsql-general@postgresql.org Betreff: Re: [GENERAL] Why are no NEGATORS defined in the st

[GENERAL] Why are no NEGATORS defined in the standard operators

, why there is no NEGATOR clause defined here? According to the docs it should help to add NEGATOR = <> In query optimization. Is there some reason for it? Or is it a Bug in pgAdmin III that the negator is not shown? Regards, Daniel Migowski

Re: [GENERAL] Deleting a table file does not raise an error when the table is touched afterwards, why?

>> Alex Ignatov started a new thread was started on this topic as well...​ >> >> https://www.postgresql.org/message-id/c571dfc5-91b0-0df2-4e3f-45bc94c11...@postgrespro.ru >> >> >>I posted a link to this thread on his new one as well. >> >>David J.​ for completeness: same issue with data

Re: [GENERAL] Deleting a table file does not raise an error when the table is touched afterwards, why?

>>> >>>On Mon, 30 May 2016 17:35:34 +0200 (CEST), Daniel Westermann >>>(daniel.westerm...@dbi-services.com) wrote about "[GENERAL] Deleting a >>>table file does not raise an error when the table is touched >>>afterwards, why?" (in

[GENERAL] Deleting a table file does not raise an error when the table is touched afterwards, why?

by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit Thanks in advance Daniel

Re: [GENERAL] edit wiki

. The wiki editor permission requests should go to the pgsql-www@ mailinglist, remember to include your community username in the email. cheers ./daniel -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Release Notes Link is broken on the website

>> >>Provide a link to the source document where you found the link you have >>posted its the homepage http://www.postgresql.org

[GENERAL] Release Notes Link is broken on the website

just to let you know: This link is broken: http://www.postgresql.org/docs/9./static/release-9-6.html The description on the website is wrong: PostgreSQL 9.6 Beta 1, 9.5.2, 9.4.7, 9.3.12, 9.2.16 and 9.1.21 Released! Shoud be 9.5.3, shouldn't it? Cheers, Daniel

Re: [GENERAL] PG 9.5.2, freetds + tds_fdw => server crash

>> postgres@pgreporting:/home/postgres/ [PGREP] cat /etc/centos-release >> CentOS Linux release 7.2.1511 (Core) >> >> Any ideas? >File an issue here: >https://github.com/tds-fdw/tds_fdw/issues Thanks, issue created

[GENERAL] PG 9.5.2, freetds + tds_fdw => server crash

03, Msg state: 1, Msg: Changed language setting to us_english., Server: WSCORE\SQL2014, Process: , Line: 1, Level: 0 The OS is (64bit): postgres@pgreporting:/home/postgres/ [PGREP] cat /etc/centos-release CentOS Linux release 7.2.1511 (Core) Any ideas? Thanks in advance Daniel

Re: [GENERAL] Calculating Minkowski distance between two rows

I am inclined to go with Francisco's solution Daniel -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Francisco Olarte Sent: April-25-16 10:46 To: Babak Alipour Cc: Adrian Klaver; pgsql-general@postgresql.org Subject: Re

Re: [GENERAL] [HACKERS] sign function with INTERVAL?

On Wed, Apr 13, 2016 at 12:35 PM, Tom Lane wrote: > Jim Nasby writes: >> Actually, after looking at the code for interval_lt, all that needs to >> happen to add this support is to expose interval_cmp_internal() as a >> strict function. It already

[GENERAL] sign function with INTERVAL?

Hi all, Is there a good reason why the SIGN() function does not work with the INTERVAL type? (It is only defined for numeric types.) (http://www.postgresql.org/docs/9.5/static/functions-math.html) select sign(-3); -- okay select sign(interval '4 years'); -- ERROR: function sign(interval) does

Re: [GENERAL] pg_largeobject

e lo_* client-side and server-side functions that it needs. But that's a relatively easy work for a programmer, especially if the blobs happen to be immutable, as is often the case. Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite -- S

Re: [GENERAL] How Restricting user

thanks a lot David 2016-02-25 15:08 GMT-03:00 David G. Johnston : > On Thu, Feb 25, 2016 at 11:01 AM, dangal > wrote: > >> In Oracle i have something like this: >> >> -- Create profile >> create profile PROFILE_Query limit >>

[GENERAL] How Restricting user

Dear , I would like to make a query , I plan to create a user in my database , but only to make inquires , I would also like to have limits such as connection time, idle time , logical reads , is this possible? Thank you very much for your time

Re: [GENERAL] Replacement for Oracle Text

erl or PL/Python trigger function that >would populate the tsvector column on every INSERT or UPDATE. Thanks to all for your input Daniel

Re: [GENERAL] Replacement for Oracle Text

>>Daniel Westermann schrieb am 19.02.2016 um 11:53: >>> if I'd need to implement/replace Oracle Text >>> (ww.oracle.com/technetwork/testcontent/index-098492.html). >>>> What choices do I have in PostgreSQL (9.5+) ? >Postgres also has a full text searc

[GENERAL] Replacement for Oracle Text

Hi, if I'd need to implement/replace Oracle Text (ww.oracle.com/technetwork/testcontent/index-098492.html). What choices do I have in PostgreSQL (9.5+) ? Regards Daniel

[GENERAL] Question on memory management sysv/posix on Linux

Thanks in advance Daniel

[GENERAL] pgDay Asia / talks / lightning talks

and you don't have details of the lightning talks yet. Do you still need speakers for full talks or lightning talks? Also, I notice pgDay Asia is missing from the events list on the postgresql.org main page: http://www.postgresql.org/about/events/ Regards, Daniel 1. http://2016.pgday.asia 2

Re: [GENERAL] adding a bdr node using bcv backup

move along if it's already there? Thanks a lot! On Fri, Jan 22, 2016 at 6:57 AM Craig Ringer <cr...@2ndquadrant.com> wrote: > On 21 January 2016 at 20:46, (Daniel Stolf) <dst...@gmail.com> wrote: > > >> So here's what I don't get: >> >> 1) if I have to create

Re: [GENERAL] long transfer time for binary data

docs/current/static/protocol-flow.html#AEN108750 and the result comes back as binary. Presumably the JDBC LargeObjectManager uses that method. Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite -- Sent via pgsql-general mailing list (pgsql-gen

Re: [GENERAL] long transfer time for binary data

for retrieving them efficiently, as opposed to "SELECT lo_get(oid)" which looks like it could trigger the undesirable round-trip to the text format. You may want to test that or bring it up as a question to JDBC folks. Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://w

Re: [GENERAL] adding a bdr node using bcv backup

---++---++--++--+--+- (0 rows) On Thu, Jan 21, 2016 at 10:46 AM (Daniel Stolf) <dst...@gmail.com> wrote: > Ok, I'm at work now and I have access to my lab... > > * On Node 1: * > bdrdemo=# select bdr.bdr_get_local_nodeid(); >

Re: [GENERAL] adding a bdr node using bcv backup

f of node3 on their name? 2) If node3 has the same name and if as node1, won't that introduce a conflic? Don't I need to clean that up before node3 can join the replication group? Regards, Daniel Stolf On Thu, Jan 21, 2016 at 8:34 AM (Daniel Stolf) <dst...@gmail.com> wrote: > Hi Craig, how

Re: [GENERAL] adding a bdr node using bcv backup

1 January 2016 at 08:29, (Daniel Stolf) <dst...@gmail.com> wrote: > >> Hello there... >> >> I'm new to postgres and I'm trying out BDR replication... >> >> I know that when I issue the bdr.bdr_group_join command, it will copy the >> entire databas

[GENERAL] adding a bdr node using bcv backup

Hello there... I'm new to postgres and I'm trying out BDR replication... I know that when I issue the bdr.bdr_group_join command, it will copy the entire database from the host I specify on parameter 'join_using_dsn' and this may take a while depending on the network and the size of the

[GENERAL] adding a bdr node using bcv backup

Hello there... I'm new to postgres and I'm trying out BDR replication... I know that when I issue the bdr.bdr_group_join command, it will copy the entire database from the host I specify on parameter 'join_using_dsn' and this may take a while depending on the network and the size of the

[GENERAL] pg_dump executed on a hosts against another host fails with pg_dump: [archiver (db)] query was: SET search_path = pg_catalog, sys, dbo

talog, sys, dbo search_path on the target is: xx=# show search_path; search_path "$user",public (1 row) Any ideas? Thanks, Daniel

Re: [GENERAL] pg_dump executed on a hosts against another host fails with pg_dump: [archiver (db)] query was: SET search_path = pg_catalog, sys, dbo

n of postgres that this >mail list supports. sure, thanks daniel

Re: [GENERAL] Error creating Tablespace on Windows

From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of deepak Sent: November-25-15 17:07 To: John R Pierce Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Error creating Tablespace on Windows I chose temp only for illustration purposes.

Re: [GENERAL] Does PostgreSQL ever create indexes on its own?

.pa.us> wrote: >Thomas Kellerer <spam_ea...@gmx.net> writes: >> Doiron, Daniel schrieb am 12.11.2015 um 23:21: >>> I¹m troubleshooting a schema and found this: >>> >>> Indexes: >>> "pk_patient_diagnoses" PRIMARY KEY, btree (id) >

[GENERAL] Does PostgreSQL ever create indexes on its own?

I’m troubleshooting a schema and found this: Indexes: "pk_patient_diagnoses" PRIMARY KEY, btree (id) "index_4341548" UNIQUE, btree (id) "idx_patient_diagnoses_deleted" btree (deleted) "idx_patient_diagnoses_diagnosis_type_id" btree (diagnosis_type_id)

Re: [GENERAL] *** QUESTION *** After successful 'BEGIN;' command -- why PGSQL_TRANSACTION_ACTIVE and not PGSQL_TRANSACTION_INTRANS?

t 2, which corresponds to PGSQL_TRANSACTION_INTRANS as expected. OTOH if commenting the call to pg_get_result($dbcnx), then it ouputs 1 (PGSQL_TRANSACTION_ACTIVE) as you mentioned. Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite -- Sent via pgsq

Re: [GENERAL] Issues with german locale on CentOS 5,6,7

something like that make sense? Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] md5(large_object_id)

nds to digest a 100 MB audio file already in cache. An independant Perl script doing the equiavlent processing on the same data takes 0.4s . It's not because of Digest::MD5 or loread(), it seems that it's the pipe in-between with the text->bytea decoding that eats most of the CPU cycles, that step

[GENERAL] Unexpected query result

In order to process a large amount of data I need to run a procedure using parallel batch processes. The query I run in each process is expected to ... 1- select a bunch of id (500) in a table (wait4processing) containing the list of all records to process2- remove selected records from

Re: [GENERAL] Unexpected query result

Thank Adrian, it makes sense. I'll adapt the calling procedures Daniel > Subject: Re: [GENERAL] Unexpected query result > To: jfd...@hotmail.com; pgsql-general@postgresql.org > From: adrian.kla...@aklaver.com > Date: Mon, 5 Oct 2015 06:17:33 -0700 > > On 10/05/2015 05:02 AM,

Re: [GENERAL] Advise on memory usage limitation by PostgreSQL on Windows

set shared_buffers = 128MB with an effective_cache_size = 12GB Daniel From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Venkata Balaji N Sent: September-22-15 21:33 To: pgsql-general Subject: [GENERAL] Advise on memory usage limitation

[GENERAL] PostgreSQL and Windows 10 upgrade

Does anyone running PostgreSQL 9.3 on Windows 7 has upgraded to Windows 10? Successfully or not. Daniel

Re: [GENERAL] clone_schema function

ng the entire body of a function without a fully-fledged parser that is dead on arrival. Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make ch

Re: [GENERAL] clone_schema function

NCTION, DECLARE would become DECLBRE and so on. Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/ma

Re: [GENERAL] PostgreSQL Developer Best Practices

these will be 128 bits, but that's years ahead. Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] INSERT ... ON CONFLICT DO UPDATE

regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @ManitouMail -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] INSERT ... ON CONFLICT DO UPDATE

malicious people could claim access codes or vouchers they don't own. The constraint is that such codes must be reasonably short, but someone who tries to make up one must have a near-zero chance of guessing one that actually exists. Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http

Re: [GENERAL] utf8 encoding problem with plperlu

the current encoding is UTF-8. If Active Directory wants UTF-16LE, you have to do that conversion, but don't pass the result back to postgres in this format. Best regards, -- Daniel PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] PG 9.4.4 issue on French Windows 32 bits

messages, set it to C, otherwise someone more knowledgeable in Windows might suggest a proper explanation and fix. Personally I don't understand in the first place how UTF-8 is handled with '*.1252' locales, as cp1252 seems incompatible with UTF-8 by definition. Best regards, -- Daniel PostgreSQL

  1   2   3   4   5   6   7   8   >