MediaMan - Organize with Fun
- How do I backup or transfer a PostgreSQL database.
MediaMan Library doesn't currently have a backup mechanism. However, you can easily rely on pgAdmin III, the client program that comes with PostgreSQL server installation to backup and transfer. To do a backup, simply locate the MediaMan Library database in the object browser of pgAdmin (typically located under Servers/[Your Server Name]/Databases in the object browser), right click on it and choose "Backup ...". You will be prompted for options for a local compressed file to store. Alternatively, you can go deeper into Schemas/public/Tables in the object browser, and backup tables separately. You can use the compressed backup file to restore the database on another PostgreSQL server. To restore the backup, simply choose "Restore ..." when right clicking the database in object browser, and have your backup file ready.
- What do I do if I forgot the administrator's password?
If you forgot the password for the PostgreSQL server. You'll need to temporarily disable password authentication and reset the password. To do this, open up pg_hba.conf in the data directory of PostgreSQL, for each line of authenticating method, change it from "md5" to "trust" (without quotes). Restart PostgreSQL, you will be able to log on as "postgres", the root user, without using a password from pgAdmin III. Use pgAdmin III to change the password for the user. After that, change the "trust" back to "md5" on pg_hba.conf and restart PostgreSQL.
If you forgot the master administrator ("admin") password in MediaMan Library. Please note that MediaMan Library stores the administrator password in one-way hashed format. It's impossible to recover the original password. However, this hashed password is stored in a table called "mediaman_properties", therefore, it's possible to reset the password by resetting the data in this table. To do this, first run a backup for each table using the method described above. After that, drop all tables. Connect the database server using MediaMan Library, and you will be prompted to initialize the database. Set a password at this time. After the initialization, quit MediaMan Library. Use pgAdmin III to restore all tables except "mediaman_properties".
©2003-2011. He Shiming.