Re: [GENERAL] Update statement results in Out of memory

ions:_ * PostgreSQL 9.5.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 5.3.1 20160406 (Red Hat 5.3.1-6), 64-bit * POSTGIS="2.2.2 r14797" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel. 4.9.1, 04 March 2015" GDAL="GDAL 2.0.2, released 2016/01/26"

Re: [GENERAL] Materialized view not created with import

s restored. list-file is normally created by editing the output of a previous -l operation. Lines can be moved or removed, and can also be commented out by placing a semicolon (;) at the start of the line. See below for examples. " Thank you, Aurélien Praga -- Adrian Klaver adr

Re: [GENERAL] pg_dump fundenental question

to compress. SEE HERE *> The tar archive format currently does not support compression at all. " Regards, Henk -- Adrian Klaver adrian.kla...@aklaver.com -- 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] Avoid deadlocks on alter table

e table referenced by the constraint. " Thanks. -- /Christian Castelli skype: christrack/ -- Adrian Klaver adrian.kla...@aklaver.com -- 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] Cluster on NAS and data center.

files on binary level. Can You help us pick proper compilation flags? If that where possible tools like pg_upgrade would be able to upgrade between OSes. What do you want the role of the UNIX data center to be, a continuous standby, a place where you store backups, something else? -- Adrian

Re: [GENERAL] Unable to recovery due missing wal_file

worth? Let's see.... =\ -- Adrian Klaver adrian.kla...@aklaver.com -- 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 recovery due missing wal_file

d here: https://www.postgresql.org/docs/9.5/static/wal-configuration.html So the wal archiving you have set up is not storing everything, it removes older files over time? -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to yo

Re: [GENERAL] Unable to recovery due missing wal_file

B that are 000213B4001A? I'll re-do the steps but now using the STREAM option. -- Adrian Klaver adrian.kla...@aklaver.com -- 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 recovery due missing wal_file

n the original server, which seemed to be not the case per your previous post. -- Adrian Klaver adrian.kla...@aklaver.com -- 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 recovery due missing wal_file

