Tagged Questions
0
votes
1answer
74 views
createdb: could not connect to database postgres: FATAL: could not write init file
RedHat Enterprise Server 3.0 32 Bits
psql (PostgreSQL) 8.2.3
user: postgres
server is running:
/soft/postgres/8.2.3/bin/pg_ctl start
pg_ctl: another server may be running; trying to start server ...
2
votes
1answer
76 views
PostgreSQL CREATE EXTENSION file not found error on Mac OS
On PostgreSQL 9.2.3 when trying this:
CREATE EXTENSION btree_gist;
I get this error:
ERROR: could not open extension control file "/opt/local/share/postgresql92/extension/btree_gist.control": ...
2
votes
1answer
115 views
PostgreSQL EXCLUDE USING error: Data type integer has no default operator class
In PostgreSQL 9.2.3 I am trying to create this simplified table:
CREATE TABLE test (
user_id INTEGER,
startend TSTZRANGE,
EXCLUDE USING gist (user_id WITH =, startend WITH &&)
);
...
1
vote
1answer
37 views
Postgres Automated Install
Is it possible to automatically create a database after a postgres one click install (from Enterprise DB)?
0
votes
1answer
216 views
libreadline.so.6
when I was installing PostgreSQL from source code I had to install the libreadline.so.6 library.
From that moment I can't update my kubuntu system.
The error is:
Setting up ubuntu-keyring ...
0
votes
1answer
310 views
pgAgent installation with Stack Builder in PostgreSQL [closed]
I have installed PostgreSQL 9.1 on ubuntu 12.04 64-bit. I try to run Aplication Stack Builder and install pgAgent.
At first I am asked for root password, which I provide, after I choose PostgreSQL ...
3
votes
2answers
7k views
How to run psql on Mac OS X?
I installed PostgreSQL on a computer with Mac OS X using the One click installer. Then I try to access PostgreSQL using the psql command, but it doesn't seem to be available.
I get this message:
...
9
votes
2answers
8k views
How do I install pgcrypto for PostgreSQL in Ubuntu Server?
I'm using Ubuntu Server 10.10 and I have installed PostgreSQL 8.4 using apt-get install postgresql. I would like to use the built-in sha1() function, but it seems that I have to install pgcrypto ...
