INFORMATICS

The Best

Przełącznik języka

Tools

This Site

Mining

Security

CMS

Hardware

Backup

Windows Server

Databases

Emulators

Powershell

Storage Array

Active Directory

SEO

MSSQL

Antivirus program

Linux

Licznik

3.png0.png4.png3.png8.png5.png4.png
Today493
Yesterday1020
This week8736
This month18755
Total3043854

Visitor Info

  • IP: 3.14.250.187
  • Browser: Unknown
  • Browser Version:
  • Operating System: Unknown

Who Is Online

1
Online
24.11.2024 10:06
Вы здесь: Home postgreSQL How to restore PostgreSQL database from .tar file

How to restore PostgreSQL database from .tar file

Звезда не активнаЗвезда не активнаЗвезда не активнаЗвезда не активнаЗвезда не активна
 

How to restore PostgreSQL database from .tar file

pg_restore -c -U postgres -d client03 -v "/tmp/client03.tar" -W

-c to clean the database
-U to force a user
-d to select the database
-v verbose mode, don't know why
"$$" the location of the files to import in tmp to get around permission issues
-W to force asking for the password to the user (postgres)

Search