Hello experts,
I try to do an update together with a RETURNING clause but without success
(postgresql 9.1 on CentOS 6.2),
the returned data can be multiple rows (not only one row expected like in
src/interfaces/ecpg/test/sql/insupd.pgc):
1:
EXEC SQL DECLARE cur CURSOR FOR UPDATE t set a=0 where
Not sure. But you can always avoid the OS authentication with empty user and
password to access Oracle.
You can use other authentication mode to access oracle instead.
--
ThanksRegards,
Xiong He
-- Original --
From: Papiernik
Hi,
In my case is different. i have only 2 DB login user.. say postgres and
dbuser1
My other friends login into this db server using different app server say
app1,app2.
Their user names are osuser1,osuser2
I want to know who is logging via which server and what db they are access
and what
Hi,
we would like to switch from mysql cluster to postgresql. We need high
available solution so we can store telco data for our PBXes. The
problem is, we dont know what would best suit to our needs, we need:
1) High availability with failover - if one node goes down, nothing
bad happens (5sec
What's the current status on installs of PostGis with Postgres 9.2? Can I run
PostGIS 1.5 and/or PostGIS 2.0 with Postgres 9.2?
I noticed StackBuilder does not include PostGis with Postgres 9.2, but does
include it (PostGis 1.5) with Postgres 9.1.
I'm running Postgres 9.1 on a Mac OSX 10.7
On Tue, Oct 23, 2012 at 9:51 AM, Scott Marlowe scott.marl...@gmail.com wrote:
On Mon, Oct 22, 2012 at 7:17 AM, Chris Angelico ros...@gmail.com wrote:
After reading the comments last week about SSDs, I did some testing of
the ones we have at work - each of my test-boxes (three with SSDs, one
On Tue, 23 Oct 2012 18:52:52 +, Gauthier, Dave said:
Here's the deal...
Instead of architecting and loading a table like...
create teble foo (col1 text, col2 text, col3 text, col4 text, col5
text); insert into foo (col1,col2,col3,col4,col5) values
('c1',null,'c3','c4',null);
They did
Hello,
I think you might need to have a look on a binary replication and Pgpool ii
Regards
From: Mino Haluz mino.ha...@gmail.com
To: pgsql-general@postgresql.org
Sent: Wednesday, October 24, 2012 2:28 PM
Subject: [GENERAL] Postgresql high available
On Wed, Oct 24, 2012 at 8:04 AM, Chris Angelico ros...@gmail.com wrote:
On Tue, Oct 23, 2012 at 9:51 AM, Scott Marlowe scott.marl...@gmail.com
wrote:
On Mon, Oct 22, 2012 at 7:17 AM, Chris Angelico ros...@gmail.com wrote:
After reading the comments last week about SSDs, I did some testing of
On Thu, Oct 25, 2012 at 2:42 AM, Steve Litt sl...@troubleshooters.com wrote:
Also, with the organization they're using, one can make new columns
on the fly. ... Anyway, the keypuncher is punching
data, comes across a brand new type of data (let's say artist), so
for this row the keypuncher
Hola Lista
tengo una tabla con la siguiente estructura
CREATE TABLE datos_para_proceso
(
id bigint,
identificador character varying,
nombre character varying(255),
nombreusuario text,
identificacion character varying(255),
tema character varying(255),
notatema text,
subtema
http://www.postgresql.org/docs/current/static/sql-copy.html
De: Hellmuth Vargas hiv...@gmail.com
Para: Lista Postgres ES pgsql-es-ay...@postgresql.org;
pgsql-general@postgresql.org
Enviado: Miércoles 24 de octubre de 2012 12:22
Asunto: [pgsql-es-ayuda] como
More important than the solution to this specific problem is the question
of why psql crashed when doing this export...
2012/10/24 Alejandro Carrillo faster...@yahoo.es
http://www.postgresql.org/docs/current/static/sql-copy.html
--
*De:* Hellmuth Vargas
Hola Alejandro
Muchas gracias!! la verdad no me acordaba que el copy podía funcionar en
doble via!!!
2012/10/24 Alejandro Carrillo faster...@yahoo.es
http://www.postgresql.org/docs/current/static/sql-copy.html
--
*De:* Hellmuth Vargas hiv...@gmail.com
data=# \o /tmp/datos_para_proceso.csv
data=# select * from datos_para_proceso;
/opt/PostgreSQL/9.2/bin/psql: línea 30: 9608 Terminado (killed)
LD_PRELOAD=$PLL LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$PG_BIN_PATH/../lib
$PG_BIN_PATH/psql.bin $@
Moshe Jacobson escribió:
More important than
In general, autovacuum seems to work well on most of the tables I deal
with. However, in a couple of specific cases, it seems to fail miserably. I
would like to switch to manual vacuuming on those tables and disable
auto-vacuuming for those tables alone. Is this possible? I searched the
docs and
On 10/24/2012 02:57 PM, Eliot Gable wrote:
In general, autovacuum seems to work well on most of the tables I deal
with. However, in a couple of specific cases, it seems to fail
miserably. I would like to switch to manual vacuuming on those tables
and disable auto-vacuuming for those tables
Eliot Gable escribió:
In general, autovacuum seems to work well on most of the tables I deal
with. However, in a couple of specific cases, it seems to fail miserably. I
would like to switch to manual vacuuming on those tables and disable
auto-vacuuming for those tables alone. Is this possible?
Shaun Thomas escribió:
On 10/24/2012 02:57 PM, Eliot Gable wrote:
In general, autovacuum seems to work well on most of the tables I deal
with. However, in a couple of specific cases, it seems to fail
miserably. I would like to switch to manual vacuuming on those tables
and disable
On Thu, 25 Oct 2012 03:56:39 +1100, Chris Angelico said:
On Thu, Oct 25, 2012 at 2:42 AM, Steve Litt
sl...@troubleshooters.com wrote:
Also, with the organization they're using, one can make new
columns on the fly. ... Anyway, the keypuncher is punching
data, comes across a brand new type
I have been struggling mightily to get pgagent working on our system, with no
success, and would appreciate any instructions or advice. I have spent hours
searching the net for insight, but so far nothing has helped get me over the
hump.
It would be gratifying if someone could simply
PostgreSQL a MySQL
HL-DBExporter (PostgreSQL a MySQL)
www.hlevelsoft.com/index.php/es/postgres/postgresql-mysqlb
La aplicación HL-DBExporter (PostgresSQL a MySQL) permite
exportar,convertir,transferir, migrar datos de una base de datos PostgreSQL a
otra base de datos MySQL.
Puede
On 10/24/12 2:41 PM, Toni wrote:
La aplicación HL-DBExporter (PostgresSQL a MySQL) permite
exportar,convertir,transferir, migrar datos de una base de datos
PostgreSQL a otra base de datos MySQL.
googlelated - The HL-DBExporter application (PostgreSQL to MySQL)
allows export, convert,
Hello all,
Does anyone know of reasonably-sized data dumps (csv or excel or xml..) that
can be used for learning/teaching about performance tuning. Say - a set of 6-7
tables, may be two of them with a few million records etc? Total data volume
would be in a few GB range. There are tools which
I could after some work, what I want to ask now is this:
In the middle of the pg_restore process I had to stop it (^Z) and remove
one problematic and not needed database from the
generated pg_upgrade_dump_db.sql file and then continue the process with
fg, of course it failed BUT: I started the new
Hi, I'm trying to upgrade from 9.1 to 9.2 but lc_collate issue is very
difficult to solve, How I know the old lc_collate? I've only could grepped
old settings lc_numeric, lc_time, lc_messages and lc_monetary all them =
'C' but I don't know what lc_collate was or how to find it. please help.
Thanks
Hi, I'm trying to upgrade from 9.1 to 9.2 but lc_collate issue is very
difficult to solve, How I know the old lc_collate? I've only could grepped
old settings lc_numeric, lc_time, lc_messages and lc_monetary all them =
'C' but I don't know what lc_collate was or how to find it. please help.
Thanks
27 matches
Mail list logo