postgresql questions
by vinmansbrew from LinuxQuestions.org on (#6E1VS)
I have a rhel 8 server, and it runs postgresql. I need to upgrade the database version.
I've been banging on it for a while, but I seem to have an issue with the table and database.
Essentially I backup the db. Delete the old postgresql install. Install the new 1.
From there I import the new db.
I have found out there are apparently tables, too.
Which order is it best to create/restore tables and DBs? Tables first, then db, or the other way around?
A good, simple source that explains postgresql would be great, too. I looked that postgresql site, but it doesn't really do a good job of explaining things. Well, to me it doesn't.
I've been banging on it for a while, but I seem to have an issue with the table and database.
Essentially I backup the db. Delete the old postgresql install. Install the new 1.
From there I import the new db.
I have found out there are apparently tables, too.
Which order is it best to create/restore tables and DBs? Tables first, then db, or the other way around?
A good, simple source that explains postgresql would be great, too. I looked that postgresql site, but it doesn't really do a good job of explaining things. Well, to me it doesn't.