New answers tagged

3

Yes, you should reboot. Glibc provides the C library used by virtually every program on the system; all must be restarted in order to use the newly installed version.


3

If the database file is 0KB in size, then there's just nothing there. No amount of eseutil can recover anything from an empty file. You should fix the (probably serious) underlying storage problems, and then hope the database comes back unscathed. Otherwise... let's just hope you have good backups.


0

If you have binary logging turned on then you can just recreate a table first if you have schema. Make sure you create schema while you have binlogs turned off. Or you can just skip for the session. Then you can replay the binlogs up until the last statement which was drop table itself. If not then you can restore using a backup dump if you have any. If ...


0

You should create the uauvuro0s8b9v4 user prior to restore the database or the pg_restore will raise such errors (as this user's owns a lot of relations, in your case). In psql try: CREATE USER uauvuro0s8b9v4 WITH PASSWORD '12334444';


1

You have SELinux enabled, and you moved the files instead of copying them. Therefore they have their original context (probably user_home_t or something similar) rather than the necessary context for MySQL to use them. To solve the problem, put the files in the correct place in the directory structure (probably /var/lib/mysql/nordwind and run restorecon on ...


1

Big, constantly changing files as the one backing relational databases are not good candidate for this kind of continuous backup. I strongly advise you to dump your databases (with the relevant utility) and then to upload the dumps on Google Drive. Also, pay attention that Google Drive does not automatically empty the trash folder. This means that if you ...


3

Back up a database nightly I have a development database that I would like to refresh with the data from the Production database. I would like for this to happen every evening if possible. This way the development site will only be one day behind and any changes made to the data will be overwritten every evening Below are the outlined steps ...


0

It's a bit late to answer this question now. Nevertheless, I came across this issue past week and couldn't find the answer in the context of "repmgr". pg_ctl resides in the bin directory of your Postgres installation. The bin directory is not in the PATH environment variable. You can not set the environment variable either which makes this problem a tricky ...



Top 50 recent answers are included