PostgreSQL Database Forum

Trying to import postgresql file around 8GB using pg_restore but it's outputting an error message: pg_restore -d testdb -U postgres -C helium-20141009.sql pg_restore: input file does not appear to be a valid archive

Hi I'm using postgreSQL 9.3 and I have the following two types of stored procedures (only the statements given): INSERT INTO table1 (col1, col2, col3, col4, col5) SELECT $1, $2, $3, $4, $5 WHERE EXISTS (SELECT id FROM table2 q WHERE q.id = $1) RETURNING table1.id; DELETE FROM table1 m WHERE m.id = ( SELECT m.id FROM table1 m

I have a simple table with a primary id column called id. I have a need to ALTER the table and delete the primary id column. When I do the first 6 rows are reordered to the bottom of the table. I do not want them to be reordered. Any thoughts? Thanks in advance.

I have a Postgresql table with the following structure: id | value ----+-------- 1 | 1 2 | 2 3 | 3 4 | 4 5 | 1 6 | 2

I have a table with 12 million records. There are indexes on columns col_1 and col_2. I use postgresql 9.3. I need two types of queries on it. First, some queries with just one condition in where clause, such as: select count(*) from table_1 where col_1 >= 123456; **explain analyze:**

I am running a SQL Script called from a batch file to build a temp database from a flat file. It works when the flat is on the C: drive but not on a net work drive I get this error: ERROR: could not open file "\\ESSOMAFPS5\Pollbook\Data\STREET_DATA.txt" for reading: Invalid argument Here is the copy statement... I am using the \\ UNC...

I am trying to start Postgresql 8.2.13 in Windows Server 2008 machine but is not starting..Service is getting timed out.. No specific error in the Aplication log in event viwer.. It was previusly running .. But after a server restart this was happening.. Is there any way I can recover the data? The pg_log says 2014-08-21 17:13:30...

Hi dear members, I am new postgresSQL, still trying to get the knowledge. As per client requirement I need to migrate postgres DB to new server, but I am having trouble doing that and couldn’t find any help, Following are the summery what I am facing and some details I have gathered, 1. Old psql (PostgreSQL) 7.4.5 , OS - SUN 5.9 2. New...

I have a problem with postgresql when i go to make a new database is give me this error ERROR: source database "postgis" is being accessed by other users DETAIL : there is 1 other session using the database

Settings in master server: max_wal_senders = 1 wal_level = 'archive' archive_mode = on archive_command = 'cd .' wal_keep_segments = 10000 Settings in slave server: in recovery.conf file: Standby_mode = 'on'

HI ALL, we have deployed PEM server in our environment and added agents to this server. Now we are planning to configure alert mail notifications from PEM server. Kindly let me know the steps to be followed for this. Thanks, Varun

i have created a postgresql 9.1 database on a windows 7 OS. now i want to access it via another windows 7 OS pc using pgadminIII.On the client pc i have also installed pgadminIII as a client application for the database and when i am trying to add a new server using pgadminIII, after filling in the server name, hostname, username and password i...

I am running PostgreSQL 8.3 and I have a corrupt row that is stopping me from seeing my data in file. How do I help this?

Hi I am not able to compile the procedure in postgresql. I am getting syntax error when compiling the below PROCEDURE CREATE OR REPLACE PROCEDURE populate_data_to_table(tableName IN text,employeecolumn IN text, status OUT integer) AS Declare table_data RECORD; employeeCnt INTEGER; employeeinsert INTEGER;

What is Transparent Huge Pages parameter, and how can it affect my servers performance?

Hey guy ever night it seems our DBs is locking up or like this morning crashing and restarts. Today is just my 4th day on the job, they have an offshore team that currently handles all their DBA and db work currently. I was brought on because they will be moving to a SQL Server environment soon and just kind of wanted me to work with these guys...

First thanks to mono team, this innovation fullfill my deplyment requirements, I developped project using VS2005 Framework 2.0 and Sqlite seems to work perfectly in windows and Linux debian. My aim is to subsitute SQLite with Postgresql and then the hell starts. Here is the steps pursued: 1. Download the mono 3.2.3 last release 1....

I'm using PostgreSQL 9.2.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20070115 (SUSE Linux), 64-bit. I set up streaming replication for a read/write primary and a read/only standby. The replication works fine for a while, and then out of the blue BOTH machines become read/write, but with no replication from the original primary...

I use PHP to do database with Postresql. On PHP, I would like to get message from Raise notice/exception on Postgresql procedure. It's used to work fine. After some Postgresql, Aapache and PHP upgrade. Now it won't work. That means on PHP, I cannot get any of them and just a server timeout message. I can find all of then are in postgresql log...

Hi i trying to use Postgre SQL and i`m on studying i`m using windows7 and pgAdmin3 i want try change my data folder

Do we have any available testing tool and benchmarking tool for postgreSQL database other than "pgbench" and "HammerDB" which don't require any license fee. Please reply asap.

What is a local buffer? Google returns code, but not an explanation. Also, is local buffer cache related to local buffer? can you give any example to clarify the above? Please assist. thanks in advance! :)

I want retrieve columns x,y,z. Where x and y are in both tables A and B but z is only in table B. Any ideas? I keep getting x and y are ambiguous.

Hi All, My requirement is to fetch the previous day records.Iam joining three tables hereby.I used the below queries,but the DB2 cost seems to be high.Is there any simpler way to reduce the db2 cost and optimize the query further? Query: ----- Iam selecting around ten fields and below is my where condition, Query:1 --------

Hi all :-) how i can scan the NEW or OLD record that postgres create when a trigger start? i want the value and the name of the key of the OLD/NEW record (because i don't know the table tha fire the trigger). i have think to scan pa_attribute with the name of the table and save it the variable col pg_attribute.attname%TYPE after i loop...