RPostgreSQL in OS X

RPostgreSQL_OSX.Rmd

## install

```{bash}
brew install postgres
```

## start

```{bash}
pg_ctl -D /usr/local/var/postgres -l logfile start
postgres -D /usr/local/var/postgres
createdb mydb
```

## initdb

```{bash}
psql mydb
create table users(id serial, name varchar(25));
insert into users(name) values('eric');
\quit
```

## RPostgreSQL

```{r}
dplyr::src_postgres(dbname = "mydb", port = "5432", host = "localhost")
```

## stop

pg_ctl -D /usr/local/var/postgres stop -s -m fast