![]() ![]() 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. #HOMEBREW POSTGRES INSTALL#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 |