I know the function "pg_dump" for backup and restore.
But I never tried because so scared.
Question is simple. Can I use that function for graph data?
Or Is the other function supported for that? There's no information in their documentation.
pg_dump is available in AgensGraph?
220 Views Asked by Kevin Lee At
1
There are 1 best solutions below
Related Questions in PG-DUMP
- PostgreSQL, pg_dump and pg_restore and object dependency order
- Constraints missing after pg_restore
- How do I dump a database from online server (heroku) to my local environment?
- how to delete a table before importing it on pg_dump?
- Can pg_dump be instructed to create tables with "IF NOT EXISTS"?
- PG_DUMP Memory out of error
- Why is pgdump only listing one of the three tables that I want data for?
- Copying postgresql data without roles
- Save sql file without NULL values
- Can i stop the "Public" schema from being Dropped with pg_dump?
- error postgresql 9.4 when dumping data
- pg_dump hangs when launched from Eclipse RCP application
- pg_restoring very large single table using -j option taking several hours
- Running pg_dump from ShellExecuteEx()
- PostgreSQL restore existing rows without drop table
Related Questions in AGENS-GRAPH
- Agens Graph get inherits
- Cypher find vector without edge of given type
- How to use graph data type using by pl/python in AgensGraph?
- How to load file on AgensGraph?
- "LIKE" operator does not work on agensgraph
- migrating to agensgraph create foreign table error
- Does AgensGraph support connection pool?
- pg_dump is available in AgensGraph?
- How do i clear Screen on AGENS command line
- Geospatial data usage in AgensGraph
- How can I change the collate of database in AgensGraph (under Windows OS)
- RDB + GDB use case in AgensGraph
- creating dynamic updates in Agensgraph via Cypher
- Cypher relating many nodes to one node
- Simplifying cypher, match all nodes and relationships between two node types
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
You may refer the postgreSQL pg_dump document coz nothing different from doing bakcup on postgreSQL.
I referred the guide to create dump script with crontab and both dump and restore worked fine.
In my case, I used pg_dump for creating dump file and restore it with psql. You may choose pg_restore instead if necessary.
However, I no longer use pg_dump for backup task due to the incremental bakcup requirement. So I googled available backup OSS for postgresql. Among the options I searched, pg_rman is currently what I am using.
It made me easier to build a scheduling script for archive backup every 6 hours, incremental backup every day and full backup every week and those jobs are working properly more than 2 months so far.
Restoring the data on other severs is tested successfully as well.
Hope this helpful for you.