ork =( Is there any tips you guys could give me on this situation? Should I check the backup_label file when the pg_basebackup starts, and check if the wal_file inside the backup_label file exists? Thanks Patrick -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing

Re: [GENERAL] 9.3 to 9.5 upgrade problems

2:/pub/pg95/ That should make sure the copies are exact. -Andy That seemed to have worked. Took forever, but once I started the slave on web2 I was able to login and run queries without any errors or problems. Glad it worked out. Thanks Adrian, -Andy -- Adrian Klaver adrian.kla...@a

Re: [GENERAL] deadlock between "WITH agg_tmp AS ({sel_stmt}), upd AS ({upd_stmt}) {ins_stmt}" and pure UPDATE statements

ml ON CONFLICT Clause https://www.depesz.com/2015/05/10/waiting-for-9-5-add-support-for-insert-on-conflict-do-nothingupdate/ If not you might to take a look at: http://stackoverflow.com/questions/17267417/how-to-upsert-merge-insert-on-duplicate-update-in-postgres Bulk upsert with lock Thanks!

Re: [GENERAL] deadlock between "WITH agg_tmp AS ({sel_stmt}), upd AS ({upd_stmt}) {ins_stmt}" and pure UPDATE statements

tion. So how in PostgreSQL-world 2 or more transactions can update the same table without deadlocking? I can't believe it's not possible, there must be some sort of synchronization primitive. Does it support a "named mutex" concept from a system-programming world? I bet

Re: [GENERAL] 9.3 to 9.5 upgrade problems

On 07/03/2016 08:49 AM, Andy Colson wrote: On 07/03/2016 10:35 AM, Adrian Klaver wrote: On 07/03/2016 08:06 AM, Andy Colson wrote: Hi all, I have a master (web1) and two slaves (web2, webserv), one slave is quite far from the master, the db is 112 Gig, so pg_basebackup is my last resort. I

Re: [GENERAL] 9.3 to 9.5 upgrade problems

s" on the slave I get: psql: FATAL: cache lookup failed for database 16401 This is only on web2, its close to web1, so I'm hoping I can get it fixed and then rsync it quickly to the far away slave. I'm at a loss here, any hints or suggestions would be appreciated. Thanks, -Andy

Re: [GENERAL] deadlock between "WITH agg_tmp AS ({sel_stmt}), upd AS ({upd_stmt}) {ins_stmt}" and pure UPDATE statements

INSERT INTO T1 (...) SELECT ... FROM agg_tmp s LEFT JOIN upd t ON (...) WHERE ...; Process 71221: UPDATE T1 SET ... FROM trans1_T_tmp WHERE ...",,,"" On 07/02/16 11:14, Adrian Klaver wrote: On 07/02/2016 09:54 AM, trafdev wrote: > Hello. > > I ha

Re: [GENERAL] deadlock between "WITH agg_tmp AS ({sel_stmt}), upd AS ({upd_stmt}) {ins_stmt}" and pure UPDATE statements

hanks! -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: --EXTERNAL--Re: [GENERAL] PSQL does not remove obvious useless joins

ssumptions against a statistical picture of the data but shouldn't be expected to actually inspect precise result data in order to generate a better plan. merlin -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make cha

Re: [GENERAL] Update multiple rows in a table with different values

values 20 -> 275 , 30 -> 375 Is there a way to update multiple rows with different column values passed in as array. Also is there a guarantee that the order of the arrays will be maintained. Thanks -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general maili

Re: [GENERAL] PostgreSQL 9.5 and PL/Ruby install problem(Centos 6 64 bit)

mp;match_type=all&search_keywords=ruby Clicking on the link yielded: "The topic you are trying to see does not exist." So you might want to try again there. Hanan Brener Database and Data Collection Team Leader Allot Communications -----Original Message- From: Adrian Klaver [m

Re: [GENERAL] PostgreSQL 9.5 and PL/Ruby install problem(Centos 6 64 bit)

it could be done... *Hanan Brener* *Database and Data Collection Team Leader* Allot Communications -- Adrian Klaver adrian.kla...@aklaver.com -- 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] Stored procedure version control

you are currently using. -- Adrian Klaver adrian.kla...@aklaver.com -- 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] Enquiry

could point me in the right direction. See the post from Andreas. Thanks Mohammed Abdul Azeem -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] Corrupted Dabatabase

_marc http://www.linkedin.com/in/paumarc http://www.researchgate.net/profile/Pau_Marc_Torres3/info/ 2016-06-27 16:09 GMT+02:00 Adrian Klaver mailto:adrian.kla...@aklaver.com>>: On 06/27/2016 06:52 AM, Pau Marc Muñoz Torres wrote: hi thank you for your quick answer,

Re: [GENERAL] Corrupted Dabatabase

ux, etc). Also what file system Postgresql data dir is using? Alex Ignatov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)

Re: [GENERAL] dblink authentication failed

rds, Attila <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> Mentes a vírusoktól. www.avast.com <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&a

Re: [GENERAL] What Causes Access Exclusive Lock?

Eng Building, Singapore 069 533 T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com -- Adrian Klaver adrian.kla...@aklaver.com -- 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] pg_restore error-s after pg_dump

Y ir_act_window_view, line 88: ""* Any advice to solve this problem ? -- View this message in context: http://postgresql.nabble.com/pg-restore-error-s-after-pg-dump-tp5909084.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Adrian Klaver adrian.kla...@aklaver.com -- 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] optimizing a query

b_id) AS counted FROM t_a2b WHERE t_a2b.col_a = 1 AND t_a.col_1 = 730 AND t_a.col_2 IS NOT False GROUP BY t_a2b.b_id ORDER BYcounted DESC, t_

Re: ***SPAM*** Re: [GENERAL] random huge delay when recreate a VIEW or FUNCTION

