pg_restore toc error
i was using the following syntax for pg_dump and restore pg_dump eval --inserts -b -c --encoding UTF8 -Fc -f eval.sql.tar.gz -x -U postgres createdb -T template0 test -U postgres pg_restore -d test eval.sql.tar.gz -e -U postgres the dump was successfull with no errors, but restore makes a some errors, i am dumping and restoring in same machine with same user and privilege all... i have tried out w
Getting error: Peer authentication failed for user "postgres", when trying to get pgsql working with rails
I'm getting the error: FATAL: Peer authentication failed for user "postgres" when I try to make postgres work with Rails. Here's my pg_hba.conf, my database.yml, and a dump of the full trace. I changed authentication to md5 in pg_hba and tried different things, but none seem to work. I also tried creating a new user and database as per Rails 3.2, FATAL: Peer authentication failed for user (PG::Err
Default datetime with Ecto & Elixir
I've just started working Elixir & Phoenix today, i am trying to add Ecto as a mapper, but i'm having some trouble using time. This is my model. schema "users" do field :name, :string field :email, :string field :created_at, :datetime, default: Ecto.DateTime.local field :updated_at, :datetime, default: Ecto.DateTime.local end I'm trying to set the created_at and updated_at per default, but when i
PG::ConnectionBad - could not connect to server: Connection refused
Every time I run my rails 4.0 server, I get this output. Started GET "/" for 127.0.0.1 at 2013-11-06 23:56:36 -0500 PG::ConnectionBad - could not connect to server: Connection refused Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432? could not connect to server: Connection refused Is the server running on host "localhost" (127.0.0.1) and accepting TCP/I
1
リリース、障害情報などのサービスのお知らせ
最新の人気エントリーの配信
処理を実行中です
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く
Retrieving Comments from a PostgreSQL DB
How to list all tables in psql?
How to store array with Ecto using Postgres
Postgrex - No pg_hba.conf entry for host "xxx.xxx.xxx.xxx"
How can I change a PostgreSQL user password?
Import SQL dump into PostgreSQL database
Migrate database from Postgres to MySQL
PG::Error: ERROR: new encoding (UTF8) is incompatible
