Re: [GENERAL] pg_dump and quoted identifiers

tried the answer from the SO question?: "\"Statuses\"" Bash version is "GNU bash, version 4.1.2(1)-release (x86_64-redhat-linux-gnu)" -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To mak

Re: [GENERAL] Install doesnt set SuperUser PW

line image 1 On Tue, Dec 13, 2016 at 5:35 PM, Adrian Klaver <adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>> wrote: On 12/13/2016 02:08 PM, Jovi Federici wrote: Just re-ran installer in Administrator mode with no difference.

Re: [GENERAL] Install doesnt set SuperUser PW

On Tue, Dec 13, 2016 at 5:35 PM, Adrian Klaver <adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>> wrote: On 12/13/2016 02:08 PM, Jovi Federici wrote: Just re-ran installer in Administrator mode with no difference. Correction on previous statement: the in

Re: [GENERAL] Install doesnt set SuperUser PW

a postgres OS user? Can you connect to the server in any manner? -Jovi -- 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] Install doesnt set SuperUser PW

against. My suggestion would be to try here: http://forums.enterprisedb.com/forums/show/9.page;jsessionid=49D70EC0A476B22D3C6FEF3A24F0BA90 Or if you are willing to try something different: https://www.bigsql.org/postgresql/installers.jsp -Jovi -- Adrian Klaver adrian.kla...@aklaver.com

Re: [GENERAL] Install doesnt set SuperUser PW

lecting Run as Administrator from the context menu." BTW, I had installed same previously then ran the uninstall.exe and re-installed because I forgot if I had entered a PW the first time but I really don't think I ever did. Thanks for you help! Jovi -- Adrian Klaver adrian.kla...@aklaver.c

Re: [GENERAL] CRM where pg is a first class citizen?

of a beast. JD -- john r pierce, recycling bits in santa cruz -- 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] Install doesnt set SuperUser PW

the password. Thanks! -- Jovi -- 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] btree gist indices, null and open-ended tsranges

etypes.html: > > CREATE EXTENSION btree_gist; > CREATE TABLE room_reservation ( > room text, > during tsrange, > EXCLUDE USING GIST (room WITH =, during WITH &&) > ); > > Next question: if lots of rows have open-ended periods > (eg: [, 2010-01-0

Re: [GENERAL] Importing SQLite database

-- 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) To make

Re: [GENERAL] huge table occupation after updates

rg/docs/9.5/static/mvcc.html There is a lot of ground covered in the above, more then can be digested in one pass but it will help provide some context for the answers/suggestions provided in this thread. Thank you very much Pupillo -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pg

Re: [GENERAL] huge table occupation after updates

iginal and insert the temp table in the original, although I fear this will lock the table too, but it will be a very short time, your readers may well tolerate it. ) Yours seem a special app with special need, try a few, measure, it is certainly possible. Francisco Olarte. -- Adrian Klaver adri

Re: [GENERAL] SELECT slow immediately after many update or delete+insert, except using WHERE .. IN

COUNT(*) FROM Table WHERE id > 0; Regards Pupillo 2016-12-09 17:16 GMT+01:00 Adrian Klaver <adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>>: On 12/09/2016 08:03 AM, Tom DalPozzo wrote: > Hi, > I did two tests: > TEST 1 > 1 I created

Re: [GENERAL] Windows installation - could not connect to server: Connection refused (0x0000274D/10061)

tions do run on Windows 7 Pro x64. Best regards, Thomas Deboben -- 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] SELECT slow immediately after many update or delete+insert, except using WHERE .. IN

est and why it is faster when using WHERE..IN . > > Also, should I be concerned about the delay at point 5? I mean, my DB > will receive around 20 millions of updates (or delete+insert) per day. > Will this delay raise more and more along the months/years? > > > Regards &

Re: [GENERAL] Unexplained statistics reset? Help tracking it down.

stics counters are reset." a bug? I have no clue how to reproduce it, as the occurrance is rare and still seems random. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.post

Re: [GENERAL] Importing SQLite database