.eu <http://www.plationline.eu> www.livrarionline.ro <http://www.livrarionline.ro> www.c-solution.biz <http://www.c-solution.biz> Skype: catalinmaftei Mobile: +40723 338 598 On 6/15/2016 7:36 AM, Adrian Klaver wrote: On 06/14/2016 02:59 PM, Catalin Maftei

Re: [GENERAL] Re: regarding schema only migration from sqlserver to postgres with runmtk.sh

who comes across this thread when having the same problem, what did you do to get it to work? thank you for information On Thu, Jun 16, 2016 at 11:43 PM, Durgamahesh Manne mailto:maheshpostgr...@gmail.com>> wrote: thank you for the information related to postgres -- Adrian

Re: [GENERAL] regarding schema only migration from sqlserver to postgres with runmtk.sh

"target" database is invalid. Check the connectivity credentials. same error repeated even there mentioned correct credentials as here i checked multiple times ​Maybe you should try using an IP address instead of a host name.

Re: [GENERAL] regarding schema only migration from sqlserver to postgres with runmtk.sh

you have a user and associated password set for the Postgres database? thank you -- Adrian Klaver adrian.kla...@aklaver.com -- 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] regarding schema only migration from sqlserver to postgres with runmtk.sh

://archive.trustfort.com:5432 <http://archive.trustfort.com:5432>/edb thank you for the valuable information So does this mean the migration is working now? -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes t

Re: [GENERAL] Data ingestion failing when using higher Batch size

f that is something the Java tools are supplying or not. Might be instructive to look at the Postgres server logs when you run the the code. Have you tried running the code directly against the Postgres server without going through PgBouncer? Thanks & Regards, Rupesh Choudhary --

Re: [GENERAL] Moving from PHP to Java: A result was returned when none was expected.

iver workaround that fact? Because JDBC is meant to be used against many database engines and is meant to be fairly generic? Regards Alex -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: Fwd: [GENERAL] regarding schema only migration from sqlserver to postgres with runmtk.sh

you did and how it failed. 3) Then try the migration tool. If that fails contact EDB. may i know recommended approach to migrate the tables from sql server to postgresql instead of using 3rd party tools thank you -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-gen

Re: ***SPAM*** Re: [GENERAL] random huge delay when recreate a VIEW or FUNCTION

i Mobile: +40723 338 598 On 6/15/2016 7:36 AM, Adrian Klaver wrote: On 06/14/2016 02:59 PM, Catalin Maftei wrote: when I recreate a VIEW or FUNCTION with a small change I get: What are the actual statements you are running? What program are you running them from? Is the server you are runnin

Re: [GENERAL] random huge delay when recreate a VIEW or FUNCTION

successfully with no result in 03:58 minutes. we have pg 9.4 -- Best regards, Catalin Maftei www.plationline.eu www.livrarionline.ro www.c-solution.biz Skype: catalinmaftei Mobile: +40723 338 598 -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Data ingestion failing when using higher Batch size

oke(MethodProxy.java:204) Thanks & Regards, Rupesh Choudhary -- Adrian Klaver adrian.kla...@aklaver.com -- 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] Automate copy - Postgres 9.2

orm the commands in the function to 40 different account_ids: select function (40); How can I do that? I can't... I believe this has been asked and answered, namely there needs to be further information on how you want to determine the account ids to be selected. Cheers Patrick -- Ad

Re: [GENERAL] pgAdmin 4 beta not working on Windows 10

Path" and an "Application Path". I pointed that to c:\Program Files (x86)\pgAdmin 4\v1\runtime\python27.dll and c:\Program Files (x86)\pgAdmin 4\v1\runtime\pgAdmin4.exe but after that, nothing happens. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-gene

Re: [GENERAL] Changelog version from 8.1.2 to 9.3.6

. Thanks in advance . Regards, Yogesh -- Adrian Klaver adrian.kla...@aklaver.com -- 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] Retrieving comment of rules and triggers

