Tagged Questions

0
votes
0answers
22 views

How to create concurrent databses, So that when one database is down other can work…? [migrated]

I have a local application running on LAN. Some times the system having database get shutdown. In such a scenario how to keep application working. Can i have two concurrent database. I am using ...
0
votes
1answer
21 views

postgres - how to choose last transactions per user_id, per transaction type?

i have the following table (raw_data): trans_id,user_id,msg_code,record_time given a time frame (from_time,to_time) i would like to query: get for each user: get the last msg_code of each type. ...
0
votes
1answer
29 views

Proper way to add forgeign keys in db?

So - I've been learning rails for the last 4 months and would like to think that I have a pretty good overview of it. Albeit, there are a few gray areas that I would like to make clearer. One being ...
0
votes
0answers
26 views

“FATAL: database does not exist” on postres, login is not working through app

I have these three steps bellow which I am executing every moment that I need to create a new environment for my app, the step 3 is just part of code... On the first step I create the database, ...
0
votes
1answer
33 views

Neo4j vs (Neo4j + Postgres)

I am developing an recommendation engine and was thinking of saving actual data (email, name, password, etc) in Postgres and saving relationship in Neo4j. But was wondering if this gives any advantage ...
-2
votes
1answer
21 views

cant delete data from postgresql

I'm quite new to PostgreSQL, so maybe I'm getting some noob error I cannot recognize, so please, tell me why I cannot get this data deleted. This is what is happening: DELETE FROM userprofile WHERE ...
0
votes
2answers
45 views

A better database model for holding postage prices

I wanted to create a Postage_costs table to hold postages costs, each postage_cost has a name, e.g Large Item, which has different costs(standard price and express postage price) depending on ...
0
votes
1answer
23 views

Postgres Bulk Data Import and Populate Associated Data

I have a Postgres database that gets updated from various external sources several times a day, and each record has fields like company_id and user_id that need to get looked up from an existing table ...
1
vote
3answers
36 views

DELETE FROM … reporting syntax error at or near “.”

I'm trying to delete just one data from my DB, but, when I write the command I keep getting that there's some syntax error, could you tell me where is the error? This are the commands I've tried: ...
1
vote
2answers
41 views

What is an Efficient Way to do an AND/OR Search Django-Postgres App?

In my Django app I have a Publication model and a Tag model which have a many to many relationship. Let's say I have four tags: men, women, fashion, design. I want to find all publications that have ...
2
votes
1answer
24 views

Database/query optimizer for Tomcat/Java application

Can anybody recommend the software to analyze/optimize existent queries in the Java/Tomcat application. About 70% of queries are generated by Hibernate. The database is PostgreSQL but I would like ...
-3
votes
0answers
15 views

Updation of pg_hba.conf of postgres database [closed]

I am using pgadmin III to access postgres sql. I want to access postgres from .net application this required client entry in pg_hba.conf. Does anyone know how to update this using pgadmin III utility. ...
2
votes
4answers
44 views

database sql replace statement update records

I have a lot of records in postgresql database sample table s_attrs attribute like sex = female, age = 32 years, disease = hepatitis B:DOID:2043 sex = male, age = 35 years, disease = hepatitis ...
0
votes
1answer
23 views

How to find specific data(field) in similar databases

We are using postgresql DB for our project. Each customer have their own database(all alike) i.e. We have common schemas for DB relations, for all these DBs. I would like to search a particular field ...
2
votes
1answer
36 views

Can't Save IDs from other tables into current table in database upon creation of an object Rails, Postgresql

I'm having problems getting multiple ids to save properly into my database. I have a listing that has two parameters: a listing id and a price. I've tried changing the controller to accept the ...

1 2 3 4 5 … 109
15 30 50 per page