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
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
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 :
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,
Пересылаемое сообщение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
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
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
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
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 ?
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
10 matches
Mail list logo