s closer to the SQL spec. If you prefer autocommit-off, you might wish to set it in the system-wide psqlrc file or your ~/.psqlrc file. " Thank you. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

Re: [GENERAL] Looking for an online mentor

determined as much by what makes sense to you as anything else. -- 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] Looking for an online mentor

g Postgres all is good. -- 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] Looking for an online mentor

load data from other sources, etc. -- 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] Looking for an online mentor

e of money and time. lol, I wish I'd had these project ideas then, I could have gone to the teacher with them. Meta On Thu, Dec 8, 2016 at 6:59 PM, Adrian Klaver <adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>> wrote: On 12/08/2016 03:46 PM, Metare Solve wrote:

Re: [GENERAL] Looking for an online mentor

t/ Though pgAdmin is often discussed on this list(pgsql-general). Any input, even on the project? What language(s) do you plan to program in? What studying on SQL have you done? What will the purpose of the project? thanks, meta -- Adrian Klaver adrian.kla...@aklaver.com -- Sent

Re: [GENERAL] PDF files: to store in database or not

the bytea data type before I'll read how to work with it. http://initd.org/psycopg/docs/usage.html?highlight=binary#adapt-binary Thanks very much for your insights, Rich -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Importing SQLite database

ill-formed SQL statements will run correctly. Future versions of SQLite might raise errors instead of accepting the malformed statements covered by the exceptions above." Thank you. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresq

Re: [GENERAL] Importing SQLite database

On 12/08/2016 06:54 AM, Igor Korot wrote: Adrian, On Thu, Dec 8, 2016 at 9:47 AM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: On 12/08/2016 04:54 AM, Igor Korot wrote: Hi, ALL, I have a text file which I got from exporting the SQLite database. The file contains an SQL statement

Re: [GENERAL] Importing SQLite 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] Problems Importing table to pgadmin

remember correctly, has a setting that limits the maximum number of rows that it will fetch at a time. -- 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

Re: [GENERAL] Problems Importing table to pgadmin

y thoughts? Also, what is the query you are executing? -- 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] Problems Importing table to pgadmin

at happens. -- View this message in context: http://postgresql.nabble.com/Problems-Importing-table-to-pgadmin-tp5933807p5933826.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing l

Re: [GENERAL] Problems Importing table to pgadmin

/Problems-Importing-table-to-pgadmin-tp5933807p5933818.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

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

and contains this line: \pset pager off So what does: env | grep PAGER show? -- 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 and LibreOffice's 'Base'

On 12/04/2016 12:01 PM, Rich Shepard wrote: On Sun, 4 Dec 2016, Adrian Klaver wrote: The important questions that forgot to ask before, is how do you plan to deploy this: Or are you looking to deploy a front end/database combination to each client? This way. I've no interest

Re: [GENERAL] Postgres and LibreOffice's 'Base'

On 12/04/2016 09:59 AM, Rich Shepard wrote: On Sun, 4 Dec 2016, Adrian Klaver wrote: That is why I ended up learning Django, I could not find a GUI that was cross platform and had the capabilities I needed. Others might have suggestions. It would help though if you could list what you want

Re: [GENERAL] Postgres and LibreOffice's 'Base'

On 12/04/2016 08:47 AM, Rich Shepard wrote: On Sun, 4 Dec 2016, Adrian Klaver wrote: Base is basically a GUI over the database. Adrian, That's what I assumed it to be. That being said my experience with Base is that is not up to the task. It worked for me early on, but development

Re: [GENERAL] Postgres and LibreOffice's 'Base'

on, but development on Base lagged relative to the other modules in LO. My recent attempts have been less successful. Exact examples on why, will have to wait on me dredging up the memories. All tips and gotcha's for a new user are certainly welcome. TIA, Rich -- Adrian Klaver adrian.kla

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

ination of libraries. If it where me I would get rid of the instance that you built from source, assuming that there is nothing important on it. -- 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] Select works only when connected from login postgres

and see if it's resolving the libpq dependency to the copy you intended. regards, tom lane -- 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] No select privileges when not connecting from login postgres

