The words Under construction in black text on a yellow background with diagonal black stipes surrounding it
I'm in the process of moving my site. It's still a work in progress. Please excuse the mess and broken links.

Create A Postgres Database

TODO: Pull subtitle into page object

Creating a postgres database can be done from the command line with:

code_start_default_section code_end_default_section

The database is made from a clone of the `template1` database. So, any changes made there will show up in your new database.

NOTES:

You can check what permissions users have with `\du` when logged into the database

Debugging Stuff

I'm moving stuff around right now. All this below is helping me figure out where to put stuff

        -- title

Create A Postgres Database

-- p

Creating a postgres database can be done from the 
command line with:

-- code/

createdb new_database_name

-- /code

-- p

vai: https://www.postgresql.org/docs/current/tutorial-createdb.html

-- p

-- h3

-- p

Old Notes

-- p

Connect to the main `postgres` database with a user that has create database privileges via:

-- code/

psql -U user_name -d postgres

-- /code

-- p

(Or, `psql postgres` if your setup for that)

-- p

Run:

-- code/

CREATE DATABASE your_database_name;

-- /code

-- p

The database is made from a clone of the `template1` database. So, any changes made there will show up in your new database.

-- p

NOTES:

-- p

You can check what permissions users have with `\du` when logged into the database


-- categories
-- Postgres 

-- metadata
-- date: 2021-11-25 21:55:01
-- id: 21re3er2
-- status: scratch
-- type: post
-- SCRUBBED_NEO: false
-- site: aws