Joshua White wrote:
> > > > > > psql: FATAL: could not open file "base/618720/2610": No such file
> > > > > > or directory
> > >
> > > "pg_index" initially uses file 2610.
> > >
> > > Anyway, your database seems to be quite wrecked, and you'd probably need
> > > an expert to save what can be sa
>
> > > > 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. I
> > have full admin rights on this machine
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've got a
> PostgreSQL 10 server
> > > > instance
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. I
have full admin rights on this machine, so I can access logs, etc.
Recently I attempted to create a new
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've got a
> > > PostgreSQL 10 server
> > > instance on CentOS 6, which I set up and manage. I have full admin righ
Thanks for the tip. I've checked and the on-disk file behind "pg_index"
still exists.
I have existing databases in this cluster that I'd prefer not to drop and
recreate if possible.
I've tried dropping and recreating the new database I want to use, but each
time get the same type of error.
Kind
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:46, Joshua White wrote:
>
>>
Do you have adequate disk space left on your array?
cheers
Ben
On 15 October 2018 at 17: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. I
> have full admin rights o
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. I have full admin rights on
> this machine,
> so I can access logs, etc.
>
> Recently I attempted to create a new database in this cl
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
11 matches
Mail list logo