Postgres and all I can suggest for starters is to physically remove it and re-install from the Debian packages. HTH, 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] Select works only when connected from login postgres

n_US.UTF-8 | ... Did you receive the previous 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] No select privileges when not connecting from login postgres

? -- 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] INSERT - UPDATE throughput oscillating and SSD activity after stopping the client

normal. I'd like to be sure that my data are safe once commited. Regards Pupillo P.S.: I put this question in general questions as my concern is not if the performance is high or not. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Using UPDATE ... RETURNING in a custom SQL function, which RETURNS integer

ed to any output variable name but just returned as an integer. In the plpgsql case you actually assign uid to an output variable name. FYI, you can have OUT in SQL functions also: https://www.postgresql.org/docs/9.5/static/xfunc-sql.html#XFUNC-OUTPUT-PARAMETERS Regards Alex -- Adrian Kl

Re: [GENERAL] PostgreSQL ODBC driver for OSX 10.8

have dev packages installed on your machine? The immediate problem being: configure: error: libpq library version >= 9.2 is required So what do have on on the machine in the way of Postgres now? 3) How did you get Postgres on the machine? -- Adrian Klaver adrian.kla...@aklaver.com -- Sent

Re: [GENERAL] PostgreSQL ODBC driver for OSX 10.8

On 12/01/2016 08:41 AM, Igor Korot wrote: Adrian, On Thu, Dec 1, 2016 at 11:37 AM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: On 12/01/2016 08:01 AM, Igor Korot wrote: Hi, ALL, This is my first post here. I have actually 2 questions which are kind of related. 1. Is there

Re: [GENERAL] PostgreSQL ODBC driver for OSX 10.8

On 12/01/2016 08:41 AM, Igor Korot wrote: Adrian, On Thu, Dec 1, 2016 at 11:37 AM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: On 12/01/2016 08:01 AM, Igor Korot wrote: Hi, ALL, This is my first post here. I have actually 2 questions which are kind of related. 1. Is there

Re: [GENERAL] PostgreSQL ODBC driver for OSX 10.8

://odbc.postgresql.org/docs/unix-compilation.html 2. Is PostgreSQL ODBC driver works with iODBC? See above. 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

Re: [GENERAL] How to migrate from PGSQL 9.3 to 9.6

of partial upgrade, do I need to worry about trying to get a correct version of the setup script with upgrade handling? (Other than whatever I need for the answer above.) Thanks -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] Index size

of Postgres? Also how are you measuring the size of the data set? Have you looked at/tried the functions here?: https://www.postgresql.org/docs/9.5/static/functions-admin.html#FUNCTIONS-ADMIN-DBOBJECT -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] Index size

entire row on disk? Or is there some kind of id lookup involved? Thanks. -- 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] Storing files: 2.3TBytes, 17M file count

On 11/29/2016 01:15 AM, Thomas Güttler wrote: Am 28.11.2016 um 16:01 schrieb Adrian Klaver: On 11/28/2016 06:28 AM, Thomas Güttler wrote: Hi, PostgreSQL is rock solid and one of the most reliable parts of our toolchain. Thank you Up to now, we don't store files in PostgreSQL. I

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

like s3. AFAIK there are open source s3 implementations available. Just be aware that doing deltas over file changes, like rsync, while possible is more convoluted and time/resource consuming with something like s3. Thank you all for your feeback! Regards, Thomas -- Adrian Klaver

Re: [GENERAL] pg_dump system catalog

catalogs.html pg_catalog itself is generated with the initdb command when a new postgresql cluster is generated. https://www.postgresql.org/docs/9.6/static/creating-cluster.html https://www.postgresql.org/docs/9.6/static/app-initdb.html* -- *Melvin Davidson* I reserve the right to fantasize. Whethe

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

/ -- 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 system catalog

the parameter --schema?) No. Use Achilleas's command and see what happens. Regards, Juliano -- 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_ctl restart' does not terminate

e the rest of the logging goes to whatever you set up in postgresql.conf, assuming it was set up. Otherwise it will go to the stdout of the terminal. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscrip

Re: [GENERAL] 'pg_ctl restart' does not terminate

