Re: [GENERAL] Backing up through a database connection (not pg_dump)

At 01:05 27/03/2012, Tim Uckun wrote: Is there a way to backup a database or a cluster though a database connection? I mean I want to write some code that connects to the database remotely and then issues a backup command like it would issue any other SQL command. I realize the backups would nee

Re: [GENERAL] Backing up through a database connection (not pg_dump)

On Tue, Mar 27, 2012 at 12:05:00PM +1300, Tim Uckun wrote: > Is there a way to backup a database or a cluster though a database > connection? I mean I want to write some code that connects to the > database remotely and then issues a backup command like it would issue > any other SQL command. I re

[GENERAL] Problem with installation

Hi, I need to install PostgreSQL 9 but in silence mode (like in MSI Installer for Postgres 8.3). Is it possible with PostgreSQL 9.0 or higher? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-

Re: [GENERAL] Problem with installation

Use "--mode unattended" option with one-click installer. You can always check other options using "--help" option of the installer. -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company *http://www.linkedin.com/in/asheshvashi*

Re: [GENERAL] Problem with installation

On 03/27/12 1:46 AM, niss...@wp.pl wrote: Hi, I need to install PostgreSQL 9 but in silence mode (like in MSI Installer for Postgres 8.3). Is it possible with PostgreSQL 9.0 or higher? what OS? on centos/redhat/fedora type linux, yum -y install postgresql91-{server,contrib,devel} runs

Re: [GENERAL] Problem with installation

niss...@wp.pl, 27.03.2012 10:46: Hi, I need to install PostgreSQL 9 but in silence mode (like in MSI Installer for Postgres 8.3). Is it possible with PostgreSQL 9.0 or higher? Why not use the binary ZIP distribution? Steps for installing are then: 1) Unzip the archive 2) Run initdb 3) Run

[GENERAL] Facing error while restoring the database

Hi I am facing issue while restoring the database. I have taken the backup of my database using pg_dump and then create new database and try to restore it using pg_restore. I am using PostgreSQL 9.0. I have created one small test case to reproduce the issue, attached is the sql file. *Steps to re

[GENERAL] PANIC: corrupted item pointer

Hi, I am running postgresql-9.1 from debian backport package fsync=on full_page_writes=off I didn't had any power failures on this server. Now I got this: 1. Logfile PANIC postgres[27352]: [4-1] PANIC: corrupted item pointer: offset = 21248, size = 16 postgres[27352]: [4-2] STATEMENT: insert

Re: [GENERAL] Facing error while restoring the database

On 27 March 2012 11:33, Akshay Joshi wrote: > Hi > > I am facing issue while restoring the database. I have taken the backup of > my database using pg_dump and then create new database and try to restore it > using pg_restore. I am using PostgreSQL 9.0. What is the error? It looks like you are t

Re: [GENERAL] Facing error while restoring the database

On Tue, Mar 27, 2012 at 6:15 PM, Alban Hertroys wrote: > On 27 March 2012 11:33, Akshay Joshi > wrote: > > Hi > > > > I am facing issue while restoring the database. I have taken the backup > of > > my database using pg_dump and then create new database and try to > restore it > > using pg_resto

[GENERAL] How can I modify a row in a function such that the caller sees it?

Bit of a nooby Q, tho I have researched this quite a bit and found nothing and it seems simple: I just want to modify a row in a plpgsql function such that the change can be seen by the caller. The functions happen to be called in a before trigger, to finish initializing the row. The functions are

Re: [GENERAL] Facing error while restoring the database

