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
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
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
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
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
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:
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
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
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
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
10 matches
Mail list logo