own. done server stopped server starting postgres@panda:~> -2016-11-26 11:16:40.737 PST-0 LOG: redirecting log output to logging collector process -2016-11-26 11:16:40.737 PST-0 HINT: Future log output will appear in directory "pg_log". If you hit Enter you get: postgres@pan

Re: [GENERAL] 'pg_ctl restart' does not terminate

On 11/26/2016 07:47 AM, twoflower wrote: > Adrian Klaver-4 wrote >> You also specify a log file to pg_ctl by using -l: >> >> https://www.postgresql.org/docs/9.5/static/app-pg-ctl.html > > This did the trick, thank you! Great. Still I would suggest usin

Re: [GENERAL] 'pg_ctl restart' does not terminate

You also specify a log file to pg_ctl by using -l: https://www.postgresql.org/docs/9.5/static/app-pg-ctl.html -- 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/mail

Re: [GENERAL] PostgreDB stores table name is lower case

ws what happens when you quote, you are committed to that case. If you still want to do this then: test[5432]=# ALTER table fold_lowercase rename to "MAKE_UPPERCASE"; ALTER TABLE test[5432]=# \d "MAKE_UPPERCASE" Table "public.MAKE_UPPERCASE" Column | Type | Modifiers

Re: [GENERAL] pg_am access in simple transaction?

On 11/25/2016 07:04 AM, pinker wrote: Adrian Klaver-4 wrote I can not replicate using 50 clients instead of 2000. I suspect either has to do with the extreme number of clients or it is an artifact of from some other process. And I have replicated it with 50 clients as well... lsof output: 51

Re: [GENERAL] query locks up when run concurrently

On 11/24/2016 02:14 PM, azhwkd wrote: Adrian Klaver <adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>> schrieb am Do., 24. Nov. 2016 um 22:34 Uhr: On 11/24/2016 01:23 PM, azhwkd wrote: > It should not be possible because a group does not return to the

Re: [GENERAL] pg_am access in simple transaction?

ling 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] query locks up when run concurrently

up? heap_hot_search_buffer using ~20 of all CPU time on the system. 2016-11-24 19:14 GMT+01:00 Adrian Klaver <adrian.kla...@aklaver.com>: On 11/23/2016 10:41 PM, azhwkd wrote: The group ID is part of the primary key of the group_history table. My understanding is that two I

Re: [SPAM] Re: [SPAM] Re: [GENERAL] Best practices to manage custom statistics

g message (but I had to explain such a complex thing) Moreno.- -- 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] query locks up when run concurrently

int8 NOT NULL, ab int8 NOT NULL, bb int8 NOT NULL, ba int8 NOT NULL, quantity int8 NOT NULL, "hour" int2 NOT NULL, CONSTRAINT group_history_pk PRIMARY KEY (group,id,sub_category,"date","hour") ) WITH ( OIDS=FALSE ); Kind regards, Sebastian -- Adrian Klaver adrian.kla.

Re: [GENERAL] query locks up when run concurrently

RIMARY KEY (group,id,sub_category,"date","hour") ) WITH ( OIDS=FALSE ); Me slaps head Windy night last night + lack of sleep + insufficient caffeine = Not seeing the table definition before hitting Send on previous post. Kind regards, Sebastian 2016-11-24 0:28 GMT+01:00 Adrian Klave

Re: [GENERAL] query locks up when run concurrently

p,id,sub_category,"date","hour") ) WITH ( OIDS=FALSE ); Kind regards, Sebastian -- 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] query locks up when run concurrently

as group_history just a different name). The trigger on the group_history table is exactly the same though, except for the table name. Kind regards, Sebastian -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] Extension compatibility between postgresql minor version

server which is the opposite of everything you said previously, in particular the prior sentence. On 2016-11-24, 11:55 AM, "Adrian Klaver" <adrian.kla...@aklaver.com> wrote: On 11/24/2016 07:40 AM, David Richer wrote: > Hi guys, > > > > I wan

Re: [GENERAL] Extension compatibility between postgresql minor version

meant to say? Thanks, Davud -- 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] query locks up when run concurrently

