Here are step-by-step instructions for installing PostgreSQL.app on your Mac. You simply download it and drag it to your Applications folder, just like with any other application. Postgres.app is a full-featured PostgreSQL installation packaged as a standard Mac application. Because of drupal's database abstraction layer this makes easy work of moving the database between server types.The easiest way to install PostgreSQL on a Mac is by installing Postgres.app. If you are using drupal and need to switch between postgresql and mysql, you should definitely look into the DBTNG Migrator project. and if the user you have set up doesn't have a password, then no need to enter a password either. Another note worth mentioning is that you do not need to specify a port when using this app, the default is fine. That allows you to browse your local databases. There is a very nice lightweight free app called PSequel. While I've not found something exactly like that for postgresql. OSX UIįor mySql, sequel pro seems to be the best GUI available. If you know of a better way, let me know in the comments. There may be a better way (it seems like there should be) to grant all priviledges to a specified user, which would be especially helpful when simply setting something up locally to develop with. GRANT ALL PRIVILEGES ON ALL SEQUENCES IN schema TO mydbname GRANT ALL PRIVILEGES ON ALL TABLES IN schema TO mydbname You create a database, and usually within that database is a schema called public that contains the tables. Postgres using the term schema and database a little differently than mysql. The SCHEMA you'll reference is most likely 'public'. But from what little I have done, I know you can grant your user priviledges to the using something like. I have to admit, I feel silly getting into any more specifics about managing priviledges. You can also use SQL to do all this as you would in MySQL, and this is probably the best way to alter your user if you want some things changed after initial creation. There are other setting you can use of course for specifying specifics. If you want add another user and you wish to use for development you can create one OUTSIDE the PSQL shell using a command called 'createuser'. When following the instructions above you will find yourself with a user named the same as your OSX user name. User management was a little unclear to me. Once this is created you can hop in to the PSQL shell and start querying. If you have a dump of a db you need to load up. You should get notification that the process is running in the background. So you need to put it in the background by hitting and then executing bg at the next shell prompt. This will leave you attached to the process on your command line. To just kick it off and have it run for the time being you can execute postgres -D /usr/local/var/postgres Which is what you need to do if you want it always running in the background. I only need to have Postgres running temporarily, so I didn't set up a launchd task or anything. Homebrew is refined enough to simply add the necessary options to your PHP installation rather than replace them. NOTE: this should not mess up your existing install of PHP. You will want first figure out which version of PHP you are using ( php -v on the cli) and select the correct PDO package. Install PostgresQL brew install postgresql Need to have a postgres instance set up in addition to your normal MySQL setup locally? This example assumes you are using PHP and Apache, though some of it likely works outside of those parameters.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |