Tagged Questions
0
votes
1answer
39 views
PostgreSQL cannot start after replacing contents inside its Data folder
When recovering the Postgresql database from a hacked Ubuntu 12.04 server, I copied the data directory to another location, reinstalled the OS and PostgreSQL, stopped PostgreSQL service, removed the ...
1
vote
4answers
61 views
How to change the data directory on Postgresql 9.1 on Ubuntu
I am having a problem changing the data directory on postgresql 9.1 on ubuntu 13.04:
I first did a:
sudo pg_dropcluster --stop 9.1 main
and then attempted to create a new one in the desired path:
...
0
votes
2answers
76 views
Trying to create PostGIS database
I am trying to create a spatially enabled PostGIS database. I am following the PostGIS documentation, http://postgis.refractions.net/documentation/manual-1.5/ch02.html#id2648455.
In the short ...
1
vote
1answer
44 views
clusterdb stopped working for PostgreSQL database in Ubuntu 12.04 server
After a fresh PostgreSQL install (version 9.2) on my Ubuntu server 12.04, clusterdb utility stopped working. I used the same config files as I used with version 9.1.
Below is the actual command:
...
2
votes
2answers
109 views
QGIS PostGIS Authentication Failure with “trust” option
I'm trying to setup a PostGIS db using PostGreSQL 9.1 on Ubuntu 12.04. I've set up the database, created a user account "jay" with no password, added spatial functionality following section 2.5 here, ...
0
votes
2answers
180 views
Postgresql - Segmentation fault (core dumped)
I'm working on postgresql code (server side).
I installed a version from source code following the official tutorial:
http://www.postgresql.org/docs/8.4/interactive/install-short.html
I did same ...
3
votes
2answers
792 views
Tool for Reverse Engineering of PostgreSQL Database on Linux (Ubuntu)
Please suggest a tool to reverse engineer a PostgreSQL DB into an entity-relationship-diagram (ERD) or equivalent ??
Ideally, I'm looking for a simple ERD or UML class diagram in a format that is ...
1
vote
2answers
415 views
Preventing PostgreSQL from starting on boot in Ubuntu
I am using PostgreSQL 9.2 and it runs automatically when I start the system (Kubuntu).
How can I avoid this?
I need to start it manually, and I don't want it to start unattended because I need to ...
0
votes
1answer
201 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 ...
1
vote
1answer
202 views
restore compressed dump query in postgresql asks password
I'm using ubuntu OS and I took backup using
sudo -u postgres pg_dump dbname | gzip > filename.gz
in the file path as...
/home/administrator/Documents/DB_Backup# sudo -u postgres pg_dump dbname ...
1
vote
3answers
446 views
Ubuntu: upgrading postgresql 8.4 database cluster for use with 9.2 server
I have installed PG 9.2 on my machine. I have a database cluster that was created about a year ago, using initdb, using postgreSQL version 8.4.
The (8.4) data cluster consumes several Gb and so its ...
5
votes
1answer
6k views
How to connect to an remote PostgreSQL database on Ubuntu using pgAdmin3?
I´m trying to setup an PostgreSQL database on an Ubuntu machine. I would like to be able to access it using pgAdmin3 from a remote machine. How do I setup this?
I have installed the PostgreSQL ...
4
votes
1answer
1k views
Install PostGIS v2 for PostgreSQL v9.2
I have installed the latest stable version of PostgreSQL v9.2 and I want to install the PostGIS v2 extension.
I've been searching for it for 3 days now, however can't find it.
I did however find ...
4
votes
2answers
821 views
Recover PostgreSQL database from WAL errors on startup?
I'm trying to set up an OpenStreetMap server on an Ubuntu 12.04 machine using the Ubuntu packages listed at switch2osm.org. I initially installed and set up everything using a Northeast US-only map ...
2
votes
2answers
85 views
Which option do I have to modify to see more records without press `q`
I'm connected remotly to my database server with cygwin in full screen.
When I query my database with
select id, name from table limit 27;
I get 27 records and I can do a new query seeing the ...