On 27 March 2012 15:12, Akshay Joshi wrote: > On Tue, Mar 27, 2012 at 6:15 PM, Alban Hertroys wrote: >> >> On 27 March 2012 11:33, Akshay Joshi >> wrote: >    pg_restore: restoring data for table "sample" >    pg_restore: [archiver (db)] Error while PROCESSING TOC: >    pg_restore: [archiver (db

Re: [GENERAL] Facing error while restoring the database

Akshay Joshi wrote: > I am facing issue while restoring the database. I have taken the backup of my database using pg_dump > and then create new database and try to restore it using pg_restore. I am using PostgreSQL 9.0. > I have created one small test case to reproduce the issue, attached is the s

Re: [GENERAL] Facing error while restoring the database

"Albe Laurenz" writes: > pg_dump does not resolve dependencies, it avoids problems by adding > constraints after inserting the data. > It seems that this is not done for CHECK constraints, however - they are > added when the table is defined. > I think that this is a bug. It is not a bug; it is

[GENERAL] windows 7 não funciona Adeus Postgresql

Não consegui fazer conexão no WINDOWS 7 de outro computador. Como não houve retorno cheguei a conclusão que o POSTGRESQL NÃO FUNCIONA COM WINDOWS 7, com isso vou ter que trocar de banco de dados. Estou me despedindo e agradecendo aos poucos que tentaram me ajudar. Aos demais constatei que não é um

Re: [GENERAL] Facing error while restoring the database

On Tue, Mar 27, 2012 at 7:40 PM, Tom Lane wrote: > "Albe Laurenz" writes: > > pg_dump does not resolve dependencies, it avoids problems by adding > > constraints after inserting the data. > > > It seems that this is not done for CHECK constraints, however - they are > > added when the table is d

Re: [GENERAL] Facing error while restoring the database

On Tuesday, March 27, 2012 08:20:23 PM Akshay Joshi wrote: > In my case I won't allow anyone to insert/modify the rows of sample_one > table. I have already inserted some rows in sample_one table where I > want one constraint is number of array elements of sample_one.param_names > and sample.pa

[GENERAL] configuring RAID10 for data in Amazon EC2 cloud?

does anyone have any tips on this? Linux Software Raid doesn't seem to be doing a very good job here, but i may well have missed something. i did a fairly naive setup using linux software raid on an amazon linux instance, 10 volumes (8G each), (WAL on a separate EBS volume) with the following se

Re: [GENERAL] configuring RAID10 for data in Amazon EC2 cloud?

On Mar 27, 2012, at 8:25 AM, Welty, Richard wrote: > does anyone have any tips on this? Linux Software Raid doesn't seem to be > doing a very good job here, but i may well have missed something. > iostat -x 5 is your friend. We've been struggling with a similar setup recently, and the TL;DR sum

Re: [GENERAL] configuring RAID10 for data in Amazon EC2 cloud?

On Tue, 27 Mar 2012 11:25:53 -0400 "Welty, Richard" wrote: > does anyone have any tips on this? Linux Software Raid doesn't seem > to be doing a very good job here, but i may well have missed > something. > > i did a fairly naive setup using linux software raid on an amazon > linux instance, 10

[GENERAL] Multiple Slave Failover with PITR

Hello everyone, I notice that the documentation at: http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial Doesn't contain steps in a Multiple Slave setup for re-establishing them after a slave has become the new master. Based on the documentation, here are the most fail-proof steps I came

[GENERAL] Valid query times out when run from bash script

Hello all - I've been trying to get a bash script set-up that creates a DB, does a join, writes the join to file, and then cleans itself up afterwards. Everything within the script runs fine when entered at an actual prompt, but when I run the script the SELECT query runs indefinitely. I'm not sur

Re: [GENERAL] Valid query times out when run from bash script

run the script with bash -v or -vvv for extra detailed vebose logging. see whats wrong, most of the times a matter using the right closure of the statements with ' or " Henk Bronk On 27 mrt. 2012, at 20:37, "W. David Jarvis" wrote: > Hello all - > > I've been trying to get a bash script s

Re: [GENERAL] Valid query times out when run from bash script

On 03/27/2012 11:37 AM, W. David Jarvis wrote: Hello all - I've been trying to get a bash script...but when I run the script the SELECT query runs indefinitely. ... # Create a bunch of indexes echo -n "Creating table indexes for faster querying..." psql mta-join< $OUTPUT_FILE Some things to

Re: [GENERAL] Valid query times out when run from bash script

On 27/03/2012 19:37, W. David Jarvis wrote: > Hello all - > > I've been trying to get a bash script set-up that creates a DB, does a > join, writes the join to file, and then cleans itself up afterwards. > Everything within the script runs fine when entered at an actual > prompt, but when I run th

Re: [GENERAL] Valid query times out when run from bash script

All - Thanks for the prompt responses. I've actually narrowed it down a bit and it seems that something earlier (specifically, the for loop that assembles $ADDITIONAL_CREATION_FIELDS and $ADDITIONAL_SELECTION_FIELDS) in the script is causing Bash to write extremely slowly (if I subset the query o

Re: [GENERAL] Valid query times out when run from bash script

No prompt, seems to be using .pgpass without a problem. On Tue, Mar 27, 2012 at 1:59 PM, Raymond O'Donnell wrote: > On 27/03/2012 19:37, W. David Jarvis wrote: >> Hello all - >> >> I've been trying to get a bash script set-up that creates a DB, does a >> join, writes the join to file, and then cl

[GENERAL] create one function to let other user execute vacuum command. got such an error.

create one function to let other user execute vacuum command. got such an error. Please help. Thanks. Regards . Grace rrp=> create function vacuum_f ( tablename char(100)) Returns char(100) AS $$ vacuum tablenam

Re: [GENERAL] postgresql commit.

Hi Andrew, Thanks. I got it. Regards. Grace At 2012-03-27 12:36:18,"Andrew Sullivan-8 [via PostgreSQL]" wrote: On Mon, Mar 26, 2012 at 06:22:20PM -0700, leaf_yxj wrote: > Oracle database, the other user can't see the uncommited data, for > postgresql 8.2 , it looks like once you issue ins

Re: [GENERAL] create one function to let other user execute vacuum command. got such an error.

On Tue, 2012-03-27 at 18:51 -0700, leaf_yxj wrote: > create one function to let other user execute vacuum command. got such an > error. Please help. Thanks. Regards . Grace > > rrp=> create function vacuum_f ( tablename char(100)) > > Returns char(100) AS $$

Re: [GENERAL] create one function to let other user execute vacuum command. got such an error.

On 28 Mar 2012, at 07:44, Guillaume Lelarge wrote: > On Tue, 2012-03-27 at 18:51 -0700, leaf_yxj wrote: >> create one function to let other user execute vacuum command. got such an >> error. Please help. Thanks. Regards . Grace >> >> rrp=> create function vacuum_f ( tablename char(100))