postgres - Today I learned

Don't forget to update the sequence in PostgreSQL after a COPY command

You might have noticed that after bulk inserting records using the COPY statement in PostgreSQL the sequence IDs are not getting updated for any further inserts later on, and it would throw duplicate sequence ID errors. So you would be wondering what makes this COPY statement different that it does

ruby

Connecting Ruby & Active Record Without Rails

require 'active_record' require 'mysql2' # or 'pg' or 'sqlite3' # Change the following to reflect your database settings ActiveRecord::Base.establish_connection( adapter: 'mysql2', # or 'postgresql' or 'sqlite3' host: 'localhost', database: 'your_database', username: 'your_username', password: 'your_password' ) # Define your classes based on the database, as always class YourModel <

postgres

Postgresql: How to find pg_hba.conf file using Mac OS X

To find the postgresql config file we can use the locate command. Type the following in your terminal: locate pg_hba.conf Or else: If you have a postgres server running on your machine, you can find the config directory using the following command ps aux | grep postgres which would

postgres

Dump PostgreSQL without owner and privileges

If you ever wanted to dump your postgres development database without the owner and the privileges, then you just need to run the following command: pg_dump database_name -O -x > output_file

postgres

Postgres could not connect to server

$ psql psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? The reason for the issue is because a pid file was blocking postgres from starting up. To fix it: rm