Re: [GENERAL] run 2 instances of postgres 9.4 on same linux VM

to spin up another VM and test. Seems the safest way to make sure you do not trample over your live server. On Mon, Nov 9, 2015 at 9:57 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 11/09/2015 06:03 PM, anj patnaik wrote: CCing list I used the gra

Re: [GENERAL] Best tool to pull from mssql

syncing or something in between? Is this the proper way to handle the process? Depends on the answer to the above. -- 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

Re: [GENERAL] Disk I/O Question

ks again!! Terry -- View this message in context: http://postgresql.nabble.com/Disk-I-O-Question-tp5873364p5873398.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@po

Re: [GENERAL] Best tool to pull from mssql

ODBC usage. : https://www.mssqltips.com/sqlservertip/3661/creating-twoway-data-access-between-sql-server-and-postgresql--part-1/ https://www.mssqltips.com/sqlservertip/3662/sql-server-and-postgresql-linked-server-configuration--part-2/ -Original Message- From: Adrian Klaver [mailto:adria

Re: [GENERAL] Disk I/O Question

e.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] Disk I/O Question

. -- View this message in context: http://postgresql.nabble.com/Disk-I-O-Question-tp5873364p5873428.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

Re: [GENERAL] Best tool to pull from mssql

stall the Postgres server in a Linux VM on your Windows machine. -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, November 10, 2015 1:49 PM To: Mammarelli, Joanne T; pgsql-general@postgresql.org Subject: Re: [GENERAL] Best tool to pull from mssql

Re: [GENERAL] Best tool to pull from mssql

, but that would be redundant if you are using VM. -Original Message----- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, November 10, 2015 2:12 PM To: Mammarelli, Joanne T; pgsql-general@postgresql.org Subject: Re: [GENERAL] Best tool to pull from mssql On 11/10/201

Re: [GENERAL] attempting to install tds_fw-master on redhat

make target `/usr/lib64/pgsql/pgxs/src/makefiles/pgxs.mk'.. [root@scsblnx-994457 tds_fdw-master]# Any ideas? -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresq

Re: [GENERAL] attempting to install tds_fw-master on redhat

te: https://github.com/GeoffMontee/tds_fdw says 'This should support PostgreSQL 9.1+'. Yours, Laurenz Albe -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresq

Re: [GENERAL] attempting to install tds_fw-master on redhat

ke: *** No rule to make target `/usr/lib64/pgsql/pgxs/src/makefiles/pgxs.mk'.. Install the postgresql-devel package. Yours, Laurenz Albe -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] attempting to install tds_fw-master on redhat

ee/tds_fdw/issues/43 Yours, Laurenz Albe -- 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] attempting to install tds_fw-master on redhat

ommit from the tds_fdw repo and then try compiling again? I can confirm it works for me on 9.2.14. psql (9.2.14) Type "help" for help. postgres@postgres=# CREATE EXTENSION tds_fdw; CREATE EXTENSION Thanks, Geoff -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-

Re: [GENERAL] error connecting to the server: fatal :could not open file "base/12029/11801" permission denied

ave to ask whomever created the new policy. Any suggestions? -- 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] error connecting to the server: fatal :could not open file "base/12029/11801" permission denied

ssage- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Wednesday, November 11, 2015 2:40 PM To: Mammarelli, Joanne T; pgsql-general@postgresql.org Subject: Re: [GENERAL] error connecting to the server: fatal :could not open file "base/12029/11801" permission denied On 11/1

Re: [GENERAL] error connecting to the server: fatal :could not open file "base/12029/11801" permission denied

an be solved on the Postgres end, it needs to be done through the OS. -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Wednesday, November 11, 2015 2:40 PM To: Mammarelli, Joanne T; pgsql-general@postgresql.org Subject: Re: [GENERAL] error connecting to the s

Re: [GENERAL] Three Variations of postgresql.conf

es, if you are not using ALTER SYSTEM. What is the difference between these files and which is the correct one to change for modifying the configurations contained therein? -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Three Variations of postgresql.conf

ween these files and which is the correct one to change for modifying the configurations contained therein? -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgs

Re: [GENERAL] Three Variations of postgresql.conf

Thu, Nov 12, 2015 at 11:29 AM, Tom Lane mailto:t...@sss.pgh.pa.us>> wrote: Adrian Klaver mailto:adrian.kla...@aklaver.com>> writes: > On 11/12/2015 08:07 AM, Melvin Davidson wrote: >> In Ubuntu 14.10, there are three variations of the postgresql.conf >

Re: [GENERAL] get this warning from pgAdmin

