How to Backup database PostgreSQL in osqa?

Hi all! I'm install OSQA in CentOS and database is PostgreSQL.
1. I don't see table question. 2. I want to backup my database.

Please help me.

backup postgresql database

asked 31 Mar '11, 21:54

tannm
36●1●3●6
accept rate: 0%

edited 01 Apr '11, 13:37

@tannm, we require all postings at meta.osqa.net to have a clear, specific question as their title. "Backup database progressSQL" is not a question, and I really can't tell from the posting what your actual question is. Please edit this right away. Thanks.

(01 Apr '11, 08:48) rickross ♦♦

Have done!

(01 Apr '11, 12:18) tannm

Thank you! BTW, do you mean PostgreSQL?

(01 Apr '11, 12:20) rickross ♦♦

One Answer:

oldest newest most voted

You can back up you osqa data a number of ways:

Exporting out the database as an XML document from within OSQA www.yoursite.com/admin/tools/exporter/
Backing up via pgadmin by connecting to the database, selecting it and then going to tools, backup...

I hope this helps you.

Regards Thomas King

link

answered 01 Apr '11, 00:12

Thomas King
345●2●8●17
accept rate: 33%

Thanks for your answer. But link :www.yoursite.com/admin/tools/exporter/ is not found. And when i used pgadmin i can't see table question.

(01 Apr '11, 00:51) tannm

mmm...maybe you can't directly link to it. go to admin view and then change from standard to django. It will be visible towards the bottom of the list.

The table is under schema> public > tables and is called forum_node.

Regards Thomas

(01 Apr '11, 01:23) Thomas King

The table is under schema> public > tables and is called forum_node.
I got it.
Thankyou very much! So happy.

(01 Apr '11, 02:25) tannm

It would be nice if this backing-up procedure included a restoration procedure as well. =)

(01 Apr '11, 11:28) Randell

@Thomas King How to restore exported XML data? See this question http://meta.osqa.net/questions/7700/how-to-import-backup-made-with-xml-data-exporter-function

(02 Apr '11, 03:39) Tsuba

Your answer

toggle preview

community wiki

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Tags:

database ×62
postgresql ×19
backup ×10

Asked: 31 Mar '11, 21:54

Seen: 606 times

Last updated: 02 Apr '11, 03:39

How to Backup database PostgreSQL in osqa?

Follow this question

Learn more about OSQA

Related questions