-- Adrian Klaver adrian.kla...@aklaver.com -- 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] Automate copy - Postgres 9.2

g the function, I want to specify the numbers of account_Ids I wanna do the dump Unclear. Single id as you show, a range of numbers or an array of numbers? Can anybody give me a help here please? You will get better help quicker if you are clearer in your problem description and include il

Re: [GENERAL] Re-sync slave server

On 06/08/2016 01:47 PM, Patrick B wrote: 2016-06-08 11:03 GMT+12:00 Adrian Klaver mailto:adrian.kla...@aklaver.com>>: On 06/07/2016 03:22 PM, Patrick B wrote: One more question guys... Does the pg_basebackup re-write the data? or do I have to have free

Re: [GENERAL] Re-sync slave server

://www.postgresql.org/docs/9.2/static/app-pgbasebackup.html cheers -- Adrian Klaver adrian.kla...@aklaver.com -- 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] Re-sync slave server

because the DB is 2.2TB, don't wanna do one step and discover later that did not work and have to do all over again Cheers Patrick -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.

Re: [GENERAL] PL/PGSQL + inserts+updates+limit - Postgres 9.3

do all the work just for that specific account_id? https://www.postgresql.org/docs/9.5/static/plpgsql-declarations.html#PLPGSQL-DECLARATION-PARAMETERS If you guys please could give me the way to do that.. thanks Patrick -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general ma

Re: [GENERAL] Re-sync slave server

dy been recycled? Question: Do I need to sync all the data folder from my master Or just doing an incremental rsync would work? Thanks Patrick -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your s

Re: [GENERAL] Postgres Dropped DB have recovered files how to restore

hat you show is everything then you are short some important directories. -- View this message in context: http://postgresql.nabble.com/Postgres-Dropped-DB-have-recovered-files-how-to-restore-tp5906468.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Adr

Re: [GENERAL] Londiste3 - Ubuntu 16.04 - Postgresql 9.3

s binaries. You are building from source. What where the steps you took to configure and build the package? Where there any error/warning messages when building? My suspicion is the below from the INSTALL file: "--prefix:: Path prefix where to install skytools files (default: /usr/local

Re: [GENERAL] PL/PGSQL + inserts+updates+limit - Postgres 9.3

you have between the data and the various tables. Then work out an outline form of how to walk the data back from those tables into its original location(s). cheers -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] pgFoundry down

On 06/03/2016 08:42 AM, Leonardo M. Ramé wrote: Hi, I'm trying to download Skytools 3.2 but pgFoundry seems to be down, does anyone know another place to download it?. I just tried it and got through: http://pgfoundry.org/projects/skytools/ Regards, -- Adrian Klaver adria

Re: [GENERAL] PL/PGSQL + inserts+updates+limit - Postgres 9.3

' LOOP -- Creating the backup table with the essential data INSERT INTO table2 (row.note_id, row.size, row.file_id, row.full_path) . Still not seeing what the JOIN to table3 t3 gets you? Any way the function works. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general m

Re: [GENERAL] PL/PGSQL + inserts+updates+limit - Postgres 9.3

t2.migrated = 0 - The third and last *update*, deletes (set the blobs column as null) the blobs that have already been touched by the above queries Still.. don't know how to tell postgres to only touches the rows that have been touched by the above queries

Re: [GENERAL] Slave claims requested WAL segment already removed - but it wasn't

be prevented in the future? Thanks, Jeff -- Adrian Klaver adrian.kla...@aklaver.com -- 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] PL/PGSQL + inserts+updates+limit - Postgres 9.3

if possible can you please give me an example of that LIMIT in some of those queries? I do not what you are trying to LIMIT/OFFSET, so I have no idea where to place the LIMIT/OFFSET. Maybe an example query showing what you are trying to do will help? Thanks -- Adrian Klaver adrian.kla