same row in the group_history partition tables. Or are you certain that they should be hitting different rows? regards, tom lane -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] query locks up when run concurrently

, is that correct? If so how does the item_history table fit into this? Kind regards, Sebastian -- 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: [SPAM] Re: [GENERAL] Best practices to manage custom statistics

On 11/23/2016 05:24 AM, Moreno Andreo wrote: Il 15/11/2016 18:19, Adrian Klaver ha scritto: On 11/15/2016 07:39 AM, Moreno Andreo wrote: Sorry for late reply... i'm in some quite rough days Il 08/11/2016 21:28, Adrian Klaver ha scritto: On 11/08/2016 12:13 PM, Moreno Andreo wrote

Re: [GENERAL] query locks up when run concurrently

e given date _new_date := date_trunc('day', new."when"); _startdate := to_char(_new_date, '_MM_DD'); _tablename := 'group_history_'||_startdate; -- Insert the current record into the correct partition execute 'INSERT INTO public.' || quote_ident(_tablename) || ' VALUES ($1.*) on confli

Re: [GENERAL] min/max_wal_size

here anything that I am not aware of? Are you talking about the recycled files? Thanks, Torsten -- 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] Database migration to RDS issues permissions

was: CREATE USER MAPPING FOR user SERVER pg_rest OPTIONS (/ /password 'X',/ /"user" 'user'/ /);/ This is probably because you could not import the global roles from your original database. Regards. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general m

Re: [GENERAL] Partial update on an postgres upsert violates constraint

upsert cte You might be able to modify the examples to get what you want. On Sun, Nov 20, 2016 at 3:57 AM, Tom Lane <t...@sss.pgh.pa.us <mailto:t...@sss.pgh.pa.us>> wrote: Adrian Klaver <adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>> writes:

Re: [GENERAL] Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used

you are talking about. Assuming 'ECPG - Embedded SQL in C' for now: https://www.postgresql.org/docs/9.5/static/ecpg-variables.html Thanks. Poul BTW: I have not received my ordered book yet! There is one online:): https://www.postgresql.org/docs/9.5/static/index.html -- Adrian

Re: [GENERAL] How to introspect autovacuum analyze settings

explicitly. -- 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: R: [GENERAL] Autovacuum and frequent pg_bulkload

space, but tablea became locked. VACUUM full returns space to the OS if that is what you mean? Thank you Francesco -- 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] Autovacuum and frequent pg_bulkload

g new data? Thank you, /F -- 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] Database migration to RDS issues permissions

on-rds and that was only after finding a database that did not have plpythonu installed as that is uninstallable. So I ended up with: pg_restore -C -d test -h testdb.xxx.rds.amazonaws.com -p 5432 -U rds_user --no-owner --no-privileges b_app.out I think I will stick with my policy of not usi

Re: [GENERAL] Database migration to RDS issues permissions

//docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts Using the rds_superuser Role Seems to be you need to use the above role to do your restore. -- 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] Partial update on an postgres upsert violates constraint

EXT ) ON CONFLICT (id) DO UPDATE SET employee_name = COALESCE(EXCLUDED.employee_name, origin.employee_name), address = COALESCE(EXCLUDED.address, origin.address), phone_number = COALESCE(EXCLUDED.phone_number, origin.phone_number); END; $function$ ; makes it work. So looks like cons

Re: [GENERAL] Database migration to RDS issues permissions

com/AmazonRDS/latest/UserGuide/PostgreSQL.Procedural.Importing.html I also saw the first errors and they are weird. Indications that you are not running the restore as a user with sufficient privileges. Is the database you are dumping from an RDS instance or a regular Postgres database

Re: [GENERAL] Database migration to RDS issues permissions

to create schemas in the database. It does not allow creating of objects within the schema. For more details see: https://www.postgresql.org/docs/9.5/static/sql-grant.html -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] Partial update on an postgres upsert violates constraint

--DETAIL: Failing row contains (1, null, null, 12345).| I also tried explicitly stating the columns that I wanted to insert, and it also fails. How do I go around doing this ? AFAIK, EXCLUDED is only available in a trigger function: https://www.postgresql.org/docs/9.5/static/trigger-definition.html You

