public inbox for [email protected]
help / color / mirror / Atom feedRe: Help with restoring database from old version of PostgreSQL
11+ messages / 4 participants
[nested] [flat]
* Re: Help with restoring database from old version of PostgreSQL
@ 2024-11-13 20:42 Adrian Klaver <[email protected]>
2024-11-14 15:00 ` Re: Help with restoring database from old version of PostgreSQL Catherine Frock <[email protected]>
0 siblings, 1 reply; 11+ messages in thread
From: Adrian Klaver @ 2024-11-13 20:42 UTC (permalink / raw)
To: Catherine Frock <[email protected]>; [email protected]
On 11/13/24 10:50, Catherine Frock wrote:
> 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
Do you still have the Postgres 9.6 instance running?
> through the installation of PostgreSQL 16.3, I opened up pgAdmin 4 to
What version of pgAdmin4?
> try to verify the PostgreSQL/PostGIS installation, but when I try to
> connect to the PostgreSQL 16.3 server, I get an internal server error
> message: 'ServerManager' object has no attribute 'user_info'.
>
> In pgAdmin4, I am able to connect to the PostgreSQL 9.6 server, but when
So the 9.6 instance is running.
> I try to verify the install by querying: CREATE EXTENSION postgis;
> SELECT postgis_version();
> I get the following error message: ERROR: could not open extension
> control file "C:/Program
> Files/PostgreSQL/9.6/share/extension/postgis.control": No such file or
> directory SQL state: 58P01
What OS and version are you running?
How did you install Postgres?
>
> How can I restore my database to have access to it again?
>
> Thanks.
--
Adrian Klaver
[email protected]
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Help with restoring database from old version of PostgreSQL
2024-11-13 20:42 Re: Help with restoring database from old version of PostgreSQL Adrian Klaver <[email protected]>
@ 2024-11-14 15:00 ` Catherine Frock <[email protected]>
2024-11-14 15:38 ` Re: Help with restoring database from old version of PostgreSQL Ron Johnson <[email protected]>
2024-11-14 17:02 ` Re: Help with restoring database from old version of PostgreSQL Adrian Klaver <[email protected]>
0 siblings, 2 replies; 11+ messages in thread
From: Catherine Frock @ 2024-11-14 15:00 UTC (permalink / raw)
To: Adrian Klaver <[email protected]>; [email protected]; +Cc: [email protected]
Yes, I still have the backup file. I tried to open pgAdmin4 today to see
what version I'm running, and now this happened (see attachments). My
operating system is Windows 10 Home, version 10.0.19045 Build 19045. I
installed Postgres using these instructions:
https://basille.org/postgis2017/installation_instructions/install_postgresql.html
I'm
guessing at this point I probably need to start all over with the
installation since pgAdmin4 is not working? But if 9.6 is no longer
supported, can I still use it to access my database? I assumed I would need
to migrate to the most recent version of PostgreSQL, but maybe that was a
wrong assumption?
Thank you for your help,
--
Arden
On Wed, Nov 13, 2024 at 3:42 PM Adrian Klaver <[email protected]>
wrote:
> On 11/13/24 10:50, Catherine Frock wrote:
> > 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
>
> Do you still have the Postgres 9.6 instance running?
>
> > through the installation of PostgreSQL 16.3, I opened up pgAdmin 4 to
>
> What version of pgAdmin4?
>
> > try to verify the PostgreSQL/PostGIS installation, but when I try to
> > connect to the PostgreSQL 16.3 server, I get an internal server error
> > message: 'ServerManager' object has no attribute 'user_info'.
> >
> > In pgAdmin4, I am able to connect to the PostgreSQL 9.6 server, but when
>
> So the 9.6 instance is running.
>
> > I try to verify the install by querying: CREATE EXTENSION postgis;
> > SELECT postgis_version();
> > I get the following error message: ERROR: could not open extension
> > control file "C:/Program
> > Files/PostgreSQL/9.6/share/extension/postgis.control": No such file or
> > directory SQL state: 58P01
>
> What OS and version are you running?
>
> How did you install Postgres?
>
>
> >
> > How can I restore my database to have access to it again?
> >
> > Thanks.
>
> --
> Adrian Klaver
> [email protected]
>
>
Attachments:
[image/jpeg] Database 5.jpg (232.3K, 3-Database%205.jpg)
download | view image
[image/jpeg] Database 3.jpg (362.5K, 4-Database%203.jpg)
download | view image
[image/jpeg] Database 1.jpg (391.8K, 5-Database%201.jpg)
download | view image
[image/jpeg] Database 4.jpg (323.9K, 6-Database%204.jpg)
download | view image
[image/jpeg] Database 2.jpg (340.0K, 7-Database%202.jpg)
download | view image
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Help with restoring database from old version of PostgreSQL
2024-11-13 20:42 Re: Help with restoring database from old version of PostgreSQL Adrian Klaver <[email protected]>
2024-11-14 15:00 ` Re: Help with restoring database from old version of PostgreSQL Catherine Frock <[email protected]>
@ 2024-11-14 15:38 ` Ron Johnson <[email protected]>
1 sibling, 0 replies; 11+ messages in thread
From: Ron Johnson @ 2024-11-14 15:38 UTC (permalink / raw)
To: Catherine Frock <[email protected]>; +Cc: Adrian Klaver <[email protected]>; [email protected]
1. PG16 will read a PG 9.6 backup file, so there's no need to install PG
9.6.
2. Installing PG on a OneDrive share is certainly a Very Bad Idea.
3. PG is not the same as PgAdmin.
On Thu, Nov 14, 2024 at 10:00 AM Catherine Frock <[email protected]> wrote:
> Yes, I still have the backup file. I tried to open pgAdmin4 today to see
> what version I'm running, and now this happened (see attachments). My
> operating system is Windows 10 Home, version 10.0.19045 Build 19045. I
> installed Postgres using these instructions:
> https://basille.org/postgis2017/installation_instructions/install_postgresql.html I'm
> guessing at this point I probably need to start all over with the
> installation since pgAdmin4 is not working? But if 9.6 is no longer
> supported, can I still use it to access my database? I assumed I would need
> to migrate to the most recent version of PostgreSQL, but maybe that was a
> wrong assumption?
>
> Thank you for your help,
> --
> Arden
>
>
> On Wed, Nov 13, 2024 at 3:42 PM Adrian Klaver <[email protected]>
> wrote:
>
>> On 11/13/24 10:50, Catherine Frock wrote:
>> > 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
>>
>> Do you still have the Postgres 9.6 instance running?
>>
>> > through the installation of PostgreSQL 16.3, I opened up pgAdmin 4 to
>>
>> What version of pgAdmin4?
>>
>> > try to verify the PostgreSQL/PostGIS installation, but when I try to
>> > connect to the PostgreSQL 16.3 server, I get an internal server error
>> > message: 'ServerManager' object has no attribute 'user_info'.
>> >
>> > In pgAdmin4, I am able to connect to the PostgreSQL 9.6 server, but
>> when
>>
>> So the 9.6 instance is running.
>>
>> > I try to verify the install by querying: CREATE EXTENSION postgis;
>> > SELECT postgis_version();
>> > I get the following error message: ERROR: could not open extension
>> > control file "C:/Program
>> > Files/PostgreSQL/9.6/share/extension/postgis.control": No such file or
>> > directory SQL state: 58P01
>>
>> What OS and version are you running?
>>
>> How did you install Postgres?
>>
>>
>> >
>> > How can I restore my database to have access to it again?
>> >
>> > Thanks.
>>
>> --
>> Adrian Klaver
>> [email protected]
>>
>>
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Help with restoring database from old version of PostgreSQL
2024-11-13 20:42 Re: Help with restoring database from old version of PostgreSQL Adrian Klaver <[email protected]>
2024-11-14 15:00 ` Re: Help with restoring database from old version of PostgreSQL Catherine Frock <[email protected]>
@ 2024-11-14 17:02 ` Adrian Klaver <[email protected]>
2024-11-19 21:47 ` Re: Help with restoring database from old version of PostgreSQL Catherine Frock <[email protected]>
1 sibling, 1 reply; 11+ messages in thread
From: Adrian Klaver @ 2024-11-14 17:02 UTC (permalink / raw)
To: Catherine Frock <[email protected]>; [email protected]; +Cc: [email protected]
On 11/14/24 07:00, Catherine Frock wrote:
> Yes, I still have the backup file. I tried to open pgAdmin4 today to see
> what version I'm running, and now this happened (see attachments). My
> operating system is Windows 10 Home, version 10.0.19045 Build 19045. I
> installed Postgres using these instructions:
> https://basille.org/postgis2017/installation_instructions/install_postgresql.html <https://basille.org/postgis2017/installation_instructions/install_postgresql.html> I'm guessing at this point I probably need to start all over with the installation since pgAdmin4 is not working? But if 9.6 is no longer supported, can I still use it to access my database? I assumed I would need to migrate to the most recent version of PostgreSQL, but maybe that was a wrong assumption?
1) You can copy/paste the error message and provide as text.
2) Assuming you are installing Postgres 16 from the EDB package, the
from here:
https://www.postgresql.org/download/windows/
PostgreSQL Version 64 Bit Windows Platforms
16 2022, 2019
[...]
11 2019, 2016, 2012 R2
10 2016, 2012 R2 & R1, 7, 8, 10
3) From here:
https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
9.6 can still be downloaded.
It is not a supported version, but you can at least use it to access
your database.
4) You need to provide a more detailed explanation of what you are
trying to achieve.
5) 9.6 -> 16 is six major version jump. That means some research needs
to be done, starting with determining what version of PostGIS you need
to be using.
>
> Thank you for your help,
> --
> Arden
>
>
> On Wed, Nov 13, 2024 at 3:42 PM Adrian Klaver <[email protected]
> <mailto:[email protected]>> wrote:
>
> On 11/13/24 10:50, Catherine Frock wrote:
> > 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
>
> Do you still have the Postgres 9.6 instance running?
>
> > through the installation of PostgreSQL 16.3, I opened up pgAdmin
> 4 to
>
> What version of pgAdmin4?
>
> > try to verify the PostgreSQL/PostGIS installation, but when I try to
> > connect to the PostgreSQL 16.3 server, I get an internal server
> error
> > message: 'ServerManager' object has no attribute 'user_info'.
> >
> > In pgAdmin4, I am able to connect to the PostgreSQL 9.6 server,
> but when
>
> So the 9.6 instance is running.
>
> > I try to verify the install by querying: CREATE EXTENSION postgis;
> > SELECT postgis_version();
> > I get the following error message: ERROR: could not open extension
> > control file "C:/Program
> > Files/PostgreSQL/9.6/share/extension/postgis.control": No such
> file or
> > directory SQL state: 58P01
>
> What OS and version are you running?
>
> How did you install Postgres?
>
>
> >
> > How can I restore my database to have access to it again?
> >
> > Thanks.
>
> --
> Adrian Klaver
> [email protected] <mailto:[email protected]>
>
--
Adrian Klaver
[email protected]
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Help with restoring database from old version of PostgreSQL
2024-11-13 20:42 Re: Help with restoring database from old version of PostgreSQL Adrian Klaver <[email protected]>
2024-11-14 15:00 ` Re: Help with restoring database from old version of PostgreSQL Catherine Frock <[email protected]>
2024-11-14 17:02 ` Re: Help with restoring database from old version of PostgreSQL Adrian Klaver <[email protected]>
@ 2024-11-19 21:47 ` Catherine Frock <[email protected]>
2024-11-19 22:00 ` Re: Help with restoring database from old version of PostgreSQL Ron Johnson <[email protected]>
2024-11-19 22:16 ` Re: Help with restoring database from old version of PostgreSQL Adrian Klaver <[email protected]>
2024-11-21 00:42 ` Re: Help with restoring database from old version of PostgreSQL Peter J. Holzer <[email protected]>
0 siblings, 3 replies; 11+ messages in thread
From: Catherine Frock @ 2024-11-19 21:47 UTC (permalink / raw)
To: Adrian Klaver <[email protected]>; +Cc: [email protected]; [email protected]
I am trying to restore a previously backed up database .sql file that was
created in PostgreSQL 9.6 using pgAdmin4 (I'm not sure which version I was
using).
In response to Ron: Do I need to use PG16 instead of pgAdmin4? And if so,
can you please provide a website where I can download PG16?
In response to Adrian: How do I determine what version of PostGIS I need to
be using? When I installed it, I was only given one option of a version to
install.
Since my previous installation of pgAdmin4 was not working, I have started
over today, uninstalling all versions of PostgreSQL that I had and
reinstalling PostgreSQL Version 17.0 from https://www.enterprisedb.com/ and
pgAdmin4 version 8.12 from https://www.pgadmin.org. I tried installing
PostgreSQL 9.6.24 also, but I received an error message when I run the
installation file: "An error occurred executing the Microsoft VC++ runtime
installer." I installed the latest versions of the PostGIS (3.5.0) and
psqlODBC drivers (I'm forgot to write that down and am not sure how to
check the version). My installation of PostgreSQL/PostGIS was verified as
successful. I am able to connect to the PostgreSQL 9.6 and 17 servers. I
set the PostgreSQL Binary Path to: C:\Program Files\PostgreSQL\17\bin. I
have tried to restore my database using this in the command prompt: "psql.exe
db_2024_9 < C:\postgis\db_2017-08-16.sql postgres" using an empty database
in both the PostgreSQL 9.6 and 17 servers, and this is the result:
Password for user postgres:
SET
SET
SET
SET
SET
SET
SET
SET
WARNING: database "db_2017" does not exist
COMMENT
CREATE SCHEMA
ALTER SCHEMA
COMMENT
CREATE SCHEMA
ALTER SCHEMA
COMMENT
CREATE SCHEMA
ALTER SCHEMA
COMMENT
CREATE SCHEMA
ALTER SCHEMA
COMMENT
CREATE EXTENSION
COMMENT
CREATE EXTENSION
COMMENT
SET
CREATE FUNCTION
ALTER FUNCTION
COMMENT
CREATE FUNCTION
ALTER FUNCTION
COMMENT
CREATE FUNCTION
ALTER FUNCTION
COMMENT
CREATE FUNCTION
ALTER FUNCTION
COMMENT
CREATE FUNCTION
ALTER FUNCTION
COMMENT
SET
SET
SET
CREATE TABLE
ALTER TABLE
COMMENT
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
COMMENT
SET
CREATE TABLE
ALTER TABLE
SET
CREATE VIEW
ALTER TABLE
COMMENT
SET
CREATE TABLE
ALTER TABLE
SET
CREATE TABLE
ALTER TABLE
COMMENT
SET
CREATE VIEW
ALTER TABLE
COMMENT
CREATE VIEW
ALTER TABLE
COMMENT
SET
CREATE TABLE
ALTER TABLE
COMMENT
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
SET
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
COMMENT
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
COMMENT
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
SET
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
SET
ALTER TABLE
SET
ALTER TABLE
ALTER TABLE
ALTER TABLE
SET
COPY 0
setval
--------
1
(1 row)
COPY 0
SET
COPY 3
COPY 7
COPY 6
COPY 3
SET
COPY 67
COPY 37649
setval
--------
38344
(1 row)
COPY 38783
COPY 38344
setval
--------
41058
(1 row)
COPY 81
COPY 81
setval
--------
654
(1 row)
SET
COPY 35
COPY 40
COPY 39
COPY 35
COPY 35
COPY 0
COPY 58
COPY 39
SET
ALTER TABLE
SET
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
SET
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
COMMENT
CREATE TRIGGER
ALTER TABLE
ALTER TABLE
ALTER TABLE
ERROR: role "basic_user" does not exist
ERROR: role "basic_user" does not exist
ERROR: role "basic_user" does not exist
ERROR: role "basic_user" does not exist
SET
ERROR: role "basic_user" does not exist
ERROR: role "basic_user" does not exist
SET
ERROR: role "basic_user" does not exist
SET
ERROR: role "basic_user" does not exist
SET
ERROR: role "basic_user" does not exist
SET
ERROR: role "basic_user" does not exist
ERROR: role "basic_user" does not exist
SET
ERROR: role "basic_user" does not exist
SET
ERROR: role "basic_user" does not exist
ERROR: role "basic_user" does not exist
ERROR: role "basic_user" does not exist
ERROR: role "basic_user" does not exist
SET
ALTER DEFAULT PRIVILEGES
ERROR: role "basic_user" does not exist
SET
ALTER DEFAULT PRIVILEGES
ERROR: role "basic_user" does not exist
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 <[email protected]>
wrote:
> On 11/14/24 07:00, Catherine Frock wrote:
> > Yes, I still have the backup file. I tried to open pgAdmin4 today to see
> > what version I'm running, and now this happened (see attachments). My
> > operating system is Windows 10 Home, version 10.0.19045 Build 19045. I
> > installed Postgres using these instructions:
> >
> https://basille.org/postgis2017/installation_instructions/install_postgresql.html
> <
> https://basille.org/postgis2017/installation_instructions/install_postgresql.html; I'm
> guessing at this point I probably need to start all over with the
> installation since pgAdmin4 is not working? But if 9.6 is no longer
> supported, can I still use it to access my database? I assumed I would need
> to migrate to the most recent version of PostgreSQL, but maybe that was a
> wrong assumption?
>
> 1) You can copy/paste the error message and provide as text.
>
> 2) Assuming you are installing Postgres 16 from the EDB package, the
> from here:
>
> https://www.postgresql.org/download/windows/
>
> PostgreSQL Version 64 Bit Windows Platforms
> 16 2022, 2019
>
> [...]
> 11 2019, 2016, 2012 R2
> 10 2016, 2012 R2 & R1, 7, 8, 10
>
> 3) From here:
>
> https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
>
> 9.6 can still be downloaded.
>
> It is not a supported version, but you can at least use it to access
> your database.
>
>
> 4) You need to provide a more detailed explanation of what you are
> trying to achieve.
>
> 5) 9.6 -> 16 is six major version jump. That means some research needs
> to be done, starting with determining what version of PostGIS you need
> to be using.
>
> >
> > Thank you for your help,
> > --
> > Arden
> >
> >
> > On Wed, Nov 13, 2024 at 3:42 PM Adrian Klaver <[email protected]
> > <mailto:[email protected]>> wrote:
> >
> > On 11/13/24 10:50, Catherine Frock wrote:
> > > 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
> >
> > Do you still have the Postgres 9.6 instance running?
> >
> > > through the installation of PostgreSQL 16.3, I opened up pgAdmin
> > 4 to
> >
> > What version of pgAdmin4?
> >
> > > try to verify the PostgreSQL/PostGIS installation, but when I try
> to
> > > connect to the PostgreSQL 16.3 server, I get an internal server
> > error
> > > message: 'ServerManager' object has no attribute 'user_info'.
> > >
> > > In pgAdmin4, I am able to connect to the PostgreSQL 9.6 server,
> > but when
> >
> > So the 9.6 instance is running.
> >
> > > I try to verify the install by querying: CREATE EXTENSION postgis;
> > > SELECT postgis_version();
> > > I get the following error message: ERROR: could not open
> extension
> > > control file "C:/Program
> > > Files/PostgreSQL/9.6/share/extension/postgis.control": No such
> > file or
> > > directory SQL state: 58P01
> >
> > What OS and version are you running?
> >
> > How did you install Postgres?
> >
> >
> > >
> > > How can I restore my database to have access to it again?
> > >
> > > Thanks.
> >
> > --
> > Adrian Klaver
> > [email protected] <mailto:[email protected]>
> >
>
> --
> Adrian Klaver
> [email protected]
>
>
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Help with restoring database from old version of PostgreSQL
2024-11-13 20:42 Re: Help with restoring database from old version of PostgreSQL Adrian Klaver <[email protected]>
2024-11-14 15:00 ` Re: Help with restoring database from old version of PostgreSQL Catherine Frock <[email protected]>
2024-11-14 17:02 ` Re: Help with restoring database from old version of PostgreSQL Adrian Klaver <[email protected]>
2024-11-19 21:47 ` Re: Help with restoring database from old version of PostgreSQL Catherine Frock <[email protected]>
@ 2024-11-19 22:00 ` Ron Johnson <[email protected]>
2024-11-19 22:13 ` Re: Help with restoring database from old version of PostgreSQL Catherine Frock <[email protected]>
2 siblings, 1 reply; 11+ messages in thread
From: Ron Johnson @ 2024-11-19 22:00 UTC (permalink / raw)
To: pgsql-generallists.postgresql.org <[email protected]>
Ah, so it's a plain old SQL file. That makes things much easier!!
Here's the thing: PG (whether 9.6 or 16 or 17) is the database engine; no
GUI, and just a basic command line interface.
PgAdmin4 is a GUI interface to PG. Newer versions of PgAdmin4 are not
compatible with EOL PG versions like 9.6.
What you need is *both* a new PG version *and* a new PgAdmin4 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 <[email protected]> wrote:
> I am trying to restore a previously backed up database .sql file that was
> created in PostgreSQL 9.6 using pgAdmin4 (I'm not sure which version I was
> using).
>
> In response to Ron: Do I need to use PG16 instead of pgAdmin4? And if so,
> can you please provide a website where I can download PG16?
>
> In response to Adrian: How do I determine what version of PostGIS I need
> to be using? When I installed it, I was only given one option of a version
> to install.
>
> Since my previous installation of pgAdmin4 was not working, I have started
> over today, uninstalling all versions of PostgreSQL that I had and
> reinstalling PostgreSQL Version 17.0 from https://www.enterprisedb.com/ and
> pgAdmin4 version 8.12 from https://www.pgadmin.org. I tried installing
> PostgreSQL 9.6.24 also, but I received an error message when I run the
> installation file: "An error occurred executing the Microsoft VC++ runtime
> installer." I installed the latest versions of the PostGIS (3.5.0) and
> psqlODBC drivers (I'm forgot to write that down and am not sure how to
> check the version). My installation of PostgreSQL/PostGIS was verified as
> successful. I am able to connect to the PostgreSQL 9.6 and 17 servers. I
> set the PostgreSQL Binary Path to: C:\Program Files\PostgreSQL\17\bin. I
> have tried to restore my database using this in the command prompt: "psql.exe
> db_2024_9 < C:\postgis\db_2017-08-16.sql postgres" using an empty database
> in both the PostgreSQL 9.6 and 17 servers, and this is the result:
>
> Password for user postgres:
> SET
> SET
> SET
> SET
> SET
> SET
> SET
> SET
> WARNING: database "db_2017" does not exist
> COMMENT
> CREATE SCHEMA
>
> [snip]
> CREATE TRIGGER
> ALTER TABLE
> ALTER TABLE
> ALTER TABLE
> ERROR: role "basic_user" does not exist
> ERROR: role "basic_user" does not exist
> ERROR: role "basic_user" does not exist
> ERROR: role "basic_user" does not exist
> SET
>
[snip]
> SET
> ALTER DEFAULT PRIVILEGES
> ERROR: role "basic_user" does not exist
> SET
> ALTER DEFAULT PRIVILEGES
> ERROR: role "basic_user" does not exist
> SET
> ALTER DEFAULT PRIVILEGES
> ERROR: role "basic_user" does not exist
> SET
> ALTER DEFAULT PRIVILEGES
> ERROR: role "basic_user" does not exist
>
>
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Help with restoring database from old version of PostgreSQL
2024-11-13 20:42 Re: Help with restoring database from old version of PostgreSQL Adrian Klaver <[email protected]>
2024-11-14 15:00 ` Re: Help with restoring database from old version of PostgreSQL Catherine Frock <[email protected]>
2024-11-14 17:02 ` Re: Help with restoring database from old version of PostgreSQL Adrian Klaver <[email protected]>
2024-11-19 21:47 ` Re: Help with restoring database from old version of PostgreSQL Catherine Frock <[email protected]>
2024-11-19 22:00 ` Re: Help with restoring database from old version of PostgreSQL Ron Johnson <[email protected]>
@ 2024-11-19 22:13 ` Catherine Frock <[email protected]>
2024-11-19 23:00 ` Re: Help with restoring database from old version of PostgreSQL Adrian Klaver <[email protected]>
0 siblings, 1 reply; 11+ messages in thread
From: Catherine Frock @ 2024-11-19 22:13 UTC (permalink / raw)
To: Ron Johnson <[email protected]>; +Cc: pgsql-generallists.postgresql.org <[email protected]>
Do you know what versions of PG and pgAdmin4 I need? Also, I don't know
where to get a different version of PG.
--
Arden
On Tue, Nov 19, 2024 at 5:01 PM Ron Johnson <[email protected]> wrote:
> Ah, so it's a plain old SQL file. That makes things much easier!!
>
> Here's the thing: PG (whether 9.6 or 16 or 17) is the database engine; no
> GUI, and just a basic command line interface.
> PgAdmin4 is a GUI interface to PG. Newer versions of PgAdmin4 are not
> compatible with EOL PG versions like 9.6.
>
> What you need is *both* a new PG version *and* a new PgAdmin4 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 <[email protected]>
> wrote:
>
>> I am trying to restore a previously backed up database .sql file that was
>> created in PostgreSQL 9.6 using pgAdmin4 (I'm not sure which version I was
>> using).
>>
>> In response to Ron: Do I need to use PG16 instead of pgAdmin4? And if so,
>> can you please provide a website where I can download PG16?
>>
>> In response to Adrian: How do I determine what version of PostGIS I need
>> to be using? When I installed it, I was only given one option of a version
>> to install.
>>
>> Since my previous installation of pgAdmin4 was not working, I have
>> started over today, uninstalling all versions of PostgreSQL that I had and
>> reinstalling PostgreSQL Version 17.0 from https://www.enterprisedb.com/ and
>> pgAdmin4 version 8.12 from https://www.pgadmin.org. I tried installing
>> PostgreSQL 9.6.24 also, but I received an error message when I run the
>> installation file: "An error occurred executing the Microsoft VC++ runtime
>> installer." I installed the latest versions of the PostGIS (3.5.0) and
>> psqlODBC drivers (I'm forgot to write that down and am not sure how to
>> check the version). My installation of PostgreSQL/PostGIS was verified
>> as successful. I am able to connect to the PostgreSQL 9.6 and 17 servers. I
>> set the PostgreSQL Binary Path to: C:\Program Files\PostgreSQL\17\bin. I
>> have tried to restore my database using this in the command prompt: "psql.exe
>> db_2024_9 < C:\postgis\db_2017-08-16.sql postgres" using an empty database
>> in both the PostgreSQL 9.6 and 17 servers, and this is the result:
>>
>> Password for user postgres:
>> SET
>> SET
>> SET
>> SET
>> SET
>> SET
>> SET
>> SET
>> WARNING: database "db_2017" does not exist
>> COMMENT
>> CREATE SCHEMA
>>
>> [snip]
>
>> CREATE TRIGGER
>> ALTER TABLE
>> ALTER TABLE
>> ALTER TABLE
>> ERROR: role "basic_user" does not exist
>> ERROR: role "basic_user" does not exist
>> ERROR: role "basic_user" does not exist
>> ERROR: role "basic_user" does not exist
>> SET
>>
> [snip]
>
>> SET
>> ALTER DEFAULT PRIVILEGES
>> ERROR: role "basic_user" does not exist
>> SET
>> ALTER DEFAULT PRIVILEGES
>> ERROR: role "basic_user" does not exist
>> SET
>> ALTER DEFAULT PRIVILEGES
>> ERROR: role "basic_user" does not exist
>> SET
>> ALTER DEFAULT PRIVILEGES
>> ERROR: role "basic_user" does not exist
>>
>>
>
> Death to <Redacted>, and butter sauce.
> Don't boil me, I'm still alive.
> <Redacted> lobster!
>
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Help with restoring database from old version of PostgreSQL
2024-11-13 20:42 Re: Help with restoring database from old version of PostgreSQL Adrian Klaver <[email protected]>
2024-11-14 15:00 ` Re: Help with restoring database from old version of PostgreSQL Catherine Frock <[email protected]>
2024-11-14 17:02 ` Re: Help with restoring database from old version of PostgreSQL Adrian Klaver <[email protected]>
2024-11-19 21:47 ` Re: Help with restoring database from old version of PostgreSQL Catherine Frock <[email protected]>
2024-11-19 22:00 ` Re: Help with restoring database from old version of PostgreSQL Ron Johnson <[email protected]>
2024-11-19 22:13 ` Re: Help with restoring database from old version of PostgreSQL Catherine Frock <[email protected]>
@ 2024-11-19 23:00 ` Adrian Klaver <[email protected]>
2024-11-20 14:23 ` Re: Help with restoring database from old version of PostgreSQL Catherine Frock <[email protected]>
0 siblings, 1 reply; 11+ messages in thread
From: Adrian Klaver @ 2024-11-19 23:00 UTC (permalink / raw)
To: Catherine Frock <[email protected]>; Ron Johnson <[email protected]>; +Cc: pgsql-generallists.postgresql.org <[email protected]>
On 11/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.
To that end answer the following:
1) What are the Postgres and PostGIS versions you started with?
2) What database or databases do you want to move forward?
3) Is there a hard requirement for what currently supported version of
Postgres you want to use?
4) What do you want to do with the new install?
5) What versions of Postgres, pgAdmin4 and PostGIS do you currently have
installed?
6) You are looking at jumping a minimum of 4 major Postgres versions up
to a maximum of 8 versions. You are also jumping some number of PostGIS
versions as well. In either case you should at some point go over the
release notes for each major version jump to see if anything is going to
cause issues.
> --
> Arden
>
--
Adrian Klaver
[email protected]
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Help with restoring database from old version of PostgreSQL
2024-11-13 20:42 Re: Help with restoring database from old version of PostgreSQL Adrian Klaver <[email protected]>
2024-11-14 15:00 ` Re: Help with restoring database from old version of PostgreSQL Catherine Frock <[email protected]>
2024-11-14 17:02 ` Re: Help with restoring database from old version of PostgreSQL Adrian Klaver <[email protected]>
2024-11-19 21:47 ` Re: Help with restoring database from old version of PostgreSQL Catherine Frock <[email protected]>
2024-11-19 22:00 ` Re: Help with restoring database from old version of PostgreSQL Ron Johnson <[email protected]>
2024-11-19 22:13 ` Re: Help with restoring database from old version of PostgreSQL Catherine Frock <[email protected]>
2024-11-19 23:00 ` Re: Help with restoring database from old version of PostgreSQL Adrian Klaver <[email protected]>
@ 2024-11-20 14:23 ` Catherine Frock <[email protected]>
0 siblings, 0 replies; 11+ messages in thread
From: Catherine Frock @ 2024-11-20 14:23 UTC (permalink / raw)
To: Adrian Klaver <[email protected]>; +Cc: Ron Johnson <[email protected]>; pgsql-generallists.postgresql.org <[email protected]>
Adrian: Yes, db_2017 is the name I originally gave the database in the
PostgreSQL 9.6 server. I can't remember if I used pg_dump or pg_dumpall.
Ron: Okay, I think it finally worked!
Thank you both for your help.
--
Arden
On Tue, Nov 19, 2024 at 6:00 PM Adrian Klaver <[email protected]>
wrote:
> On 11/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.
>
> To that end answer the following:
>
> 1) What are the Postgres and PostGIS versions you started with?
>
> 2) What database or databases do you want to move forward?
>
> 3) Is there a hard requirement for what currently supported version of
> Postgres you want to use?
>
> 4) What do you want to do with the new install?
>
> 5) What versions of Postgres, pgAdmin4 and PostGIS do you currently have
> installed?
>
> 6) You are looking at jumping a minimum of 4 major Postgres versions up
> to a maximum of 8 versions. You are also jumping some number of PostGIS
> versions as well. In either case you should at some point go over the
> release notes for each major version jump to see if anything is going to
> cause issues.
>
> > --
> > Arden
> >
>
>
> --
> Adrian Klaver
> [email protected]
>
>
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Help with restoring database from old version of PostgreSQL
2024-11-13 20:42 Re: Help with restoring database from old version of PostgreSQL Adrian Klaver <[email protected]>
2024-11-14 15:00 ` Re: Help with restoring database from old version of PostgreSQL Catherine Frock <[email protected]>
2024-11-14 17:02 ` Re: Help with restoring database from old version of PostgreSQL Adrian Klaver <[email protected]>
2024-11-19 21:47 ` Re: Help with restoring database from old version of PostgreSQL Catherine Frock <[email protected]>
@ 2024-11-19 22:16 ` Adrian Klaver <[email protected]>
2 siblings, 0 replies; 11+ messages in thread
From: Adrian Klaver @ 2024-11-19 22:16 UTC (permalink / raw)
To: Catherine Frock <[email protected]>; +Cc: [email protected]; [email protected]
On 11/19/24 1:47 PM, Catherine Frock wrote:
> I am trying to restore a previously backed up database .sql file that
> was created in PostgreSQL 9.6 using pgAdmin4 (I'm not sure which version
> I was using).
>
> In response to Ron: Do I need to use PG16 instead of pgAdmin4? And if
> so, can you please provide a website where I can download PG16?
>
> In response to Adrian: How do I determine what version of PostGIS I need
> to be using? When I installed it, I was only given one option of a
> version to install.
Go here:
https://postgis.net/development/source_code/
and look in the release notes. They will tell you what range of Postgres
versions are supported. For instance the latest 3.5.0:
https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.5.0/NEWS
"To take advantage of all postgis_sfcgal extension features SFCGAL 1.5+
is needed. PostgreSQL 12-17 required. GEOS 3.8+ required. Proj 6.1+
required. "
>
> Since my previous installation of pgAdmin4 was not working, I have
> started over today, uninstalling all versions of PostgreSQL that I had
> and reinstalling PostgreSQL Version 17.0 from
> https://www.enterprisedb.com/ <https://www.enterprisedb.com/; and
> pgAdmin4 version 8.12 from https://www.pgadmin.org
> <https://www.pgadmin.org;. I tried installing PostgreSQL 9.6.24 also,
> but I received an error message when I run the installation file: "An
> error occurred executing the Microsoft VC++ runtime installer." I
> installed the latest versions of the PostGIS (3.5.0) and psqlODBC
> drivers (I'm forgot to write that down and am not sure how to check the
> version). My installation of PostgreSQL/PostGIS was verified as
> successful. I am able to connect to the PostgreSQL 9.6 and 17 servers. I
> set the PostgreSQL Binary Path to: C:\Program Files\PostgreSQL\17\bin. I
> have tried to restore my database using this in the command prompt:
> "psql.exe db_2024_9 < C:\postgis\db_2017-08-16.sql postgres" using an
> empty database in both the PostgreSQL 9.6 and 17 servers, and this is
> the result:
1) Is db_2017 a database you had on old server?
2) What backup did you do in pgAdmin4 for the 9.6 instance?
Did you do the entire server:
https://www.pgadmin.org/docs/pgadmin4/8.13/backup_server_dialog.html
or backup just one database?:
https://www.pgadmin.org/docs/pgadmin4/8.13/backup_dialog.html
If the latter then you did not get the global objects for the Postgres
9.6 instance. This includes roles(users) and would account for the user
errors.
To get the global objects use:
https://www.pgadmin.org/docs/pgadmin4/8.13/backup_globals_dialog.html
> Password for user postgres:
> SET
> SET
> SET
> SET
> SET
> SET
> SET
> SET
> WARNING: database "db_2017" does not exist
> COMMENT
> CREATE SCHEMA
> ALTER SCHEMA
> COMMENT
> CREATE SCHEMA
> ALTER SCHEMA
> COMMENT
> CREATE SCHEMA
> ALTER SCHEMA
> COMMENT
> CREATE SCHEMA
> ALTER SCHEMA
> COMMENT
> CREATE EXTENSION
> COMMENT
> CREATE EXTENSION
> COMMENT
> SET
> CREATE FUNCTION
> ALTER FUNCTION
> COMMENT
> CREATE FUNCTION
> ALTER FUNCTION
> COMMENT
> CREATE FUNCTION
> ALTER FUNCTION
> COMMENT
> CREATE FUNCTION
> ALTER FUNCTION
> COMMENT
> CREATE FUNCTION
> ALTER FUNCTION
> COMMENT
> SET
> SET
> SET
> CREATE TABLE
> ALTER TABLE
> COMMENT
> CREATE SEQUENCE
> ALTER TABLE
> ALTER SEQUENCE
> CREATE TABLE
> ALTER TABLE
> COMMENT
> SET
> CREATE TABLE
> ALTER TABLE
> SET
> CREATE VIEW
> ALTER TABLE
> COMMENT
> SET
> CREATE TABLE
> ALTER TABLE
> SET
> CREATE TABLE
> ALTER TABLE
> COMMENT
> SET
> CREATE VIEW
> ALTER TABLE
> COMMENT
> CREATE VIEW
> ALTER TABLE
> COMMENT
> SET
> CREATE TABLE
> ALTER TABLE
> COMMENT
> CREATE TABLE
> ALTER TABLE
> CREATE TABLE
> ALTER TABLE
> SET
> CREATE TABLE
> ALTER TABLE
> CREATE SEQUENCE
> ALTER TABLE
> ALTER SEQUENCE
> CREATE TABLE
> ALTER TABLE
> COMMENT
> CREATE SEQUENCE
> ALTER TABLE
> ALTER SEQUENCE
> CREATE TABLE
> ALTER TABLE
> COMMENT
> CREATE TABLE
> ALTER TABLE
> CREATE SEQUENCE
> ALTER TABLE
> ALTER SEQUENCE
> SET
> CREATE TABLE
> ALTER TABLE
> CREATE TABLE
> ALTER TABLE
> CREATE TABLE
> ALTER TABLE
> CREATE TABLE
> ALTER TABLE
> CREATE TABLE
> ALTER TABLE
> CREATE TABLE
> ALTER TABLE
> CREATE TABLE
> ALTER TABLE
> SET
> ALTER TABLE
> SET
> ALTER TABLE
> ALTER TABLE
> ALTER TABLE
> SET
> COPY 0
> setval
> --------
> 1
> (1 row)
>
> COPY 0
> SET
> COPY 3
> COPY 7
> COPY 6
> COPY 3
> SET
> COPY 67
> COPY 37649
> setval
> --------
> 38344
> (1 row)
>
> COPY 38783
> COPY 38344
> setval
> --------
> 41058
> (1 row)
>
> COPY 81
> COPY 81
> setval
> --------
> 654
> (1 row)
>
> SET
> COPY 35
> COPY 40
> COPY 39
> COPY 35
> COPY 35
> COPY 0
> COPY 58
> COPY 39
> SET
> ALTER TABLE
> SET
> ALTER TABLE
> ALTER TABLE
> ALTER TABLE
> ALTER TABLE
> SET
> ALTER TABLE
> ALTER TABLE
> ALTER TABLE
> ALTER TABLE
> ALTER TABLE
> CREATE INDEX
> CREATE INDEX
> CREATE INDEX
> CREATE TRIGGER
> CREATE TRIGGER
> CREATE TRIGGER
> COMMENT
> CREATE TRIGGER
> ALTER TABLE
> ALTER TABLE
> ALTER TABLE
> ERROR: role "basic_user" does not exist
> ERROR: role "basic_user" does not exist
> ERROR: role "basic_user" does not exist
> ERROR: role "basic_user" does not exist
> SET
> ERROR: role "basic_user" does not exist
> ERROR: role "basic_user" does not exist
> SET
> ERROR: role "basic_user" does not exist
> SET
> ERROR: role "basic_user" does not exist
> SET
> ERROR: role "basic_user" does not exist
> SET
> ERROR: role "basic_user" does not exist
> ERROR: role "basic_user" does not exist
> SET
> ERROR: role "basic_user" does not exist
> SET
> ERROR: role "basic_user" does not exist
> ERROR: role "basic_user" does not exist
> ERROR: role "basic_user" does not exist
> ERROR: role "basic_user" does not exist
> SET
> ALTER DEFAULT PRIVILEGES
> ERROR: role "basic_user" does not exist
> SET
> ALTER DEFAULT PRIVILEGES
> ERROR: role "basic_user" does not exist
> 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
> <[email protected] <mailto:[email protected]>> wrote:
>
> On 11/14/24 07:00, Catherine Frock wrote:
> > Yes, I still have the backup file. I tried to open pgAdmin4 today
> to see
> > what version I'm running, and now this happened (see
> attachments). My
> > operating system is Windows 10 Home, version 10.0.19045 Build
> 19045. I
> > installed Postgres using these instructions:
> >
> https://basille.org/postgis2017/installation_instructions/install_postgresql.html <https://basille.org/postgis2017/installation_instructions/install_postgresql.html; <https://basille.org/postgis2017/installation_instructions/install_postgresql.html <https://basille.org/postgis2017/installation_instructions/install_postgresql.html>> I'm guessing at this point I probably need to start all over with the installation since pgAdmin4 is not working? But if 9.6 is no longer supported, can I still use it to access my database? I assumed I would need to migrate to the most recent version of PostgreSQL, but maybe that was a wrong assumption?
>
> 1) You can copy/paste the error message and provide as text.
>
> 2) Assuming you are installing Postgres 16 from the EDB package, the
> from here:
>
> https://www.postgresql.org/download/windows/
> <https://www.postgresql.org/download/windows/;
>
> PostgreSQL Version 64 Bit Windows Platforms
> 16 2022, 2019
>
> [...]
> 11 2019, 2016, 2012 R2
> 10 2016, 2012 R2 & R1, 7, 8, 10
>
> 3) From here:
>
> https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
> <https://www.enterprisedb.com/downloads/postgres-postgresql-downloads;
>
> 9.6 can still be downloaded.
>
> It is not a supported version, but you can at least use it to access
> your database.
>
>
> 4) You need to provide a more detailed explanation of what you are
> trying to achieve.
>
> 5) 9.6 -> 16 is six major version jump. That means some research needs
> to be done, starting with determining what version of PostGIS you need
> to be using.
>
> >
> > Thank you for your help,
> > --
> > Arden
> >
> >
> > On Wed, Nov 13, 2024 at 3:42 PM Adrian Klaver
> <[email protected] <mailto:[email protected]>
> > <mailto:[email protected]
> <mailto:[email protected]>>> wrote:
> >
> > On 11/13/24 10:50, Catherine Frock wrote:
> > > 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
> >
> > Do you still have the Postgres 9.6 instance running?
> >
> > > through the installation of PostgreSQL 16.3, I opened up
> pgAdmin
> > 4 to
> >
> > What version of pgAdmin4?
> >
> > > try to verify the PostgreSQL/PostGIS installation, but
> when I try to
> > > connect to the PostgreSQL 16.3 server, I get an internal
> server
> > error
> > > message: 'ServerManager' object has no attribute 'user_info'.
> > >
> > > In pgAdmin4, I am able to connect to the PostgreSQL 9.6
> server,
> > but when
> >
> > So the 9.6 instance is running.
> >
> > > I try to verify the install by querying: CREATE EXTENSION
> postgis;
> > > SELECT postgis_version();
> > > I get the following error message: ERROR: could not open
> extension
> > > control file "C:/Program
> > > Files/PostgreSQL/9.6/share/extension/postgis.control": No such
> > file or
> > > directory SQL state: 58P01
> >
> > What OS and version are you running?
> >
> > How did you install Postgres?
> >
> >
> > >
> > > How can I restore my database to have access to it again?
> > >
> > > Thanks.
> >
> > --
> > Adrian Klaver
> > [email protected] <mailto:[email protected]>
> <mailto:[email protected] <mailto:[email protected]>>
> >
>
> --
> Adrian Klaver
> [email protected] <mailto:[email protected]>
>
--
Adrian Klaver
[email protected]
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Help with restoring database from old version of PostgreSQL
2024-11-13 20:42 Re: Help with restoring database from old version of PostgreSQL Adrian Klaver <[email protected]>
2024-11-14 15:00 ` Re: Help with restoring database from old version of PostgreSQL Catherine Frock <[email protected]>
2024-11-14 17:02 ` Re: Help with restoring database from old version of PostgreSQL Adrian Klaver <[email protected]>
2024-11-19 21:47 ` Re: Help with restoring database from old version of PostgreSQL Catherine Frock <[email protected]>
@ 2024-11-21 00:42 ` Peter J. Holzer <[email protected]>
2 siblings, 0 replies; 11+ messages in thread
From: Peter J. Holzer @ 2024-11-21 00:42 UTC (permalink / raw)
To: [email protected]
On 2024-11-19 16:47:40 -0500, Catherine Frock wrote:
> I am trying to restore a previously backed up database .sql file that was
> created in PostgreSQL 9.6 using pgAdmin4 (I'm not sure which version I was
> using).
>
> In response to Ron: Do I need to use PG16 instead of pgAdmin4?
As Ron already pointed out, these are different things. PostgreSQL is a
Database. PgAdmin ist a Client for that database. You can't use one
instead of the other. You can only use them together (but of course you
could use a different client instead of PgAdmin4).
> I set the PostgreSQL Binary Path to: C:\Program
> Files\PostgreSQL\17\bin. I have tried to restore my database using
> this in the command prompt: "psql.exe db_2024_9 <
> C:\postgis\db_2017-08-16.sql postgres" using an empty database in both
> the PostgreSQL 9.6 and 17 servers, and this is the result:
>
> Password for user postgres:
> SET
[...]
> ALTER TABLE
> ERROR: role "basic_user" does not exist
[...]
> ALTER DEFAULT PRIVILEGES
> ERROR: role "basic_user" does not exist
That looks fine except that the user "basic_user" doesn't exist. You
should create that before restoring the backup. Or could fix the errors
after the fact but for that you need to understand what went wrong.
hp
--
_ | Peter J. Holzer | Story must make more sense than reality.
|_|_) | |
| | | [email protected] | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
Attachments:
[application/pgp-signature] signature.asc (833B, 2-signature.asc)
download
^ permalink raw reply [nested|flat] 11+ messages in thread
end of thread, other threads:[~2024-11-21 00:42 UTC | newest]
Thread overview: 11+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-11-13 20:42 Re: Help with restoring database from old version of PostgreSQL Adrian Klaver <[email protected]>
2024-11-14 15:00 ` Catherine Frock <[email protected]>
2024-11-14 15:38 ` Ron Johnson <[email protected]>
2024-11-14 17:02 ` Adrian Klaver <[email protected]>
2024-11-19 21:47 ` Catherine Frock <[email protected]>
2024-11-19 22:00 ` Ron Johnson <[email protected]>
2024-11-19 22:13 ` Catherine Frock <[email protected]>
2024-11-19 23:00 ` Adrian Klaver <[email protected]>
2024-11-20 14:23 ` Catherine Frock <[email protected]>
2024-11-19 22:16 ` Adrian Klaver <[email protected]>
2024-11-21 00:42 ` Peter J. Holzer <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox