Tagged Questions
3
votes
1answer
168 views
timelines and history files postgresql 9.1
Can someone explain me the purpose of timelines and history files and the setting 'recovery_target_timeline' in recovery.conf.
The vague understanding I got from the postgresql 9.1 documentation is ...
2
votes
1answer
116 views
Very slow query when matching text field is not empty string
I have a very simple query that is essentially this:
Select * from my_table Where my_field != '';
There are about 40,000 rows in the table and the "my_field" column is a text field (varchar 255)
...
1
vote
1answer
58 views
slow update script in postgres
I have a text file with 850000 individual update statements, updating a table containing 12 million records. An example of such a query is:
update bag.pand
set mutatiedatum = to_date('04-03-2013 ...
1
vote
1answer
41 views
How can use custom_variable_class
i am create custom_variable_class= myapp in postgresql.conf. And set the value is inside of function like
CREATE OR REPLACE FUNCTION fn_purchase(xmode text, xuserno integer)
RETURNS text AS
set ...
1
vote
1answer
2k views
incorrect checksum in control file error for postgres 9.1.3 data created in osx-Lion and accessed in osx-snow-leopard
I get the following error when trying to start postgres using the data created in another mac machine.
FATAL: incorrect checksum in control file
The postgres version is 9.1.3 and the data ...
0
votes
1answer
25 views
Restore Particular tables in one schema to another schema postgresql
In my case, i have backup file in full database. Now I want to restore some particulars tables in public schema.
Those tables are already stored in another schema. Any Feasible solution is there? ...
0
votes
1answer
46 views
Creating a Unique PostgreSQL Index that Contains Operations
I would like to create a unique PostgreSQL index that contains operations. Does anyone know if this is possible?
CREATE UNIQUE INDEX ux_data ON table (name, color)
The operation that I would like ...
0
votes
1answer
146 views
converting image to byte array and store in postgresql using function
In my case , I want store image to database(postgresql) using storeprocedure. my database is in server.
I am converting the image into byte array in front end. Now i need to know How to pass the ...
0
votes
1answer
84 views
Importing of a PostgreSQL DB on Ubuntu Server
So I am reallly new to PostgreSQL and for the last 3 days I am stuck with this. I need to import a PostgreSQL Database. The database lies in a folder and has various .tab files.
I have PostgreSQL 9.1 ...
0
votes
1answer
131 views
Integration of postgreSQL on WAMP
I have just installed the postgreSQL on windows 7. I am trying to integrate postgreSQL with WAMP server.
For this i have done the following changes in httpd.conf and php.ini file
1 LoadModule ...
0
votes
1answer
117 views
Why does ON DELETE CASCADE sometimes take long on Postgres 9?
I have a few relations between tables that are all related to one 'owner' table. So just for the sake of the example:
Table Owner with PK id
Table Parent with PK id and FK owner_id referring to ...
0
votes
1answer
147 views
Failover clustering for PostgreSQL on Windows Servers
We are planning to use PostgreSQL for one our project.
We would like to know if there is a high availability solution for PostgreSQL that can be implemented on Windows machines using Windows ...
0
votes
1answer
84 views
MacOS: have somehow ended up with two versions of postgres, which should I use?
I've installed postgres from MacPorts, on MacOS Lion. I'm now rather confused about what to do next, as I can't find one clear set of documentation about setup.
I have ended up with two versions of ...
0
votes
1answer
182 views
ActiveRecord with Postgres: Has Many Through and Indexing
Let's say you have three models:
class Collection < ActiveRecord::Base
has_many :comments, through => :users
end
class User < ActiveRecord::Base
belongs_to :collection
has_many ...
0
votes
0answers
8 views
Failure with syncdb --migrate on PostgreSQL database. Circular Dependency
I'm trying to create an empty copy of my Django database using the command
manage.py syncdb --migrate --database=<db_copy_name>
It works fine if the database is a sqlite3 database, but fails ...