Re: [GENERAL] PL/PGSQL + inserts+updates+limit - Postgres 9.3

t, but I see no LIMIT in the function. I do see OFFSET and it looks backwards to me?: || $1 ||' offset '|| https://www.postgresql.org/docs/9.5/static/sql-select.html LIMIT Clause The LIMIT clause consists of two independent sub-clauses: LIMIT { count | ALL } OFFSET start Also I not sur

Re: [GENERAL] Row security policies documentation question

/blog.2ndquadrant.com/application-users-vs-row-level-security/ Thanks! Alex -- Adrian Klaver adrian.kla...@aklaver.com -- 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] plql and or clausule

l tipo de los argumentos. Puede ser necesario agregar conversiones explícitas de tipos. Context: función PL/pgSQL lst_tot_mytable_log() en la línea 12 en IF sentencia SQL: «UPDATE lst_tot_mytable set fultimamodificacion = now(), esmodificadoerspectoaanterior = true WHERE nropeti = OLD.nropeti» funci

Re: [GENERAL] How to find business partners from PostgreSQL communities?

st effective, efficient, and appropriate ones for me to take to have my awesome or yet another awful "idea" be delivered to those targeted PostgreSQL endorsers? Deliver a working prototype of an idea that other folks can look at. Thank you in advance! Best Regards, CN -- Adrian Kl

Re: [GENERAL] Do docs miss information about timing of triggers?

. }}} OK, timing of constraint triggers is explained. But I think the docs don't state the timing of normal AFTER triggers. Or am I blind? Look about seven paragraphs up from the one you show above. Regards, Thomas Güttler -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-ge

Re: [GENERAL] postgres 9.5 create function plpthon3u resets connections to server

LL [ ^6] KERNEL32.DLL [F^6] NTDLL.DLL -- Adrian Klaver adrian.kla...@aklaver.com -- 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] postgres 9.5 create function plpthon3u resets connections to server

ve missed? This question is also posted on stackoverflow here <https://stackoverflow.com/questions/37382511/postgres-9-5-create-function-plpthon3u-resets-connections-to-server>. Thanks in advance for your help. Many thanks -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-ge

Re: [GENERAL] postgresql embedded mode

aluka -- Adrian Klaver adrian.kla...@aklaver.com -- 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] 9.5 CentOS 7 setting PGDATA for systemctl

On 05/22/2016 09:06 AM, Tory M Blue wrote: On May 22, 2016, at 07:50, Adrian Klaver wrote: So where did you get the 'stock' RPM's from, CentOS or the Postgres repos? Postgres yum repos (I like this btw) I do not use CentOS myself, so I will point you

Re: [GENERAL] 9.5 CentOS 7 setting PGDATA for systemctl

g spaces, # but there's not much I can do about it given systemctl's output format... PGDATA=`systemctl show -p Environment "${SERVICE_NAME}.service" | sed 's/^Environment=//' | tr ' ' '\n' | sed -n 's/^

Re: [GENERAL] PostgreSql Doubt

d postgresql prepaired any api kind of fdw officially ? If I am following then the link at question 1 should address this. If I am not you will need to be provide more information about what you are looking for. Thanks aluka -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-gen

Re: [GENERAL] Debugging a backend stuck consuming CPU

ime of the command and/or currently? What OS and does it's system log show anything? Can you query pg_stat_activity? http://www.postgresql.org/docs/9.2/static/monitoring-stats.html#PG-STAT-ACTIVITY-VIEW Regards, Ken -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-gener

Re: [GENERAL] WAL files not being recycled

y be set in the postgresql.conf file or on the server command line. " Thanks in advance. -- Scott Moynes VM Farms -- Adrian Klaver adrian.kla...@aklaver.com -- 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] Connections - Postgres 9.2

On 05/16/2016 02:25 PM, John R Pierce wrote: On 5/16/2016 2:11 PM, Adrian Klaver wrote: Yes a connection consumes resources. an idle connection consumes some memory, a process context, and a network socket. its not using CPU or disk IO. True, but the existence of poolers says that can be

