blrhc

postgres         1331   0.1  0.0  2618668   4132   ??  Ss    7:58pm   0:00.07 postgres: checkpointer process    
postgres         1335   0.0  0.0  2474352    804   ??  Ss    7:58pm   0:00.09 postgres: stats collector process    
postgres         1334   0.0  0.0  2618800   2432   ??  Ss    7:58pm   0:00.03 postgres: autovacuum launcher process    
postgres         1333   0.0  0.0  2618668    764   ??  Ss    7:58pm   0:00.02 postgres: wal writer process    
postgres         1332   0.0  0.0  2618668   1620   ??  Ss    7:58pm   0:00.06 postgres: writer process    
postgres         1329   0.0  0.0  2465136    552   ??  Ss    7:58pm   0:00.00 postgres: logger process    
postgres         1328   0.0  0.2  2618668  14412 s000  S     7:58pm   0:00.05 /Library/PostgreSQL/9.3/bin/postgres -D/Library/PostgreSQL/9.3/data
postgres          459   0.0  0.0  2469216   1512   ??  S     4:28pm   0:00.23 /System/Library/Frameworks/CoreServices.framework/Frameworks/Metadata.framework/Versions/A/Support/mdflagwriter
postgres      

blrhc

Bens-MacBook-Pro1-6:gratipay.com benhc$ make schema data
env/bin/honcho -e defaults.env,local.env run ./recreate-schema.sh
==============================================================================
Recreating public schema ... 
NOTICE:  drop cascades to 23 other objects
DETAIL:  drop cascades to type participant_number
drop cascades to type email_address_with_confirmation
drop cascades to table participants
drop cascades to table elsewhere
drop cascades to table tips

blrhc

Last login: Fri Nov 14 19:45:23 on ttys000
Bens-MacBook-Pro1-6:~ benhc$ open  /Library/PostgreSQL/9.3/data/pg_hba.conf
The file /Library/PostgreSQL/9.3/data/pg_hba.conf does not exist.
Bens-MacBook-Pro1-6:~ benhc$ open -e /Library/PostgreSQL/9.3/data/pg_hba.con
The file /Library/PostgreSQL/9.3/data/pg_hba.con does not exist.
Bens-MacBook-Pro1-6:~ benhc$ sudo -u postgres open -a TextEdit /Library/PostgreSQL/9.3/data/pg_hba.conf
Bens-MacBook-Pro1-6:~ benhc$ sudo -u postgres open -a TextEdit /Library/PostgreSQL/9.3/data/pg_hba.conf
Bens-MacBook-Pro1-6:~ benhc$ cd gratipay.com
Bens-MacBook-Pro1-6:gratipay.com benhc$ createdb gratipay
Password: 

blrhc

# PostgreSQL Client Authentication Configuration File
# ===================================================
#
# Refer to the "Client Authentication" section in the PostgreSQL
# documentation for a complete description of this file.  A short
# synopsis follows.
#
# This file controls: which hosts are allowed to connect, how clients
# are authenticated, which PostgreSQL user names they can use, which
# databases they can access.  Records take one of these forms:

blrhc

# PostgreSQL Client Authentication Configuration File
# ===================================================
#
# Refer to the "Client Authentication" section in the PostgreSQL
# documentation for a complete description of this file.  A short
# synopsis follows.
#
# This file controls: which hosts are allowed to connect, how clients
# are authenticated, which PostgreSQL user names they can use, which
@                                     

blrhc

Bens-MacBook-Pro1-6:~ benhc$ ps auxww | grep -i postgres
postgres          459   0.0  0.0  2469216   1512   ??  S     4:28pm   0:00.17 /System/Library/Frameworks/CoreServices.framework/Frameworks/Metadata.framework/Versions/A/Support/mdflagwriter
postgres          439   0.0  0.0  2469224   1228   ??  S     4:25pm   0:00.08 /usr/sbin/cfprefsd agent
postgres          156   0.0  0.0  2473328    760   ??  Ss    4:22pm   0:00.26 postgres: stats collector process    
postgres          155   0.0  0.0  2618800   2260   ??  Ss    4:22pm   0:00.14 postgres: autovacuum launcher process    
postgres          154   0.0  0.0  2601260    760   ??  Ss    4:22pm   0:00.13 postgres: wal writer process    
postgres          153   0.0  0.0  2601260   1612   ??  Ss    4:22pm   0:00.17 postgres: writer process    
postgres          152   0.0  0.0  2609452   2036   ??  Ss    4:22pm   0:00.01 postgres: checkpointer process    
postgres          150   0.0  0.0  2456944    552   ??  Ss    4:22pm   0:00.00 postgres: logger process    

blrhc

Last login: Fri Nov 14 18:30:23 on ttys001
Bens-MacBook-Pro1-6:~ benhc$ sudo -u postgres createuser --superuser $USER
Password:
Password: 
Bens-MacBook-Pro1-6:~ benhc$ createdb gratipay
Password: 
Password: 
createdb: could not connect to database template1: FATAL:  password authentication failed for user "benhc"
Bens-MacBook-Pro1-6:~ benhc$ cd gratipay.com
Bens-MacBook-Pro1-6:gratipay.com benhc$ createdb gratipay

blrhc

b

blrhc

asdasd

blrhc

asd