Re: [GENERAL] Database migration to RDS issues permissions

-f log_file.log backup.db.dump While restoring is working it prints a lot of permissions errors. The permissions errors are ? A sampling will suffice for now. It's being hard to find "how to" and documentations about right permissions. Regards. -- Adrian Klaver adrian.kla..

Re: [GENERAL] pg_class (system) table increasing size.

is bigger (5 GB) to maintain. does it requires maintenance as well for thepg_class. Should have added to my previous post. What does: select * from pg_stat_sys_tables where relname = 'pg_class'; show? It seems its affecting performance. -- Adrian Klaver adrian.kla...@aklaver.com

Re: [GENERAL] pg_class (system) table increasing size.

specific) objects. Does it affect the performance. It can - depends greatly on scale. Note, frequent usage of temporary tables is a common cause for this kind of behavior. David J. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postg

Re: [GENERAL] Streaming replication failover/failback

) 450-7293 --- -- 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] Syncing Data of data type BLOB into Postgres- Bytea

you want in there, which actually is true of any SQLite 'type'. So the OP is going from inserting into something(SQLite) that does no input validation to one(Postgres) that does. John DeSoi, Ph.D. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-gene

Re: [GENERAL] Upgrade from 9.5.4 to 9.6.1

On 11/15/2016 05:18 PM, Rich Shepard wrote: On Tue, 15 Nov 2016, Adrian Klaver wrote: Rich is using Slackware and I am pretty sure it marches to a different drummer. Adrian, And a different band. Pat likes MariaDB which replaced MySQL so PostgreSQL is not part of the base distribution

Re: [GENERAL] Upgrade from 9.5.4 to 9.6.1

On 11/15/2016 05:18 PM, Rich Shepard wrote: On Tue, 15 Nov 2016, Adrian Klaver wrote: Rich is using Slackware and I am pretty sure it marches to a different drummer. Adrian, And a different band. Pat likes MariaDB which replaced MySQL so PostgreSQL is not part of the base distribution

Re: [GENERAL] Upgrade from 9.5.4 to 9.6.1

On 11/15/2016 05:06 PM, Rich Shepard wrote: On Tue, 15 Nov 2016, Adrian Klaver wrote: Assuming the bindirs are in your $PATH: aklaver@panda:~> whereis -f pg_ctl Adrian, In my case: $ whereis -f pg_ctl pg_ctl: /bin/pg_ctl /usr/bin/pg_ctl /usr/X11R6/bin/pg_ctl /usr/bin/X11/pg_ctl /usr/

Re: [GENERAL] Upgrade from 9.5.4 to 9.6.1

On 11/15/2016 05:01 PM, John R Pierce wrote: On 11/15/2016 4:55 PM, Adrian Klaver wrote: where do I look for the two bindirs? Assuming the bindirs are in your $PATH: aklaver@panda:~> whereis -f pg_ctl pg_ctl: /usr/local/pgsql/bin/pg_ctl /usr/local/pgsql94/bin/pg_ctl Even if only

Re: [GENERAL] dumping table contents in a sensible order

way of a parent_id field. How can I either: - dump the table in an insertable order? Don't use --inserts, instead let the data be entered via COPY(the default) which does it a single transaction. - have the load only apply the foreign key constraint at the end of each table import? See

Re: [GENERAL] Upgrade from 9.5.4 to 9.6.1

ou can usually figure out where the other is. TIA, Rich -- 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] Best practices to manage custom statistics

On 11/15/2016 07:39 AM, Moreno Andreo wrote: Sorry for late reply... i'm in some quite rough days Il 08/11/2016 21:28, Adrian Klaver ha scritto: On 11/08/2016 12:13 PM, Moreno Andreo wrote: [...] In your experience, would this approach help me lower server load? Are there any other

Re: [GENERAL] pg_restore --clean failing due to dependancies

trim down a pg_dump -s to see how I can reproduce this. -- Arnaud -- 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

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