Re: [GENERAL] Connections - Postgres 9.2

On 05/16/2016 02:00 PM, John R Pierce wrote: On 5/16/2016 1:55 PM, Adrian Klaver wrote: Would the pool connection solve that IDLE connections? But more important than that, are the IDLE connections using the machine's resources ? Yes a connection consumes resources. an idle conne

Re: [GENERAL] Connections - Postgres 9.2

more important than that, are the IDLE connections using the machine's resources ? Yes a connection consumes resources. cheers -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscrip

Re: [GENERAL] Any difference between commit/rollback when only temp tables and \copy are used

le will be dropped at the end of the current transaction block. " The script runs on Ubuntu inside a bash shell's heredoc. Thanks! David J. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Connections - Postgres 9.2

d. " Thank you and bye Charles Francisco Olarte. -- Adrian Klaver adrian.kla...@aklaver.com -- 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] Fast way to delete big table?

for tableA If deleting all entries, then simply truncate it! N.B. I have NOT checked the fine print in the documentation, nor tested this - so be warned! :-) Cheers, Gavin -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

Re: [GENERAL] How to use row values as function parameters

the below worked: test=# WITH func_cte AS ( SELECT crtKAIVE(ko.doktyyp) FROM ko )SELECT * from func_cte ; crtkaive -- 1 (1 row) test=# WITH func_cte AS ( SELECT crtKAIVE(ko.doktyyp) FROM ko )SELECT crtKAIVE from func_cte ; crtkaive ------ 1 (1 row) Andrus. -- Ad

Re: [GENERAL] How to use row values as function parameters

function expression in FROM cannot refer to other relations of same query level How to fix this so that ko can used to pass parameters to crtkaive ? Posted also in http://stackoverflow.com/questions/37231624/how-to-use-table-row-values-as-function-parameters Andrus. -- Adrian Klaver adria

Re: [GENERAL] downloaded 9.1 pg driver but odbcad32 doesnt see it

will make a JDBC driver work with an ODBC tool(odbcad32). -- Adrian Klaver adrian.kla...@aklaver.com -- 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

;t it? I just checked back and both issues are fixed. Cheers, Daniel -- Adrian Klaver adrian.kla...@aklaver.com -- 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

Released! Shoud be 9.5.3, shouldn't it? Cheers, Daniel -- Adrian Klaver adrian.kla...@aklaver.com -- 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] Using both ident and password in pg_hba.conf

On 05/09/2016 01:18 PM, D'Arcy J.M. Cain wrote: On Mon, 9 May 2016 13:02:53 -0700 Adrian Klaver wrote: So define PHP runs as 'nobody'? Because of the way PHP and Apache works PHP script have to run as the Apache user which, in my case anyway, is "nobody" so every

Re: [GENERAL] Using both ident and password in pg_hba.conf

ript's user permissions? Or is that the database user the script is connecting as? Is 'nobody' defined as a database user? Cheers. -- Adrian Klaver adrian.kla...@aklaver.com -- 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] Debian and Postgres

On 05/05/2016 07:29 PM, rob stone wrote: Hello Adrian,On Thu, 2016-05-05 at 13:47 -0700, Adrian Klaver wrote: Exactly. Showing the list the error you get when you cannot connect help may with solving that problem and save you a great of time. What have you got to lose? I have nothing to

Re: [GENERAL] Debian and Postgres

howing the list the error you get when you cannot connect help may with solving that problem and save you a great of time. What have you got to lose? Cheers, rob -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Debian and Postgres

On 05/05/2016 01:29 PM, rob stone wrote: Hello Adrian,On Wed, 2016-05-04 at 21:08 -0700, Adrian Klaver wrote: So Debian does not rotate the logs into history.log..gz? Yes, it does! Didn't realise it. You learn something every day. 23 packages removed and 31 purged. Going thru the

