Tagged Questions
1
vote
1answer
19 views
Error: Could not read Block X of relation base/Y/Z
We have some serious issues with our PostgreSQL-Server (Version 8.4). Our webapplication uses jdbc to connect to the PostgreSQL Server. Suddenly our webapplication cant connect to the PostgreSQL ...
0
votes
1answer
19 views
looking for a postgresql load emulation client
Is there any load emulation client for postgresql like mysqlslap? And is there any good monitoring tool for postgresql database server?
Thanks
0
votes
2answers
52 views
Run query faster, what index to use
I have a table with 85M rows :
CREATE TABLE emissions_totales (
"schema_source" varchar(150),
"snap" varchar(20),
"gid" varchar(255),
"polluant" varchar(50),
"emi" float8,
"numreg" varchar(3),
...
0
votes
0answers
46 views
Server doesn't listen
I try in Win7 by means of PGAdmin 3 to be connected to a host 192.168.1.8 with the virtual machine with linux. Already which time I receive the message
Server doesn't listen
The server doesn't accept ...
0
votes
0answers
65 views
Writing with multiple psql processes to database seems to damage data
I have a couple terabytes of CSV data that I am trying to import into a PostgreSQL 8.4 database (on a RedHat 6.2 server), whose data directory is initialized on a multipath hardware RAID. There are ...
2
votes
2answers
58 views
Creating sequence for longer numeric values
I need to create a database model that includes a field to store 20 digit unique values. Which will be used by many clients over an API.
The value must be 20 digit long, numeric and unique. Best ...
4
votes
2answers
128 views
Custom unique column constraint, only enforced if one column has a specific value
Is it possible to have a custom unique column constraint as follows? Suppose I have two cols, subset and type, both strings (though the data types probably doesn't matter).
If type is "true", then ...
1
vote
0answers
122 views
Remote connection to PostgresSQL in Windows 2008 Server is prompting the error below [closed]
The error:
Unable to read data from the transport connection. an existing connection was forcibly closed by the remote host.
The conditions:
I have the following connection string:
server = ...
2
votes
2answers
72 views
String handling in postgres 8.4
This started as a question about indexes, but then when I got my answer I realized I would have to try and convert the answer into 8.4 syntax (I can't believe that format does not exist).
I thought I ...
3
votes
1answer
118 views
PostgreSQL 8.4: How to tell if a procedural language is installed or not?
I have a setup program that requires plpgsql to install stored procedures in a PostgreSQL 8.4 database. I need to make sure the language is installed or the app will fail. I don't want to drop the ...
1
vote
0answers
116 views
Connecting a GUI to the user-created function in PostgreSQL [closed]
I have been given a task to create profiles for the applications. The Database that we use is Postgresql. I've defined some function that will give me those profile and I've added them to the ...
4
votes
1answer
77 views
Safe way to stop/abort REINDEX
I am running a REINDEX but it takes long time and still working. The application using the DB is not responding right now. Is there a safe way to stop it and do it another time?
PostgreSQL version is ...
0
votes
1answer
94 views
PostgreSQL 8.4 no levenshtein fuzzymatching?
I'm using debian squeeze package, it says function does not exist?
