[ADMIN] ctrl-c - is it safe to kill a query?

2010-02-08 Thread Mark Steben
Hi folks, We are running psql 8.3.7 and linux 2.6.9-78.0.17.ELsmp We had a situation this weekend where someone was running an update On the psql command line and had to kill it. It is considered 'best practice' to use cntrl-c to do so? Or is there a better way? The transaction

Re: [ADMIN] Best Replication Tool

2010-02-08 Thread Rosser Schwarz
On Sun, Feb 7, 2010 at 8:22 PM, Kiswono Prayogo kisw...@gmail.com wrote: Hi, i'm really new to postgresql replication, was there any replication tool for postgresql that can do real-time replication from 1 database to ~3-10 database (on the other machines) with little overhead for load

Re: [ADMIN] ctrl-c - is it safe to kill a query?

2010-02-08 Thread Bruce Momjian
Mark Steben wrote: Hi folks, We are running psql 8.3.7 and linux 2.6.9-78.0.17.ELsmp We had a situation this weekend where someone was running an update On the psql command line and had to kill it. It is considered 'best practice' to use cntrl-c to do so? Or is

[ADMIN] copy table

2010-02-08 Thread Marc Fromm
I created a new database and I want to copy a table from a different database into the new database. 1. I used phpPgAdmin and exported the table that I want a copy of. 2. In the new database I pasted the export into the SQL box in phpPgAdmin and clicked execute to create the table. The table was

Re: [ADMIN] copy table

2010-02-08 Thread Melissa Peterson
For your primary key column, does the SQL in your table creation script look like: column_name integer NOT NULL DEFAULT nextval('rd.table_name_columname_seq'::regclass) or column_name serial If the former, and if your original sequence wasn't anything custom, try changing it to column_name

[ADMIN] effective_io_concurrency cannot be changed error when starting 8.4.2 instance

2010-02-08 Thread Kevin Kempter
Hi All; I get the below error when trying to start an 8.4.2 instance Anyone know what might be causing this? FATAL: parameter effective_io_concurrency cannot be changed Thanks in advance -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription:

[ADMIN] Re: effective_io_concurrency cannot be changed error when starting 8.4.2 instance

2010-02-08 Thread Greg Stark
On Tue, Feb 9, 2010 at 1:00 AM, Kevin Kempter kev...@consistentstate.com wrote: I get the below error when trying to start an 8.4.2 instance Anyone know what might be causing this? FATAL:  parameter effective_io_concurrency cannot be changed What platform is this? Did you compile it

Re: [ADMIN] effective_io_concurrency cannot be changed error when starting 8.4.2 instance

2010-02-08 Thread Tom Lane
Kevin Kempter kev...@consistentstate.com writes: I get the below error when trying to start an 8.4.2 instance Anyone know what might be causing this? FATAL: parameter effective_io_concurrency cannot be changed You're probably trying to set that on a platform that hasn't got the necessary

Re: [ADMIN] Re: effective_io_concurrency cannot be changed error when starting 8.4.2 instance

2010-02-08 Thread Tom Lane
Greg Stark gsst...@mit.edu writes: The error means that your system does not support the system interface we need to support prefetching. In that case effective_io_concurrency will be a read-only parameter set to 0 and any attempt to set it will result in an error. I wonder whether it would

Re: [ADMIN] Best Replication Tool

2010-02-08 Thread Gerd Koenig
Hi, probably pgpool-II is worth trying. A new version has been released two days ago http://pgfoundry.org/projects/pgpool hth ..:GERD:.. On Monday 08 February 2010 23:38:54 Rosser Schwarz wrote: On Sun, Feb 7, 2010 at 8:22 PM, Kiswono Prayogo kisw...@gmail.com wrote: Hi, i'm really new