Re: [GENERAL] Debian and Postgres

On 05/04/2016 07:40 PM, rob stone wrote: On Wed, 2016-05-04 at 16:50 -0700, Adrian Klaver wrote: On 05/04/2016 04:38 PM, rob stone wrote: Hmm, it is Ubuntu not Debian, but: sudo apt-get remove whois vi /var/log/dpkg.log 2016-05-04 16:42:39 status installed whois:amd64 5.1.1 2016-05-04 16

Re: [GENERAL] Debian and Postgres

On 05/04/2016 04:38 PM, rob stone wrote: On Wed, 2016-05-04 at 14:51 -0700, Adrian Klaver wrote: I can connect via psql and issue queries without any problems. Trying to connect via JDBC fails. Trying to connect by an application fails. Are you using the same connection parameters? In

Re: [GENERAL] Debian and Postgres

es psql (9.5.2) libpq5_9.5.2-1_amd64.deb Any assistance appreciated. Thanks, Rob -- Adrian Klaver adrian.kla...@aklaver.com -- 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] ruby pg connection fails on centos - okay on debian and dev machine

On 05/04/2016 05:26 AM, john.tiger wrote: On 05/03/2016 06:18 PM, Adrian Klaver wrote: On 05/03/2016 05:07 PM, john.tiger wrote: our model.rb runs fine on a dev machine and a debian server but is failing on a new centos server - checked the postgres db name and user name and password - all

Re: [GENERAL] Do parallel queries work with only dblink not with fdw?

FDW are you using? 3) What version(s) of Postgres are you connecting from/to? Thanks Klaus Pieper -- Adrian Klaver adrian.kla...@aklaver.com -- 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] ruby pg connection fails on centos - okay on debian and dev machine

or maybe CORS ? CORS as in: https://en.wikipedia.org/wiki/Cross-origin_resource_sharing or something else? Have you tried connecting using psql with same parameters? Have you looked at the pg_hba.conf files on the different platforms and see if they differ? -- Adrian Klaver adrian.kla..

Re: [GENERAL] Function PostgreSQL 9.2

recommended and study them BEFORE you continue attempting to design your database. You need a firm understanding of logical design & flow, otherwise you will be wasting your time. That's what I'm doing.. Studying.. asking for some help to get a better understand.... isn

Re: [GENERAL] Function PostgreSQL 9.2

evious is correct --> make corrections or not --> implement. Instead what seems to have happened is: implement --> get painted into corner --> ask how to escape corner. Hence the frustration on the part of list members. -- Adrian Klaver adrian.kla...@aklaver.com -- Se

Re: [GENERAL] Field size become unlimited in union...

docs/9.5/static/typeconv-union-case.html 10.5. UNION, CASE, and Related Constructs Thanks Regards dd -- Adrian Klaver adrian.kla...@aklaver.com -- 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] Primary Keys

e = 'PRIMARY KEY'); *NOTE* The information returned is dependent on the privileges of the user running the query, so if you want to see everything run as a superuser. Thanks in advance! -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailin

Re: [GENERAL] "Keyed" sequence?

tion et Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] CREATE EXTENSION without superuser access

On 04/27/2016 04:06 PM, Steve Atkins wrote: On Apr 27, 2016, at 3:47 PM, Adrian Klaver wrote: On 04/27/2016 03:30 PM, Steve Atkins wrote: Is there any way to install an extension either from a SQL connection or from a user-defined directory instead of .../extensions? Have not tried it

Re: [GENERAL] CREATE EXTENSION without superuser access

On 04/27/2016 03:30 PM, Steve Atkins wrote: On Apr 27, 2016, at 2:47 PM, Adrian Klaver wrote: On 04/27/2016 01:22 PM, Steve Atkins wrote: I have an app that would benefit from being able to use pg_partman rather than doing it's own ad-hoc partition management. Unfortunately, some o

<    6   7   8   9   10   11   12   13   14   15   >