Logging...
Posted: Tue Mar 10, 2009 1:03 am
Hi,
Is it a bad idea to store frequently updated information in a file on a server?
The reason I want to use a file on the server and not a db is: I am working on a script that uses a pgsql database, and I want to store every query in which data is submitted to the server (ie. every query that adds info or updates the database). This would be for backup/transfer purposes.
should I just get to it and write a backup script that reads all the tables' rows' data and generates a backup sql file, or will this cheap workaround work? Is it bad for server load?
Thanks
Is it a bad idea to store frequently updated information in a file on a server?
The reason I want to use a file on the server and not a db is: I am working on a script that uses a pgsql database, and I want to store every query in which data is submitted to the server (ie. every query that adds info or updates the database). This would be for backup/transfer purposes.
should I just get to it and write a backup script that reads all the tables' rows' data and generates a backup sql file, or will this cheap workaround work? Is it bad for server load?
Thanks