- Published:
- February 20, 2008 – 11:51 am
- Author:
- By Dave
When doing a PostgreSQL database server upgrade, you first need to backup all of the databases because the format changes from version to version.
Postgresql documentation states you need to run the command:
pg_dumpall > outputfile
I ran this, and received the error message:
pg_dumpall: could not connect to database “template1″: FATAL: role “root” does not exist
So after [...]
Categories: Linux, MySQL, System Administration
Tagged: backup, postgresql
- Published:
- August 14, 2007 – 10:40 am
- Author:
- By Dave
…and other MySQL Oddities.
If your MySQL binary log files are a “Growing” problem… there are a few simple steps you can use to curtail their growth and save your disk space from these huge files.
They probably look like:
mysql-bin.000001
mysql-bin.000002
mysql-bin.000003
mysql-bin.000004
mysql-bin.000005
…
And around 1 gig in size each.
These files are generated when you have log-bin=mysql-bin or other log-bin= [...]
Categories: Configurations, MySQL, System Administration
Tagged: database server