I have used the NextGen Gallery WordPress plugin on a bunch of different projects and have always been satisfied with the functionality. On a recent WordPress project I was working on I installed NextGen Gallery assuming I would use it however after I got a bit further on the project I decided it wasn’t necessary and that it would be easier to simply use the default WordPress media uploading capabilities along with the “Lightbox 2” and the “Flexible Upload D3Z Edition” WordPress plugins instead. While NextGen gallery has tons of functionality and typically is easy to use for this project there would be many authors and I needed the path of least resistance to allow authors to write articles.
I have been using the WP-Forum WordPress plugin for along time now and even though I am moving away from using it I do still think its a great plugin. There are two reasons I am getting away from it which include the fact that it does not validate using the W3C Markup Validation Service and the main reason is because we have launched Engage which will allow users an easier way to interact with Question Defense.
Easily create or drop a database via the psql CLI using the below syntax.
Create a PostgreSQL Database: Just modify the database_name to the name you prefer for your new database.
- create database database_name
If you are having issues dropping a postgres database the issue is more than likely that a user is accessing the database you are attempting to drop. There isn’t technically a way to force drop the postgres database however there are steps you can take to prevent others from accessing the database and if needed kick the users whom are accessing the database.
If you receive an error similar to the below the issue with your attempt to drop the database is the fact that either a user is accessing the database or an application of some sort has an open connection to the database. In the second scenario PostgreSQL considers the application the same as a user. In the code below the name of the example database is dev.
Please note that dropping the database will destroy all data located within the database. I strongly suggest always backing up your data before dropping the database. You can backup the data with pg_dump and regardless of if you think you will need the data or not it is best to keep a copy just in case.