Breaking News: Grepper is joining You.com. Read the official announcement!

backup and restore pg

Add Answer

Dangerous Dragonfly answered on April 7, 2022 Popularity 8/10 Helpfulness 2/10

answer backup and restore pg

related pg_restore

related pg_restore command

backup and restore pg

Comment

#!/usr/bin/python

from subprocess import PIPE,Popen
import shlex

def dump_table(host_name,database_name,user_name,database_password,table_name):

    command = 'pg_dump -h {0} -d {1} -U {2} -p 5432 -t public.{3} -Fc -f /tmp/table.dmp'\
    .format(host_name,database_name,user_name,table_name)

    p = Popen(command,shell=True,stdin=PIPE,stdout=PIPE,stderr=PIPE)

    return p.communicate('{}\n'.format(database_password))

def restore_table(host_name,database_name,user_name,database_password):

    #Remove the '<' from the pg_restore command.
    command = 'pg_restore -h {0} -d {1} -U {2} /tmp/table.dmp'\
              .format(host_name,database_name,user_name)

    #Use shlex to use a list of parameters in Popen instead of using the
    #command as is.
    command = shlex.split(command)

    #Let the shell out of this (i.e. shell=False)
    p = Popen(command,shell=False,stdin=PIPE,stdout=PIPE,stderr=PIPE)

    return p.communicate('{}\n'.format(database_password))

def main():
    dump_table('localhost','testdb','user_name','passwd','test_tbl')
    restore_table('localhost','testdb','user_name','passwd')

if __name__ == "__main__":
    main()

Popularity 8/10 Helpfulness 2/10 Language sql

Source: stackoverflow.com

Tags: backup pg restore sql

Link to this answer
Share Copy Link

Contributed on Nov 23 2022

Dangerous Dragonfly

0 Answers Avg Quality 2/10

Closely Related Answers

pg_restore

Comment

pg_restore -U username -d dbname -1 filename.dump

Popularity 10/10 Helpfulness 5/10 Language whatever

Source: Grepper

Tags: whatever whateve

Link to this answer
Share Copy Link

Contributed on Apr 07 2022

Mattia

0 Answers Avg Quality 2/10

pg_restore

Comment

pg_restore -U postgres -d database_name < C:\file_path\backup_name.sqlc -W -h localhost

Popularity 9/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: whatever whateve

Link to this answer
Share Copy Link

Contributed on Nov 03 2022

Alvainds

0 Answers Avg Quality 2/10

pg_restore command

Comment

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

Popularity 9/10 Helpfulness 5/10 Language whatever

Source: serverfault.com

Tags: command

Link to this answer
Share Copy Link

Contributed on Jul 19 2023

Himanshu Jangid

0 Answers Avg Quality 2/10

backup and restore pg

Contents

More Related Answers

backup and restore pg

Closely Related Answers

pg_restore

pg_restore

pg_restore command

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.