|
I am working in a RedHat 5 environment. I have the psql command, but am not sure what I need to do to make a database. My admin would probably be willing to put reasonable things on the computer, but ideally I'd like to be able to manage my own little databases on the side. Information on how to make the database, and what is necessary to do so, would be greatly appreciated! |
|||||
|
This question came from our site for professional and enthusiast programmers.
|
The simplest way to create a database is to issue the createdb command from your (bash?) prompt: $ createdb mydatabasename The man page for createdb should have more details. This, of course, assumes that you have the appropriate database privileges. |
|||
|
|
|
You need create database privileges to do so. If you do: And then: And finally: If you cannot create a database from lack of permissions, you might want to look into creating a schema as a workaround. |
|||
|
|
|
Set up your own instance: You can tweak this a little to start automatically or in the background. See the documentation. Then you can connect: |
|||
|
|
