Changes
Jump to navigation
Jump to search
← Older edit
Postgresql
(view source)
Revision as of 18:42, 12 December 2022
377 bytes added
,
18:42, 12 December 2022
→Version
Line 13:
Line 13:
|licence= AGPLv3
|licence= AGPLv3
|url= https://www.postgresql.org/
|url= https://www.postgresql.org/
−
|category=
databases
+
|category=
database
−
|tags=
databases
+
|tags=
database,db,pgsql
}}
}}
Line 31:
Line 31:
=== Upgrade ===
=== Upgrade ===
−
yum update {{#var:smecontribname
}} {{#var:contribname
}} --enablerepo=smecontribs
+
yum update {{#var:smecontribname}} --enablerepo=smecontribs
=== Uninstall ===
=== Uninstall ===
−
yum remove {{#var:smecontribname}} {{#var:contribname}}
+
yum remove {{#var:smecontribname}} {{#var:contribname}}
*
+
+
=== Manually restore db ===
+
after you upgraded you server or migrate, here how to restore db
+
+
using psql<syntaxhighlight lang="bash">
+
exec chpst -u postgres /usr/pgsql-13/bin/psql < /home/e-smith/db/pgsql/pgsql.dump
+
</syntaxhighlight>using pg_restore
+
+
<syntaxhighlight lang="bash">
+
exec chpst -u postgres /usr/pgsql-13/bin/pg_restore < /home/e-smith/db/pgsql/pgsql.dump
+
</syntaxhighlight>
=== Bugs ===
=== Bugs ===
Unnilennium
Super Admin, Wiki & Docs Team,
Bureaucrats
,
Interface administrators
,
Administrators
3,252
edits
Navigation menu
Personal tools
Log in
Namespaces
Page
Discussion
Variants
Views
Read
View source
View history
More
Search
Koozali SME Server
Main Page
Welcome
Releases
Testimonials
Documentation
SME Server FAQ
Volunteering
Commercial Support
Recent activities
Dashboard
Recent wiki changes
Recent bug changes
Unread Forum posts
Koozali resources
Contribs
How-To's
Forums
Bugzilla
Mailing Lists
Translations
Download
Koozali SME Server wiki
Wiki statistics
Wiki categories
Wiki Help
Koozali Wiki Help
Tools
Special pages
Printable version