Super User Stack Exchange
Super User Stack Exchange

Questions tagged [postgresql]

PostgreSQL is a community developed, open source, relational database, made available under a BSD-like license. The PostgreSQL documentation is expansive and incredibly useful.

PostgreSQL is the open source database started at UC-Berkeley back in 1986 as Postgres project. Today, PostgreSQL is an enterprise class RDBMS, one of the most powerful database engines available.

Strengths of PostgreSQL are high scalability and fault-tolerance. PostgreSQL is ACID compliant and conforms to the ANSI-SQL:2008 standard.

PostgreSQL includes the ability to use various programming languages including PERL, Python, R, and many others. It also allows several additional modules to add features and capabilities.

PostgreSQL is available under a liberal open source license. From the project website:

[The] license gives you the freedom to use, modify and distribute PostgreSQL in any form you like, open or closed source. Any modifications, enhancements, or changes you make are yours to do with as you please.

Typical Questions include:

Links:

For more information see the PostgreSQL homepage.
PostgreSQL Community
PostgreSQL Support

551 questions
27
votes
1 answer

User permissions for creating PostgreSQL DB

I'm working on Ubuntu. Following is one of my commands. $ psql -U kuser -d postgres Then this connects to the database. But from postgres terminal when i try postgres=> CREATE DATABASE kdb; ERROR: permission denied to create database When I try a…
dinesh707
  • 395
  • 1
  • 3
  • 5
18
votes
2 answers

Calling the psql command without selecting any database

The syntax of the psql command line client is psql [option...] [dbname [username]] I am passing the command ALTER DATABASE x RENAME to y to this command: echo `ALTER DATABASE x RENAME to y` | psql Currently I am getting the error psql: FATAL: …
Alex
  • 1,407
  • 3
  • 20
  • 31
15
votes
10 answers

Default password for postgreSQL

What is the default password for the "postgres" user when I install postgreSQL on Windows? I googled for "postgres default password" but it doesn't return any immediate result.
Chin
  • 7,923
13
votes
4 answers

Can not connect to pgAdmin server

I installed PostgreSQL on Windows 10 and the server appears to be in Task Manager. However, I get this error when opening pgAdmin4: Failed to connect to the pgAdmin application server. Click here to try again. Any ideas for what the problem is?
Ben Dent
  • 131
12
votes
1 answer

Is the order of columns significant in a Postgresql Primary key definition?

Postgresql allows you to define a primary key using a group of columns instead of one if desired, like so: PRIMARY KEY(a_id, b_id) But is the order of the columns in this definition significant? Is there any practical or actual difference between…
Radmilla Mustafa
  • 305
11
votes
2 answers

postgres ident authentication failed

I'm trying to set up django on a fresh Ubuntu VM. I'm following the tutorials along until I get to this: psycopg2.OperationalError: FATAL: Ident authentication failed for user "postgres" The Ubuntu user "postgres" has had its password set to…
user9141
10
votes
2 answers

List of StopWords in Postgres 9.1

What is the list of stop words (ignored words) used by Postgres when doing fulltext searches? Is there a way I can find this out (by running a query or something)? So you know what I'm looking for, here is the list from MySQL. I'm guessing the…
Peter Meth
  • 305
  • 2
  • 8
7
votes
1 answer

pgcrypto extension is installed but its functions are not available

On clients server I had a problem - I did not have permissions to create extension pgcrypto. So server admin did it for me, and now I can see in pg_available_extensions that pgcrypto is installed (1.1), however its functions are not available for…
user606521
  • 267
6
votes
3 answers

How do I know if my Postgres table is clustered?

I have some tables in my Postgres database, and I have set the tables to cluster about an index. But I forget when was the last time I ran cluster maintenance on these tables, and I do not want to waste my time to run cluster on them. How do I know…
David S.
  • 926
5
votes
1 answer

Where do I set idle_in_transaction_session_timeout in postgresql?

I want to close idle connection in postgresql and want to set idle_in_transaction_session_timeout. I log into postgresql and when entering show idle_in_transaction_session_timeout at prompt get the following error message: [database]=> show…
M Garcia
  • 151
4
votes
2 answers

Change postgreSQL database user from windows user in CMD

i recently installed PostgreSQL on windows 7, each time i try to use CMD to execute SQL command, i get this error createdb: could not connect to database template1: FATAL: password authentication failed for user "R-61" Where R-61 is my windows…
W3Guy
  • 163
4
votes
1 answer

pg_hba.conf lines 127.0.0.1 and ::1/128?

What is the meaning of these 2 lines in my pg_hba.conf? I am guessing the first is to allow local connections, but what about the 2nd? host all all 127.0.0.1/32 trust host all all …
Henley Wing
  • 69
3
votes
2 answers

PostgreSQL - syntax error

What is wrong with the following statement? GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO foo; I get this error ERROR: syntax error at or near "ALL" LINE 2: ON ALL TABLES IN SCHEMA public TO foo; I am using postgreSQL 8.3…
dhilipsiva
  • 133
3
votes
2 answers

change the UI lang when using postgresql psql.exe

I have a PostgreSQL 8.4 database, installed with Japanese as the main language. I am connecting from an English Windows 7 client using psql.exe. Is there any way to change the UI of the messages shown to me (e.g. the help, column headers from the \l…
brofield
  • 201
2
votes
3 answers

Postgresql connection refused

I'm trying to remotely connect to my postgresql database. I have two virtual machines set up both running ubuntu 14.04. I am trying to connect to the second vm using the first vm using psql -h 10.0.1.23 -U postgres -d postgres But I receive the…
Jonathan
  • 91
1
2 3 4 5