August 30, 2008 03:22am pdt

1. ivanovn 30,220
2. adrpo 24,265
3. earthman2 23,010
4. gheist 16,910
5. drazen_n... 11,400
6. grant300 8,800
7. angelIII 7,400
8. fridom 6,000
9. lesouef 5,900
10. TomasHelgi 5,825
11. rokov 4,500
12. lssaul 4,000
13. tusharkan... 3,900
14. sanjooz 3,800
15. ee_rlee 3,750
16. mark_wills 3,600
17. hernst42 3,500
17. hielo 3,500
19. itsmeandn... 2,750
19. Nellios 2,750
21. Infinity08 2,600
22. CEHJ 2,000
22. pepr 2,000
22. anoospillai 2,000
22. EugeneZ 2,000
22. rstomar 2,000
22. laneduncan 2,000
22. dportas 2,000
22. Rance_H... 2,000
22. TheLearn... 2,000
22. dejanpazin 2,000
22. uetian1707 2,000
22. vadimrapp1 2,000
22. cool_sat... 2,000
22. mohammedf 2,000
22. bigbadguy 2,000
22. frankytee 2,000
22. asvforce 2,000
22. Kuldeepc... 2,000
22. StuFox100 2,000

1. earthman2 430,143
2. ivanovn 97,857
3. gheist 90,929
4. m1tk4 62,462
5. adrpo 43,659
6. grant300 31,622
7. rjkimble 31,347
8. ravenpl 20,699
9. GGuzdziol 16,660
10. fridom 15,000
11. angelIII 11,400
11. drazen_n... 11,400
13. TomasHelgi 11,325
14. Ghitza 7,600
15. ldbkutty 6,730
16. hernst42 6,300
17. gripe 6,000
18. lesouef 5,900
19. Robson 5,855
20. ushastry 5,500
21. jkr 5,250
22. ctcampbell 5,090
23. gamebits 5,000
24. Infinity08 4,600
25. rokov 4,500

06.09.2008 at 03:19AM PDT, ID: 23468485

	[x] Attachment Details

Backup Postgres DB Structure

Asked by ruanlab123 in PostgreSQL Database

Hi

Is it possible to backup the structure of a Postgres Database, I normally use the pgdump command for a backup but then the structure and the data is backup. I want to replicate the DB but with no data, a completely clean DB. The only way that I can think of is to restore the backup file and then write a sql script that will delete all the data, but with a DB of 220+ tables, certainly there must be a faster way.

ThanksStart Free Trial

Keywords: Backup Postgres DB Structure

	Title
1	Postgres database dump (Redhat Lin…
2	Recover Postgre Data from CPU
3	Backup in Postgres
4	Backup and restore of Win2k Server t…
5	Postgres could not connect
6	PostgreSQL with master -> multiple s…

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Backup Postgres DB Structure

Asked by ruanlab123 in PostgreSQL Database

About this solution