wait till autovacuum hits the table. -- 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 sometimes returns no data

What is/are the job(s) doing? -- View this message in context: http://postgresql.nabble.com/postgres-sometimes-returns-no-data-tp5873720.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-gener

Re: [GENERAL] postgres sometimes returns no data

in context: http://postgresql.nabble.com/postgres-sometimes-returns-no-data-tp5873720p5873732.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

Re: [GENERAL] pg_restore tells schema “test” already exists but it isn't actually

I got this kind of error? -- 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]

: [archiver (db)] could not execute query: ERROR: permission denied for database icare Command was: CREATE SCHEMA icare; -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL]

up to 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] postgres sometimes returns no data

t: No connection could be made because the target machine actively refused it. 2015-11-10 01:01:44 EST LOG: unexpected EOF on client connection -- View this message in context: http://postgresql.nabble.com/postgres-sometimes-returns-no-data-tp5873720p5873824.html Sent from the PostgreSQ

Re: [GENERAL] postgres sometimes returns no data

lient. %r and %h are somewhat redundant with %r just adding the port to %h -- View this message in context: http://postgresql.nabble.com/postgres-sometimes-returns-no-data-tp5873720p5873831.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Adrian Klaver adria

Re: [GENERAL] postgres sometimes returns no data

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] 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] 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] 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] 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] 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] 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

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] 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] 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

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] 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] 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] 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] 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

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] 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

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] 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] 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] 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] 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] 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] 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] 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: ***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: 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: [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: [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] 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] 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

"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] 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: ***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] 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: [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] 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] 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] 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] 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] 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] 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] 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] 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] 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: --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] 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: [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] 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] 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] 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] 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] 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] 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] 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

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

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

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] 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] 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] 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] 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] 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] Broken after upgrade

#Upgrade -- 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] Broken after upgrade

On 07/06/2016 02:13 PM, arnaud gaboury wrote: On Wed, Jul 6, 2016 at 8:56 PM, John R Pierce wrote: On 7/6/2016 11:27 AM, Adrian Klaver wrote: First, if possible copy your data dir and conf files somewhere for safety. +1 !!! must be first step. It is the first thing I did From the

Re: [GENERAL] pasting a lot of commands to psql

mplifying the sql for multiple values in one statement? eg: INSERT INTO oko_topsites VALUES ('russian_federation','ati.su <http://ati.su>',0,NULL,5), ('russian_federation','audit-it.ru <http://audit-it.ru>&#x

Re: [GENERAL] Broken after upgrade

tgresql-9.4/bin/ -B /usr/bin -d /db/pgsql/data.old -D /db/pgsql/data Have no idea as I am confused as to your layout and what you have done, so: 1) Did you run the Fedora postgresql-setup upgrade command at any time? 2) What versions of Postgres do you have installed and/or running? Please v

Re: [GENERAL] Pgadmin access to Postgresql

ow replication connections from localhost, by a user with$ # replication privilege. #local replication postgres $ #host replication postgres 127.0.0.1/32 <http://127.0.0.1/32> $ -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.

Re: [GENERAL] Broken after upgrade

On 07/09/2016 08:59 AM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 5:08 PM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 4:16 PM, Adrian Klaver wrote: On 07/09/2016 03:09 AM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 11:54 AM, arnaud gaboury wrote: On Thu, Jul 7, 2016 at 10:01 AM

Re: [GENERAL] Broken after upgrade

On 07/09/2016 08:08 AM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 4:16 PM, Adrian Klaver wrote: On 07/09/2016 03:09 AM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 11:54 AM, arnaud gaboury wrote: On Thu, Jul 7, 2016 at 10:01 AM, arnaud gaboury wrote: On Thu, Jul 7, 2016 at 1:00 AM

Re: [GENERAL] Broken after upgrade

On 07/09/2016 11:06 AM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 7:31 PM, Adrian Klaver wrote: On 07/09/2016 08:08 AM, arnaud gaboury wrote: I understand you are confused, as I am too and tried too many things with no success. I have postgresql 9.5.3 installed, and the upgrade was

Re: [GENERAL] Broken after upgrade

On 07/09/2016 11:40 AM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 8:22 PM, Adrian Klaver wrote: On 07/09/2016 11:06 AM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 7:31 PM, Adrian Klaver wrote: On 07/09/2016 08:08 AM, arnaud gaboury wrote: I understand you are confused, as I am

Re: [GENERAL] Broken after upgrade

b/pgsql/data is of version 9.5 but it should be 9.4). -- Adrian Klaver adrian.kla...@aklaver.com -- Adrian Klaver adrian.kla...@aklaver.com -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

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