Tagged Questions

0
votes
0answers
14 views

Cannot create PostgreSQL user [migrated]

I'm using PostrgreSQL 9.1.9 on Ubuntu 13.04. Using the following StackOverflow question, I tried to create a user/role in postgressql: ...
-1
votes
1answer
44 views

Resetting password of PostgreSQL on ubuntu [closed]

i am using Ubuntu.some days before i installed Postgresql database for ruby on rails.i created a superuser for database server and i forgot the password of postgresql superuser.can any one please help ...
2
votes
2answers
52 views

How to manage the wals dir on a PostgreSQL replication server?

I have two PostgreSQL 9 servers running on Amazon EC2. One is the master, the other is a replication server in standby. The replication server is continuing to fail as the hard drive fills up. It ...
1
vote
2answers
166 views

Get “latest” row after GROUP BY over multiple tables

I'd preferably like to first query listed below and just group by stories.id, but I get the following error: ERROR: column "u.first_name" must appear in the GROUP BY clause or be used in an ...
0
votes
1answer
142 views

Trying to get postres and postgis running in rails app

I am completely new to Postgresql, Postgis, and SQL and have a little bit of rails knowledge. I am trying to get an existing app going on my local and am currently receiving the following messages ...
4
votes
1answer
214 views

Can't run rake db:migrate a tsvector GIN index for Postgresql in Rails using Railscast sample

I'm following along on Ryan Bates' excellent tutorial on using the built-in PostgresQL full-text search in Rails. I'm currently using pg_search gem un-indexed no problem but I need to improve the ...
1
vote
1answer
410 views

Why is Rails dropping the Postgres connection on large bulk inserts?

I'm brand-spanking new to the world of linux and server administration, and I'm stuck. I have a rails app that occasionally needs to perform large data inserts, usually around 20,000 rows. The code ...
0
votes
0answers
171 views

Stuck on postgres batch update query

So I am experimenting with Postgres batch updates in my rails apps to speed up how a background calculation is run. I am getting really close, but there is just 1 error I just can't seem to fix. Here ...
6
votes
1answer
972 views

Error when creating unaccent extension on PostgreSQL

I am trying to configure PostgreSQL to use fulltext search in my rails app as mentioned in this Railscast. I am using a fresh Ubuntu 12.04 server running PostgreSQL 9.1.5 installed using apt-get with ...
3
votes
1answer
2k views

Postgresql date() with timezone

I'm having an issue selecting dates properly from Postgres - they are being stored in UTC, but not converting with the Date() function properly. Converting the timestamp to a date gives me the wrong ...
1
vote
1answer
105 views

Rails Model associations but different databases

I am building an app which uses a mysql and a postgres database. I'm using postgres because of postgis as this app is location based. Postgres only has one database Places whereas mysql contains all ...
3
votes
2answers
5k views

Rails: rake db:create:all fails to connect to PostgreSQL database

I am trying to create a Rails app that uses PostgreSQL. Here is a description of what I did. PostgreSQL setup: I installed PostgreSQL 9.1.3 via the ppa:pitti/postgresql maintained by Martin Pitt. ...