1

[ubuntu] Davical database setup fails in Ubuntu 12.04

view story
linux-howto

http://ubuntuforums.org – Hi, After installing Davical and Postgresql (9.1) on Ubuntu 12.04, I tried to run the create-database script. First, the script fails because it cannot connect to the database (at this point it has already created the database and the two users). I did have the correct entries in pg_hba.conf and had restarted postgresql. After dropping the database users and database again, I modified the update-davical-database script to set the dbhost variable to 127.0.0.1 and allowed connections from localhost to Postgres (added "host all all 127.0.0.1/32 trust" to pg_hba.conf). Now t (Hardware)

colm's picture
Submitted by colm on 08/19/2012

Stories similar to [ubuntu] Davical database setup fails in Ubuntu 12.04

everyone,,i got stag when i configure my wifidog,,that is after step database acces.. i can't acces the localhost,,when i try to access the localhost, the result is like this :

I am unable to retrieve the schema version.

hallo everyone,,i have installed wifidog on my ubuntu,, i'm using ubuntu 11.04,, but when i'am configure wifidog i got errors on step database connection..this is the result after configure database acces :

Trying to open a Postgresql database connection : Unable to connect to database! Please make sure the server is online and the database "wifidog" exists.

I upgraded a server with a Rails application to Ubuntu 12.04 from 10.04 and cannot connect to Postgresql database now...

Here is the error message from Rails app:

could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"

Also the pg_ctl start is not recognized as a command.

EDIT:

Tur

Hi,

i encounter a problem upgrading Fedora from 17 to 18

i need to Upgrade Postgresql from 9.1 to 9.2

For doing so i run

postgresql-setup upgrade

with some trust in place of md5 in pg_hba.conf and .pgpass file with option PGPASSFILE in script postgresql-setup to connect easily to database

In /var/lib/pgsql/pg_upgrade.log ii get :

Performing Consistency Checks -----------------------------

Software center is broken 46 weeks 4 days ago

When I started installing the Humble Indie Bundle 5 games the software center stopped working and now I get this error.

Packages cannot be installed or removed, click here to repair. Which fails and gives these results.

installArchives() failed: (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ...

installArchives() failed: Selecting previously unselected package speedcrunch. (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ...

I need to take a Microsoft SQL Server database backup (dump) file and import/restore into a PostgreSQL database. Does anybody have some sort of transform script (maybe a perl/sed/awk script) that could be run on the MSSQL Server backup file, so that it could be restored to the PostgreSQL database? Let's assume the tables have already been created in postgres, but they are all empty.

I have 2 cluster databases, running on the same host, Ubuntu. My fist database port is set to default but my second database port is set to 5433 in the postgresql.conf file. While everything is ok with local connections, I cannot connect using any of my tools to the second database with port 5433, including pgAdmin. Please help.

I'm setting up my own postgres database to use with a heroku app (I don't wanna pay $200 a month just to have postgis, I don't need a huge database or anything, just postgis).