Re: Help with restoring database from old version of PostgreSQL

2024-11-20 Thread Catherine Frock
19/24 14:13, Catherine Frock wrote: > > Do you know what versions of PG and pgAdmin4 I need? Also, I don't know > > where to get a different version of PG. > > > > You need to take a step back and take stock of where you started and > where you want to be. > >

Re: Help with restoring database from old version of PostgreSQL

2024-11-19 Thread Catherine Frock
gAdmin4 version. > > *Then* you need to: > CREATE USER basic_user WITH PASSWORD 'random_horse'; > > After that, you can run the "backup sql script". > > On Tue, Nov 19, 2024 at 4:47 PM Catherine Frock > wrote: > >> I am trying to restore a previously bac

Re: Help with restoring database from old version of PostgreSQL

2024-11-19 Thread Catherine Frock
t SET ALTER DEFAULT PRIVILEGES ERROR: role "basic_user" does not exist SET ALTER DEFAULT PRIVILEGES ERROR: role "basic_user" does not exist -- Arden On Thu, Nov 14, 2024 at 12:02 PM Adrian Klaver wrote: > On 11/14/24 07:00, Catherine Frock wrote: > > Yes,

Help with restoring database from old version of PostgreSQL

2024-11-13 Thread Catherine Frock
I'm seeking help in restoring a database that was created with PostgreSQL 9.6. I backed it up successfully and have restored it before, but that was when PostgreSQL 9.6 was still supported. After going through the installation of PostgreSQL 16.3, I opened up pgAdmin 4 to try to verify the PostgreSQ