ferent schemata.
There will be one walsender for each downstream node, and one apply
worker for each upstream node, so you literally cut down to 1/200 the
amount of replication slots and replication connections on each node.
That's a huge performance win, particularly on 9.4.
Regards,
--
es down, all the transactions that make changes will hang at
commit execution.
Regards,
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make cha
resql
> again in old master node and issue cluster show it lists both nodes as
> masters.
That's not a surprise. This is called a brain split, something repmgr
doesn't fully take care of (we rely on other tools to do the fencing or
STONITH)
Regards,
--
Martín Marquéshttp://www.2ndQu
nsfer (and that if
it's only 500GB of WALs)
BTW, 2TB in 10 days means an avg speed of 2.3Mb/s. I guess this must be
some standby in a DR site without a dedicated network bandwidth.
Wouldn't it be faster to clone the disk locally, detach it and send it
over with a Courier? ;)
Regards,
--
Martín
2016-06-21 13:08 GMT-03:00 Robert Haas <robertmh...@gmail.com>:
> On Thu, Jun 16, 2016 at 1:46 PM, Martín Marqués <mar...@2ndquadrant.com>
> wrote:
>> The comment is accurate on what is going to be dumpable and what's not
>> from the code. In our case, as the pgq s
for that table.
IMO, he should start setting autovacuum more aggressively, or running
aggressive vacuum, and see how that works.
Also, install pgstattuple and check free space on the relation to see
how much dead tuples and free space there is.
Those are my 2 cents.
--
Martín Marqués
rtitions which are not used
> and
> B. The SELECT query is poorly crafted.
And you haven't read Vik's reply. :)
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-ge
2016-06-20 11:30 GMT-03:00 Vik Fearing <v...@2ndquadrant.fr>:
> On 20/06/16 16:23, Martín Marqués wrote:
>>
>> That's not entirely true. Think about a SELECT which has to scan all
>> child tables.
>
> Or any SELECT on the parent at all. The planner needs t
to the users
> AND space is reclaimed by the O/S, so it's the best of both worlds.
That's not entirely true. Think about a SELECT which has to scan all
child tables.
Your are also adding another layer of complexity to the system.
--
Martín Marquéshttp://www.2ndQuadrant.com/
P
Hi,
2016-06-16 9:48 GMT-03:00 Michael Paquier <michael.paqu...@gmail.com>:
> On Thu, Jun 16, 2016 at 8:37 PM, Martín Marqués <mar...@2ndquadrant.com>
> wrote:
>> El 16/06/16 a las 00:08, Michael Paquier escribió:
>>> On Wed, Jun 15, 2016 at 7:19 PM, Martí
El 16/06/16 a las 09:48, Michael Paquier escribió:
> On Thu, Jun 16, 2016 at 8:37 PM, Martín Marqués <mar...@2ndquadrant.com>
> wrote:
>
>> This problem came up due to a difference between pg_dump on 9.1.12 and
>> 9.1.22 (I believe it was due to a patch on pg_dump tha
El 16/06/16 a las 00:08, Michael Paquier escribió:
> On Wed, Jun 15, 2016 at 7:19 PM, Martín Marqués <mar...@2ndquadrant.com>
> wrote:
>>
>> How would the recovery process work? We expect the schema to be there
>> when restoring the tables?
>
> pg_dump cre
would the recovery process work? We expect the schema to be there
when restoring the tables?
That seems sensible.
I'll file a bug report later and maybe move this thread to -hackers.
Regards,
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Traini
restoring a dump or not?
Regards,
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mail
'on';
DROP TABLE af_npx_l3_16_146_10;
END;
After that, the DDL that's stuck will get applied and the stream of
changes will continue.
By the looks of what you're dealing with, I wouldn't be surprised if the
replication gets stuck again on another DDL conflict.
I suggest rethinking the locking
ou can do the dump psql pipe trick, which is quite robust, in 3-4
> you may push for it ( arguing it's a simpler an more testable process
> ).
>
> Francisco Olarte.
>
>
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, T
_replication, skip_ddl_locking)
and when needed they should be used with special care.
Regards,
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
nactive mode. Is there any way to ignore this error?
Could you provide the DDL that's run for the patitioning?
Could you provide logs from the other node? (the one where the partition
was created)
Regards,
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development,
evice_l3_16_149_10"
> already exists
I'm not sure what happened here. Does that relation exist?
Run \d+ af_npx_device_l3_16_149_10 with psql on both nodes.
Also, did replication resume? Check with the lag query from the BDR
documentation.
Regards,
--
Martín Marquésht
ether.
Regards,
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
hat value won't help if I need the xid to do a PITR up to that
xid not included.
Regards,
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
e "begin" statement, since at that point we have
> started a new transaction but not assigned it any xid.
This really gives little use for recovery_target_xid. :(
Regards,
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training
t
configured accordingly. I suppose this is not so simple to achieve.
So, my question is: Is this a bug, or a feature? I recall being able to
log xids on DDLs but can't find the correct settings now.
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Supp
os.x86_64
Regards,
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
would recommend using psql's \password meta-command instead of ALTER
USER to change a password, as to avoid having the password stamped in
the logs.
Regards,
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sen
ier mails, there was some consensus
(maybe I'm mistaken on that, but the topic came up) on having a specific
list for bdr/udr issues.
Where should this be handled? Should it be sent to the pgsql-www list?
Regards
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x
up. ;(
Or use repmgr. ;)
If you intend to use repmgr3 (will only work with postgres 9.3 and
above) you'll need to pass it the --rsync-only option so it doesn't
use pg_basebackup to clone.
Regards,
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support
andbys, which is why I recommended repmgr. If you need
to do backups then repmgr is not the way to go. There are other
alternatives.
Regards,
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general m
2015-09-03 16:48 GMT-03:00 Gerdan Rezende dos Santos <ger...@gmail.com>:
> On Thu, Sep 3, 2015 at 7:20 AM, Martín Marqués <mar...@2ndquadrant.com>
> wrote:
>>
>> El 03/09/15 a las 00:54, Gerdan Rezende dos Santos escribió:
>> >
>> >
>>
t* to put
tablespaces in $PGDTA/pg_tblspc/. That directory is for postgres to put
the links to where the actual tablespace is (normally on another partition)
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via
horoughly, with different environment parameters.
Regards,
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
: 602)
child process was terminated by signal 6
initdb: removing contents of data directory /opt/postgresql/data”
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-general mailing list (pgsql-general
El 24/08/15 a las 15:41, Florin Andrei escribió:
On 2015-08-23 06:56, Martín Marqués wrote:
El 21/08/15 a las 20:45, Florin Andrei escribió:
The single instance scheme is not very reliable. I need to build a new
DB backend. I'll set up Postgres 9.4. Ideally, I'd like to setup 2
instances
the physical join procedure with bdr_init_copy to
join nodes?
Regards,
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
, and doing all analytics on
the other node, what would be the best replication technique in this case?
Stream replication seems the one which might fit better. Trigger based
replication would choke on large bulk loads (unless you split them up
into smaller pieces)
Regards,
--
Martín Marqués
thinks you have 2 masters - the old one
offline and the new one online.
Regards,
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
El 13/08/15 a las 23:17, Adrian Klaver escribió:
On 08/13/2015 05:37 PM, Martín Marqués wrote:
El 13/08/15 a las 21:23, Guyren Howe escribió:
I also think migrations ought to be a first-class feature…
What do you mean with migrations ought to be a first-class feature?
There have been
is confused with the meaning of client_encoding, and should
maybe take a look here before continuing:
http://www.postgresql.org/docs/9.4/static/multibyte.html
And while reading that, they can switch to 9.4. ;)
Regadrs,
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL
sync replica fails, your transactions will get stalled waiting
for the transaction to get committed on one of the sync replicas.
Do you get the idea (or actually the problem behind your design)?
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support
El 13/08/15 a las 17:37, Melvin Davidson escribió:
You have not stated which Version or PostgreSQL,
He said it was for 9.4.
Is there anything out there like this? This would be for 9.4.
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support
distant nodes.
Conclusion, they don't solve the same problem, so it's hard to compare.
Cheers,
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
sure where you want to
get with this.
Cheers,
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
guess the answer is in some place around that.
Regards,
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
to start server..
Logs from just after you tried to start the server. The mysterious line
2 of recovery.conf. Network parameters from postgresql.conf.
Those 3 things could help.
Regards,
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training
to
recompile all the packages that are available by pgdg yum repository:
http://git.postgresql.org/gitweb/?p=pgrpms.git
Kind regards,
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-general mailing list (pgsql
://git.postgresql.org/gitweb/?p=postgresql.git;a=blob_plain;f=src/backend/storage/page/README;hb=HEAD
--
Martín Marqués http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
Is there any advice on running postgresql in a virtual machine connecting to
host data?
Did you check your logs to see if there was any information which
would point to the problem?
Looks like a libpq - backend server mismatch.
--
Martín Marqués http://www.2ndQuadrant.com/
PostgreSQL
Looks like someone hijacked the tweeter account @psql, and is posting
what looks like spam on http://forum.postgresql.org.pl, and then
spaming those posts with the tweeter account.
I just wanted to let the person in charge know.
Cheers,
--
Martín Marqués http://www.2ndQuadrant.com/
PostgreSQL
constraint because it checks all of the entries when it's applied. Any
suggestions?
We'd need to see how the constraint is added, and the function you say
is used for checking the constrants.
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training
El 17/06/13 17:08, François Beausoleil escribió:
I have a problem granting permissions. The end result I'm looking for is:
Dustin and Pablo are data analysts. When either creates a table, the table must
be created outside of public, and both must be able to delete the table when
their work is
, refresh-packagekit, security
Paquetes instalados
postgresql-libs.x86_64 9.2.4-1.fc18@updates
postgresql92-libs.x86_649.2.4-3PGDG.f18 @pgdg92
Paquetes disponibles
postgresql-libs.i6869.2.4-1.fc18updates
--
Martín Marquéshttp
. Try running the query
and at the same time monitor disk usage from the database temp/
directory ($PGDATA/dboid/temp/).
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-general mailing list (pgsql-general
it more suitable for
PostgreSQL to use temp files if numerous sorting jobs need quite a good
amount o memory.
You might as well try different values of work_mem to see what happens
(watch out for large values of work_mem), or rethink your query all
together.
Cheers,
--
Martín Marqués
2013/4/26 Richard Huxton d...@archonet.com:
On 25/04/13 18:01, Martín Marqués wrote:
Just tried upgrading and added the apt-postgresql.org repo to my
Debian server (on testing now) and I got some backages like barman
retained because some dependencies couldn't be satisfied.
Los siguientes
/main
i386 Packages
0.3.3-1 0
50 http://ftp.de.debian.org/debian/ unstable/main i386 Packages
Since when 2.7.3 isn't larger then 2.7.
If I use the Debian packages, everything installs without a problem.
--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador
. They used CURSORS a lot to simulate what they did with
SQLServer (there was a better solution, but time was crucial, and they
decided for that approach)
--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador
--
Sent via pgsql-general mailing list (pgsql
?
Related to your 400+ days not vacuumed tables, are you sure those
tables have data changes (INSERT/UPDATE/DELETE)? I have some static
tables with over a year of no vacuum (and autovacuum field never ran
on that relation).
What does n_dead_tup show?
--
Martín Marqués
select 'martin.marques
2013/3/28 CR Lender crlen...@gmail.com:
On 2013-03-28 13:11, Martín Marqués wrote:
2013/3/27 CR Lender crlen...@gmail.com:
In this case I was only trying to make sense of an existing database
(8.3). The statistics in pg_stats were way off for some tables, so I
wanted to see if (auto)vacuum
attribute (which would mean that there is redundancy).
--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador
image/png
... FROM with the same data?
Are you sure the process hangs (strange thing is that you can't
terminate the backend)? Could it be that it looks like it hung, but
it's actually COPYing a huge chunk of data?
--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador
but with the order
of the values as you see in the IN clause.
How can I do that?
--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
El día 20 de abril de 2012 05:51, Albe Laurenz
laurenz.a...@wien.gv.at escribió:
Martín Marqués wrote:
I have a question involving money data stored in a numeric(9,2) field,
and posible errors with there manipulation.
in short, the table has these columns:
store: int
amount: int2
cost
with the SUM() function?
If the answer is yes, where do the errors acumulate, and how can I solve it?
P.D.: I'm using PG and PHP in the middle.
--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador
--
Sent via pgsql-general mailing list (pgsql-general
want it to be happening again.
--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
://www.postgresql.org/mailpref/pgsql-general
--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
2011/11/4 Hannes Erven h...@gmx.at:
Am 2011-11-03 02:40, schrieb Martín Marqués:
Sad thing is that it's not so easy on Debian. With Fedora all I had to
do is select the arch type and that's all.
Have a look at dpkg --force-architecture .
I'm having a lot of trouble with this. The server has
El día 4 de noviembre de 2011 13:15, Scott Marlowe
scott.marl...@gmail.com escribió:
I'd install postgresql in a 32 bit VM then.
We're looking into it. Look's like the only option available for now,
at least for using WAL replication.
--
Martín Marqués
select 'martin.marques
El día 3 de noviembre de 2011 09:18, Rodrigo Gonzalez
rjgonz...@estrads.com.ar escribió:
El 02/11/11 22:40, Martín Marqués escribió:
2011/11/2 John R Piercepie...@hogranch.com:
On 11/02/11 11:21 AM, Martín Marqués wrote:
Don't worry, they are both x86 arch, so I'll just install 32bit
?
--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Don't worry, they are both x86 arch, so I'll just install 32bit
postgresql on the 64 bit server. That should make it work, right?
El día 2 de noviembre de 2011 14:55, Adam Cornett
adam.corn...@gmail.com escribió:
2011/11/2 Martín Marqués martin.marq...@gmail.com
I have two servers, one a x86
2011/11/2 John R Pierce pie...@hogranch.com:
On 11/02/11 11:21 AM, Martín Marqués wrote:
Don't worry, they are both x86 arch, so I'll just install 32bit
postgresql on the 64 bit server. That should make it work, right?
yes, that should work fine.
Sad thing is that it's not so easy on Debian
El día 19 de octubre de 2011 23:20, Jeff Davis pg...@j-davis.com escribió:
On Wed, 2011-10-19 at 14:30 -0300, Martín Marqués wrote:
The only concern I have is that on insertion, I get this WARNING:
WARNING: nonstandard use of \\ in a string literal at character 41
HINT: Use the escape
El día 20 de octubre de 2011 14:28, Rodrigo Gonzalez
rjgonz...@estrads.com.ar escribió:
El 20/10/11 14:13, Martín Marqués escribió:
El día 19 de octubre de 2011 23:20, Jeff Davis pg...@j-davis.com escribió:
On Wed, 2011-10-19 at 14:30 -0300, Martín Marqués wrote:
The only concern I have
there is no problem at all.
The only concern I have is that on insertion, I get this WARNING:
WARNING: nonstandard use of \\ in a string literal at character 41
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
Should I worry? What does it mean?
--
Martín Marqués
select
public.diccionario
WHERE palabra = quote_literal(p);
$body$ LANGUAGE 'SQL';
Changing p for $1 in the body of the function makes it work. But,
can't we label input arguments like how I did here?
--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador
2011/9/21 Thomas Kellerer spam_ea...@gmx.net:
Martín Marqués, 21.09.2011 14:56:
I was makeing an SQL function and got an error which on a sintax that
I thouhgt would work:
CREATE OR REPLACE FUNCTION dicInsertarPalabra(p TEXT)
RETURNS INT AS $body$
INSERT INTO public.diccionario
5015 are the WAL buffers written to the transaction log, but what is the 15.1%?
Also, what do the times at the end mean? Time to write the buffers to
the transaction log, or to flush modificactions stored in the
transaction logs to there final destination in the data base files?
--
Martín Marqués
I'm searching for information on pg_lock_status() function, but there
seams to be nothing in the docs. Maybe missing? Any hits, at least
what each column outputed is.
--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador
--
Sent via pgsql-general
in the docs. Maybe missing?
It's not documented because it's an internal function that you shouldn't
call directly. Look at the docs for the pg_locks view, which is the
public API.
regards, tom lane
--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA
El día 26 de agosto de 2011 09:15, Merlin Moncure mmonc...@gmail.com escribió:
2011/8/26 Martín Marqués martin.marq...@gmail.com:
El día 26 de agosto de 2011 00:04, Merlin Moncure mmonc...@gmail.com
escribió:
2011/8/25 Martín Marqués martin.marq...@gmail.com:
CREATE OR REPLACE FUNCTION
was able to do it on 8.4, but not on 8.3.
El día 29 de agosto de 2011 13:48, Martín Marqués
martin.marq...@gmail.com escribió:
El día 26 de agosto de 2011 09:15, Merlin Moncure mmonc...@gmail.com
escribió:
2011/8/26 Martín Marqués martin.marq...@gmail.com:
El día 26 de agosto de 2011 00:04
El día 29 de agosto de 2011 15:28, Pavel Stehule
pavel.steh...@gmail.com escribió:
2011/8/29 Martín Marqués martin.marq...@gmail.com:
Actually, what we are trying to do is return 2 recordsets with the
same function call (simulate SP from SQL Server returning 2
recordsets).
I found out that I
El día 29 de agosto de 2011 15:52, Pavel Stehule
pavel.steh...@gmail.com escribió:
2011/8/29 Martín Marqués martin.marq...@gmail.com:
El día 29 de agosto de 2011 15:28, Pavel Stehule
pavel.steh...@gmail.com escribió:
2011/8/29 Martín Marqués martin.marq...@gmail.com:
Actually, what we
El día 29 de agosto de 2011 16:12, Pavel Stehule
pavel.steh...@gmail.com escribió:
2011/8/29 Martín Marqués martin.marq...@gmail.com:
refcursors can be dynamic defined
OK, I'm totally lost. How do you define a dynamic cursor? Couldn't
find anything in the manuals.
DECLARE
curs1
El día 26 de agosto de 2011 00:04, Merlin Moncure mmonc...@gmail.com escribió:
2011/8/25 Martín Marqués martin.marq...@gmail.com:
CREATE OR REPLACE FUNCTION prueba_cursor(codigo integer, curCursor refcursor)
RETURNS SETOF refcursor AS
$BODY$
DECLARE
cur alias for $2;
BEGIN
;
select * from prueba_cursor4(1, 'h');
end;
--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
21:46, Martín Marqués
martin.marq...@gmail.com escribió:
CREATE OR REPLACE FUNCTION prueba_cursor(codigo integer, curCursor refcursor)
RETURNS SETOF refcursor AS
$BODY$
DECLARE
cur alias for $2;
BEGIN
PERFORM mpf.ConstruyeCursorDesdeQuery('cur' ,'SELECT * from
tab1 WHERE field
El día 22 de agosto de 2011 18:39, Greg Smith g...@2ndquadrant.com escribió:
On 08/22/2011 05:07 PM, Martín Marqués wrote:
My question regarding your answer is, why is it important for the
first page after a checkpoint and not on other page writes?
The first time a page is written after
I see that max_fsm_pages isn't there anymore in postgresql.conf from 8.4.
Why is it? And can it be configured, or is it something we should not
worry about?
--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador
--
Sent via pgsql-general mailing list
your answer is, why is it important for the
first page after a checkpoint and not on other page writes?
--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
by hand to find out who has the biggest error, or if any is 100%
accurate.
Any ideas?
--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
Just to to finish this thread:
We had a corrupted memory bank in the development server, and that
was, for some reason corrupting the data that got written to disk.
All is good now. Sorry for the noise.
El día 23 de marzo de 2011 16:28, Martín Marqués
martin.marq...@gmail.com escribió:
2011/3
-++---+
2357634 | 954516 | La educación superior en el sector aducativo
del mercosur | 5
So, why didn't pg_dump add the tabs between 954516 and La educación...?
Right now I'm trying to do dump with INSERTs instead of COPY command
to see what happens.
--
Martín Marqués
select 'martin.marques
...@khera.org:
2011/3/23 Martín Marqués martin.marq...@gmail.com:
The scenario is like this. I tried today to dump a DB from our
production server to load on our development server and got some
errors, which I show below.
Try using the pg_dump from the 8.4 install to create your dump file
El día 23 de marzo de 2011 11:18, Adrian Klaver
adrian.kla...@gmail.com escribió:
On Wednesday, March 23, 2011 6:57:35 am Martín Marqués wrote:
Now I'm getting weirder things. I did a pg_dump with -d option and the
dump adds strange caracters:
As previously stated try using the 8.4 version
El día 23 de marzo de 2011 14:03, Adrian Klaver
adrian.kla...@gmail.com escribió:
On 03/23/2011 07:56 AM, Martín Marqués wrote:
Ok, did a remote dump (from the development server which has pg 8.4)
and I got a similar error:
psql:siprebi-bu.sql:27374: ERROR: sintaxis de entrada
2011/3/23 Vick Khera vi...@khera.org:
2011/3/23 Martín Marqués martin.marq...@gmail.com:
The second error is very curious, as it looks like pg_dump changed 1
for a 'q' in an integer field:
psql:siprebi-bu.sql:2219245: ERROR: la sintaxis de entrada no es
válida para integer: «q721695
| 60490
64 | 6 | 1 | 68861
73 | 1 | 1 | 69220
(5 filas)
Why aren't the 5 rows from the second query in the first?
--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador
--
Sent via pgsql-general mailing list (pgsql
(we are going to replicate the whole DB). I'm I wrong on this?
And finally a question related with the instalation: are there debian
binaries to install replicator?
TIA
--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador
--
Sent via pgsql-general
(we are going to replicate the whole DB). I'm I wrong on this?
And finally a question related with the instalation: are there debian
binaries to install replicator?
TIA
--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador
--
Sent via pgsql-general
1 - 100 of 133 matches
Mail list logo