Re: [GENERAL] REASSIGN OWNED simply doesn't work

2017-10-12 Thread Stephen Cook
On 2017-10-12 21:09, Sam Gendler wrote: > psql 9.6.3 on OS X. > > I'm dealing with a production database in which all db access has been > made by the same user - the db owner, which isn't actually a superuser > because the db runs on amazon RDS - amazon retains the superuser > privilege for its

[GENERAL] Restore LargeObjects on different server

2017-10-12 Thread Durumdara
Dear Members! Because of upload/download progress we used LargeObjects to store some files in one of our database (and not bytea). Only this database uses the OID-s of these files. In the near future we must move to another server. This new server is also working now, the moving of databases is

Re: [GENERAL] Restore LargeObjects on different server

2017-10-12 Thread Durumdara
Hi! Somebody wrote me that: The pg_catalog schema is system schema, but it is IN the DB. Is this true? So OID is not global (out from DB)? So we can dump and restore the DB with OIDs without collision in new server? Thank you! dd 2017-10-12 11:35 GMT+02:00 Durumdara :

Re: [GENERAL] Restore LargeObjects on different server

2017-10-12 Thread Laurenz Albe
Durumdara wrote: > > Because of upload/download progress we used LargeObjects to store some > > files in one of our database (and not bytea). > > Only this database uses the OID-s of these files. > > > > In the near future we must move to another server. > > This new server is also working now,

[GENERAL] Fwd: [BUGS] BUG #14850: Implement optinal additinal parameter for 'justify' date/time function

2017-10-12 Thread KES
Пересылаемое сообщение11.10.2017, 17:12, "Pavel Stehule" :Hi2017-10-11 12:35 GMT+02:00 :The following bug has been logged on the website: Bug reference:      14850 Logged by:          Eugen Konkov Email address:      kes-...@yandex.ru

Re: [GENERAL] core system is getting unresponsive because over 300 cpu load

2017-10-12 Thread Scott Marlowe
On Tue, Oct 10, 2017 at 4:28 PM, pinker wrote: > > Yes, it would be much easier if it would be just single query from the top, > but the most cpu is eaten by the system itself and I'm not sure why. You are experiencing a context switch storm. The OS is spending so much time

Re: [GENERAL] Fwd: [BUGS] BUG #14850: Implement optinal additinal parameter for 'justify' date/time function

2017-10-12 Thread Brian Dunavant
A 'month' is an abstract measurement of time. Sometimes it's 29 days, 30, or 31. You cannot say "I have 30 days, how many months is that?" because the answer is "it depends". - gives you an interval in days. In your example, you took Jan 31 2016 and added "1 month". Postgres says "I know

[GENERAL] EAV Designs for Multi-Tenant Applications

2017-10-12 Thread Nic Pottier
Howdy all, We maintain a hosted multi-tenant system for a large number of users. Each user has what we call an "organization" or "org" which is their sandbox. In that organization they can manage contacts and define custom fields on those contacts, which then have values per contact. We have

[GENERAL] Index corruption & broken clog

2017-10-12 Thread Benoit Lobréau
Hi, One of my PostgreSQL server crashed badly yesterday. A process was killed (see dmesg below) and postgres was stuck with theses process: postgres 2083 1 0 Oct08 ?00:19:02 /usr/lib/postgresql/9.5/bin/postgres -D /home/postgres/data/i090/systeme postgres 2221 2083 0 Oct08 ?

[GENERAL] REASSIGN OWNED simply doesn't work

2017-10-12 Thread Sam Gendler
psql 9.6.3 on OS X. I'm dealing with a production database in which all db access has been made by the same user - the db owner, which isn't actually a superuser because the db runs on amazon RDS - amazon retains the superuser privilege for its own users and makes non-superuser role with