On Thu, 20 Dec 2018 at 14:35, Pavel Stehule wrote:
> čt 20. 12. 2018 v 2:41 odesílatel Ron napsal:
>
>> On 12/19/18 7:27 PM, Michael Paquier wrote:
>> [snip]
>> > Each backend stores its own copy of the relation cache, so if you have
>> > idle connections which have been used for other work in t
>
> In my application, the idle sessions are consuming cpu and ram. refer the
> ps command output.
>
If you connect to the database, does select * from pg_stat_activity() show
a lot of idle connections?
>
> > > > Recently I attempted to create a new database in this cluster. The
>> command succeeds,
>> > > > but when I try to connect to the new database, I get a "could not
>> open file" error:
>> > > >
>> > > > psql: FATAL: could not open file "base/618720/2610": No such file
>> or directory
>> >
On Tue, 16 Oct 2018 at 19:13, Colin Coles
wrote:
> On 15/10/2018 10:46, Joshua White wrote:
> > Hi all,
> >
> > I'm hoping someone can point me in the right direction. I've got a
> > PostgreSQL 10 server instance on CentOS 6, which I set up and manage.
On Tue, 16 Oct 2018 at 18:58, Laurenz Albe wrote:
> Please don't top post.
>
> Joshua White wrote:
> > On Mon, 15 Oct 2018 at 21:13, Laurenz Albe
> wrote:
> > > Joshua White wrote:
> > > > I'm hoping someone can point me in the right direction. I
same type of error.
Kind Regards,
Joshua White
On Mon, 15 Oct 2018 at 21:13, Laurenz Albe wrote:
> Joshua White wrote:
> > I'm hoping someone can point me in the right direction. I've got a
> PostgreSQL 10 server
> > instance on CentOS 6, which I set up and manage.
Thanks for the suggestion - plenty of disk space left (several hundred
gigabytes free).
Kind Regards,
Joshua White
On Tue, 16 Oct 2018 at 15:03, Ben Madin wrote:
> Do you have adequate disk space left on your array?
>
> cheers
>
> Ben
>
>
> On 15 October 2018 at 17
Hi all,
I'm hoping someone can point me in the right direction. I've got a
PostgreSQL 10 server instance on CentOS 6, which I set up and manage. I
have full admin rights on this machine, so I can access logs, etc.
Recently I attempted to create a new database in this cluster. The command
succeeds
