pg_restore manual

pg_restore odtwarza bazę danych PostgreSQL z archiwum utworzonego przez pg_dump.

Składnia:
pg_restore [OPCJA]... [PLIK]

Opcje ogólne:
-d, --dbname=NAZWA połączenie do bazy danych o tej nazwie
-f, --file=NAZWAPLIKU nazwa pliku wyjścia
-F, --format=c|d|t format pliku kopii zapasowej (powinien być automatyczny)
-l, --list drukuje skrótowy spis treści archiwum
-v, --verbose tryb informacji szczegółowych
-V, --version pokaż informacje o wersji i zakończ
-?, --help pokaż tą pomoc i zakończ działanie

Opcje kontroli odtworzenia:
-a, --data-only odtwarza tylko dane, bez schematu
-c, --clean czyszczenie (kasowanie) obiektów baz danych przed odtworzeniem
-C, --create utworzenie docelowej bazy danych
-e, --exit-on-error wyjście w przypadku błędu, domyślna jest kontynuacja
-I, --index=NAZWA odtwarza indeks wedle nazwy
-j, --jobs=NUM użycie tylu równoległych zadań przy odtwarzaniu
-L, --use-list=NAZWAPLIKU użycie spisu treści z tego pliku by
wskazać/uporządkować wyjście
-n, --schema=NAZWA odtwarza tylko obiekty z tego schematu
-O, --no-owner bez odtwarzania posiadania obiektu
-P, --function=NAZWA(args) odtwarza funkcję wedle nazwy
-s, --schema-only odtwarza tylko schemat, bez danych
-S, --superuser=NAZWA nazwa superużytkownika by użyć lub wyłączyć wyzwalacze
-t, --table=NAZWA odtwarza tabelę wedle nazwy
-T, --trigger=NAZWA odtwarza wyzwalacz wedle nazwy
-x, --no-privileges nie wykonuje odtwarzania przywilejów dostępu (grant/revoke)
-1, --single-transaction odtworzenie jako pojedyncza transakcja
--disable-triggers wyłącza wyzwalacze podczas odtwarzania wyłącznie danych
--no-data-for-failed-tables
nie odtwarza danych z tabel, które nie mogły być odtworzone
--no-security-labels nie odtwarza etykiet bezpieczeństwa
--no-tablespaces nie odtwarza przypisań do przestrzeni tabel
--section=SECTION odtwarza nazwaną sekcję (pre-dane, dane, lub post-dane)
--use-set-session-authorization
używa poleceń SET SESSION AUTHORIZATION zamiast
poleceń ALTER OWNER by ustawić właściciela

Opcje połączenia:
-h, --host=NAZWAHOSTA host serwera bazy danych lub katalog gniazda
-p, --port=PORT numer portu na serwera bazy danych
-U, --username=NAZWA połączenie jako wskazany użytkownik bazy
-w, --no-password nie pytaj nigdy o hasło
-W, --password wymuś pytanie o hasło (powinno nastąpić automatycznie)
--role=NAZWAROLI wykonuje SET ROLE przed odtworzeniem

Jeśli nie wskazano nazwy pliku, użyty zostanie wejście standardowe.

Błędy proszę przesyłać na adres <Ten adres pocztowy jest chroniony przed spamowaniem. Aby go zobaczyć, konieczne jest włączenie w przeglądarce obsługi JavaScript.;.

How to Manually Install or Reinstall PostgreSQL 8.4 (Windows)

If postgresql is installed, check its version:

1. If PostgreSQL is still installed on your computer, go Start -> Programs and look for PostgreSQL (version) where (version) is the major version of PostgreSQL installed on your computer.
2. If PostgreSQL is no longer installed on your computer, open My Computer and browse to your Program Files/PostgreSQL directory. There will be a sub-directory listed which is either 8.3 or 8.4 depending on the version installed.

PostgreSQL requires complete administrative privileges to install and run properly.

You can install PostgreSQL on usesr account; however, you must right-click -> Run as Administrator whenever launching a PostgreSQL related function.

Uninstalling old PostgreSQL

Deleting the PostgreSQL Service Account

All Windows Versions
At the Windows command prompt type:

net user postgres /delete

Most popular PostgreSQL GUIs in 2022

pgAdmin

pgAdmin is the most popular PostgreSQL GUI. It is purpose built for Postgres and supports all its features and operations. pgAdmin is open source and also supports Postgres derivative databases such as EDB Postgres Advanced Server. You can test it live here.

pgAdmin supported platforms

You can install pgAdmin on

Linux
macOS
Windows
And then access it locally or over internet via your navigator.

Pros

You can run pgAdmin as a web application, on your computer or on any server, meaning you can use pgAdmin to access and manage distributed Postgres databases, from anywhere.
pgAdmin allows you to create, read and edit all PostgreSQL objects
You can easily rearrange its UI
pgAdmin offers advanced server monitoring capabilities
Cons

pgAdmin isn't as straight forward to install on your desktop as other postgres clients

pgAdmin is rather heavy and not easy to onboard
pgAdmin is more suited for administrating your PostgreSQL than developing on it
pgAdmin pricing: pgAdmin is free and open source

DBeaver

