postgresql Archives - Page 20 of 21

Can’t find the ‘libpq-fe.h header when trying to install pg gem

I am using the Ruby on Rails 3.1 pre version. I like to use PostgreSQL, but the problem is installing the pg gem. ...

April 17, 2022
0 Comments

PostgreSQL error: Fatal: role “username” does not exist

I’m setting up my PostgreSQL 9.1. I can’t do anything with PostgreSQL: can’t createdb, can’t createuser; all operations return the error message Fatal: ...

April 17, 2022
0 Comments

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, ...

April 15, 2022
0 Comments

Save PL/pgSQL output from PostgreSQL to a CSV file

What is the easiest way to save PL/pgSQL output from a PostgreSQL database to a CSV file? I’m using PostgreSQL 8.4 with pgAdmin ...

April 15, 2022
0 Comments

How can I start PostgreSQL server on Mac OS X?

Final update: I had forgotten to run the initdb command. By running this command ps auxwww | grep postgres I see that postgres ...

April 14, 2022
0 Comments

Which version of PostgreSQL am I running?

I’m in a corporate environment (running Debian Linux) and didn’t install it myself. I access the databases using Navicat or phpPgAdmin (if that ...

April 14, 2022
0 Comments

How to switch databases in psql?

In MySQL, I used use database_name; What’s the psql equivalent? 1 15

April 13, 2022
0 Comments

How can I drop all the tables in a PostgreSQL database?

How can I drop all tables in PostgreSQL, working from the command line? I don’t want to drop the database itself, just all ...

April 13, 2022
0 Comments

How to change PostgreSQL user password?

How do I change the password for PostgreSQL user? 2 22 To log in without a password: sudo -u user_name psql db_name To ...

April 13, 2022
0 Comments