ParsX.com
پذیرش پروژه از دانشجویی ... تا سازمانی 09376225339
 
   ProfileProfile   Log in to check your private messagesLog in to check your private messages  |  FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups Log inLog in   RegisterRegister 

backup resotre in pgsql

 
Post new topic   Reply to topic    ParsX.com Forum Index -> ذخيره و بازيابي اطلاعات - سيستم و ساختار فايلها
View previous topic :: View next topic  
Author Message
vahid
بي تو هرگز


Joined: 26 Nov 2004
Posts: 3067
Location: Tehran
PostPosted: Mon Jul 17, 2023 7:55 am    Post subject: backup resotre in pgsql Reply with quote
pg_dump --host localhost --port 5432 --username "postgres" --table=ac_threesixo* -F c ac1 >ac4114020426.tar


pg_restore --host localhost --port 5432 --username "postgres"  -d ac2 < ac4114020426.tar




https://simplebackups.com/blog/postgresql-pgdump-and-pgrestore-guide-examples/
Back to top
vahid
بي تو هرگز


Joined: 26 Nov 2004
Posts: 3067
Location: Tehran
PostPosted: Mon Jul 17, 2023 10:16 am    Post subject: Reply with quote
pg_dump dangerousdb > db.sql


restore from tables
sudo -ui postgres

pg_dump -U postgres -t tablename dbname | psql -U postgres newdb
Back to top
Display posts from previous:   
Post new topic   Reply to topic    ParsX.com Forum Index -> ذخيره و بازيابي اطلاعات - سيستم و ساختار فايلها All times are GMT + 3.5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


s Powered by phpBB © 2001, 2010 phpBB Group