0
votes
1answer
30 views

postgres creating new user/role

I am following this tutorial, and being logged in as postgres I run: createuser --interactive provided name and choosen superuser then: createdb dogspot but when trying sudo -i -u dogspot I get: ...
0
votes
1answer
129 views

Creating user with password or changing password doesn't work in PostgresQL

I'm trying to create a new user role or change existing one's password to be able to work locally with PostgresQL. I'm working on Ubuntu. I can modify the attributes of an user, but for some reason ...
0
votes
1answer
61 views

Postgresql starup script for second instance?

I need to run my second postgresql instance when linux boots. I added this command (like in postgresql documentation) in rc.local: /usr/lib/postgresql/9.1/bin/pg_ctl start -l logfile -D ...
1
vote
0answers
207 views

Installing and running two postgresql versions on different ports (or two instances of same server)

I have postgresql 9.1 installed on my machine (Ubuntu). I need another postgresql server that would run next to the old one. Exact version does not matter, but I'm thinking of using 9.2 version. How ...
0
votes
1answer
151 views

PostgreSQL does not start in ubuntu, says could not bind IPv4 Socket

I installed latest version of PostgreSQL. I tried to start with this command, bin/pg_ctl start -D testDB I got the following error message. LOG: could not bind IPv4 socket: Address already in ...
1
vote
1answer
122 views

How can I make my Upstart service depend on PostgreSQL?

I have a service configured as an upstart job. How do I make sure that PostgreSQL is running before my service is started? Ubuntu 14.04 here.
0
votes
1answer
268 views

How to configure PostgreSQL for best access from both Windows 7 host and Ubuntu 12.04 guest?

I have a new Ubuntu 12.04 installation freshly installed on VirtualBox, which in turn is running on a 64 bit Windows 7 machine with plenty of RAM. I would like to install PostgreSQL on this system in ...
0
votes
1answer
3k views

ubuntu 13,10 “Failed to download repository information”

I have ubuntu 13.10- 64 bit version on my machine.recently i tried to install postgres for ROR development but i couldn't complete the postgres installation and found that my update manager always ...
2
votes
2answers
65 views

2 instances of postgresql but I really need one

I happen to have 2 installed instances of postgresql at my machine: 9.1 and 9.2: sudo service postgresql status 9.1/main (port 5432): down 9.2/main (port 5433): down They are located at ...
0
votes
0answers
52 views

How to increase IO for operation “SELECT”?

I use windows server 2008r2 with role Hyper-V. The guest system is Ubuntu 12.04 LTC (64 bit). It is situated on the dynamic virtual hard disk /dev/sda. There is postgresql-9.1 (amd64) on the Ubuntu ...
1
vote
0answers
266 views

Ubuntu login screen doesn't show up after installing postgresql

I just installed Ubuntu 12.04 on my new machine and everything works fine. However, when I install postgresql and shut down the computer, when I log back in, there's no graphical login screen. The ...
5
votes
3answers
7k views

Install postgresql 9.3 on ubuntu 12.04

I am attempting to install PG 9.3 on Ubuntu 12.04 ---- Begin output of apt-get -q -y install postgresql-client-9.3=9.3~beta1-1.pgdg12.4+2 ---- STDOUT: Reading package lists... Building dependency ...
1
vote
1answer
457 views

apt-get fails at everything in Ubuntu due to postgresql error - how to fix?

I've got a server with zoneminder, mysql, ffserver and some ffmpeg instances running on it, but for some reason everything seems to be tied to PostgreSQL. I noticed an error when loading the ...
3
votes
1answer
376 views

Ubuntu postgresql missing man pages, PGDATA, and critical commands

I installed postgresql as well as postgresql-doc, nevertheless it seems that ubuntu either does not put commands in my path, or if it does put them in my path, it removes the man pages for the ...
0
votes
2answers
8k views

Setting up PostgreSQL gives error sudo: initdb: command not found

Step 1: I installed PostgreSQL using sudo apt-get install postgresql-9.1 as recommended on the PostgreSQL website Step 2: I tried to run postgres. It's not found. For whatever reason, the install ...
3
votes
1answer
3k views

Postgresql has broken apt-get on Ubuntu

On ubuntu 12.04, whenever I try to install a package using apt-get I'm greeted by: The following packages have unmet dependencies: postgresql-9.1 : Depends: postgresql-client-9.1 but it is not going ...
2
votes
1answer
814 views

Cannot start Postgres daemon after installing with Yum

I was trying to install Postgres 9.1.4 on Fedora 17 using Yum. If I do: sudo yum install postgres-libs sudo yum install postgres sudo yum install postgis All the installs appear to complete ...
1
vote
1answer
3k views

How to change root password for PostgreSql phpPgAdmin?

What is the simplest way to change root password for PostgreSql phpPgAdmin ?
1
vote
1answer
1k views

Shared memory in chroot environment

I'm playing with Ubuntu 11.10 launched in a chroot environment under Android 3.2.1. Most of the software works fine except PostgreSQL. When installed or initdb launched it's saying: FATAL: could ...
3
votes
1answer
903 views

ubuntu: root password

Well, I don't know exactly how it happened. But, thing is if I issue a command which I need root priviliges an error message comes that says <user> does not have an entry in sudoers file I ...
0
votes
2answers
3k views

How to change psql default listening host?

I've installed postgresql 8.3 manually on ubuntu 10.10, using ./configure, make and make install. It works perfect but when I try to connect it using psql I need to type following cmd, psql --port ...
0
votes
1answer
523 views

Person hacked server using postgres user account - What kind of access would this person have?

someone hacked one of my servers using postgres user account. what I do not know is: what is this users home folder? where would bash_history be?
2
votes
2answers
704 views

Help installing postgres in ubuntu

I'm trying to install postgresql in the latest ubunutu, and I'm following these instructions. When I sudo -u postgres psql postgres I get this error: could not change directory to "/home/james" I'd ...
0
votes
1answer
166 views

How do I create a postgresql user and database from a fresh install?

I just installed postgresql onto an ubuntu box. How can I create user foo with password bar and database baz, so that foo owns baz? foo is not a unix user.
1
vote
3answers
653 views

Postgresql by network

I have running PostgreSQL sever on 192.168.0.102:5432. postgresql.conf has this line: listen_addresses = '*' and pg_hba.conf has this one: host all all 127.0.0.1/32 ...
3
votes
1answer
4k views

How to make PostgreSQL start at boot time in Ubuntu?

Every time I boot my computer, I need to start Posgtres manually via sudo /etc/init.d/postgresql-8.4 start It was an easy task to make it start automatically with Init in place: just add a symlink ...
0
votes
2answers
1k views

Where can I find postgresql-8.4-postgis.deb? [closed]

I want the deb package.