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
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
wrote:
> On 11/19/24 14:1
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
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 ar
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 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
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 res
You say that you just installed PG17. That's perfectly fine. If pgAdmin4
version 8.12 is recent, then it's fine to use that, too.
The thing is that sql files are just... a bunch of SQL statements.
Whatever SQL is generated by v9.6 will be easily processed by a modern
version.
On Tue, Nov 19, 2
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
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 wrote:
> Yes, I still have the backup file. I tried to open pgAdmin4
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 instruct
On Wed, Nov 13, 2024 at 1:50 PM 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 through the
> installation of Post
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 runni
12 matches
Mail list logo