DBeaver is a widely used multi database GUI tool, particularly popular among postgreSQL developers. Just like pgAdmin, it's open source. In addition to postgreSQL, it supports MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Apache Hive, Phoenix, Presto, and more.

DBeaver supported platforms

Linux
macOS
Windows
Pros

DBeaver is super easy to install as a desktop application, and to connect to your PostgreSQL database
DBeaver offers a visual query builder to create advanced SQL queries without advanced (or any) knowledge of SQL
It comes with strong data access, search, visualization and edition capabilities
DBeaver also offers a fake data generator to populate your database and test it and the applications built on it
Cons

DBeaver runs locally requires a lot of computer resources, which leads to a performance crash

DBeaver pricing: It has a free open source edition as well as a corporate edition. The standard license for the enterprise edition can be purchased for $ 199 or a subscription for $ 19 per month. The free version is good enough for most businesses as many DBeaver users will tell you that the free edition is better than pgAdmin.

OmniDB

OmniDB is a browser-based app to access and manage various databases such as Oracle and MySQL. And of course, it can act as your PostgreSQL client.

OmniDB supported platforms

Linux
macOS
Windows
Pros

OmniDB supports plugins, so developers can add functionalities to their PostgreSQL GUI
It can be accessed by multiple users from several computers, making it a good option to collaborate on your PostgreSQL databases
OmniDB offers intuitive data editing features such as ability to copy and paste blocks
Good SQL editing with a customisable SQL editor featuring syntax highlight and code completion
Cons

Light documentation especially on the usage of the tool
OmniDB is more complex than a Postico or TablePlus but less advanced than a DataGrip or Navicat. It's a good free option but maybe less complete than DBeaver, which has a better documentation and a seemingly larger community.
OmniDB pricing: free and open source

DataGrip

DataGrip is a multi database IDE to install locally, that can act as your Postgres GUI and much more. It is developed by JetBrains who are known for their numerous dev tools. On top of Postgres, it supports MySQL, Oracle Database, Redshift, MariaDB, Cassandra, MongoDB and more.

DataGrip supported platforms

Linux
macOS
Windows
Pros

Powerful data viewer and editor
Great and customisable UI
A lot of powerful features to develop on your PostgreSQL database, such as context and schema based code completion, and real-time bug detection in your code (and fix suggestions!).
Cons

DataGrip can be resource intensive
Because it's much more than a Postgres client, DataGrip can be a bit overwhelming for beginners
DataGrip pricing: $8,9 per month, $199 per user per year for organisations.

Navicat

Navicat is a GUI focused on database development. As it is multi database, on top of acting as your PostgreSQL GUI, it can connect MySQL, MariaDB, MongoDB, SQL Server, Oracle, PostgreSQL, and SQLite.

Navicat supported platforms

Linux
macOS
iOS
Windows
Pros

Easy and powerful SQL development tools, such as a visual SQL builder, code completion and customisable Code Snippets.
Good database structure visualisation and edition capabilities.
Collaboration feature
Cons

Not Open Source

Navicat pricing: $349.99 per year for non commercial usage, $699.99 per year for commercial usage, with different commitment options

Postico

Postico is macOS PostgreSQL client for reading data, doing basic manual data entry and editing your database structure.

Postico supported platforms

macOS
Pros

Postico is extremely straight forward to execute basic tasks over your PostgreSQL database
Postico easy to install and to securely connect to your Postgres database
Cons

Postico's strenghts are also its weaknesses: it doesn't offer advanced administration, monitoring or querying capabilities
Postico is only available on macOS
Postico pricing: $5.99 to $299 per month for 1 user, free trial with feature limitations but no time limit.

 TablePlus

TablePlus is a database management GUI supporting various databases including MySQL, Redshift, Redis, MongoDB and of course PostgreSQL.

TablePlus supported platforms

Linux
macOS
iOS
iPadOS
Windows
Pros

High performance and speed.

Clean and intuitive data browsing, querying and editing UI
Various and easy to use security features
Good query editor including autocomplete, highlight syntax, query reformatter and history.
Cons

Not very stable, has a lot of bugs.
Very limited free trial version.
TablePlus pricing: from $49 to $99

 AQuirreL SQL

SquirreL SQL is a Java tool to view the structure of databases, browse their data, issue SQL commands and more. It supports many databases including SQL Server, MySQL, Oracle Database and of course PostgreSQL.

Squirrel SQL Supported platforms

Linux
Mac OS
Windows
Pros

SquirreL SQL supports Java plugins to extend its capabilities
Cons

Configuration is hard for first time users
The interface isn't the most intuitive
SquirreL SQL pricing: free and open source

HeidiSQL

HeidiSQL is a client supporting various databases including MariaDB, MySQL and PostgreSQL. It's been built with the goal of being easy to learn.

HeidiSQL supported platforms

Windows
Pros

HeidiSQL is particularly good at managing several databases/servers simultaneously. Not only it can connect to multiple servers, but allows direct exports from one server or database to another and search across all the connected databases from the same server.
HeidiSQL is easy to install as a Windows app.
Cons

Limited to Windows
Not very stable, has a lot of bugs.

HeidiSQL pricing: free and open source