Hi!
Is it possible to backup a PostgreSQL database (or a specific table) using FME?
PostgreSQL backup
Userlevel 3
+14
- Enthusiast
- 85 replies
-
22 July 2024
Hi,
I think this depends on what you think of as a backup. FME is able to read features and copy them over to another table or another file format. It might be able to copy the whole table without reading it with the sqlexecuter but I would need to look into it further.
Userlevel 5
+32
- Evangelist
- 1730 replies
-
22 July 2024
- Best Answer
Yes, there are many options to use FME to perform a backup of a database or table.
with the SQLExceutor you can essentially perform any operatoins which you can via SQL.
You can also make system calls with FME using the SytemCaller. This is nice if you already have a script which runs a backup which you’d like to integrate or if you want to use the psql.exe directly.
Probably the easiest method it what
Here’s some more info from another user who had a similar question.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.