ead in different 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.
sactions 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 changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
e state after this. If I start postgresql
> 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)
Regar
transfer (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? ;)
Regard
2016-06-21 13:08 GMT-03:00 Robert Haas :
> On Thu, Jun 16, 2016 at 1:46 PM, Martín Marqués
> 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 schema is not dumpable becaause
>> it comes from a
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éshttp://www.2
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 (p
2016-06-20 11:30 GMT-03:00 Vik Fearing :
> 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 to examine the
> CHECK const
able 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.2nd
Hi,
2016-06-16 9:48 GMT-03:00 Michael Paquier :
> On Thu, Jun 16, 2016 at 8:37 PM, Martín Marqués
> wrote:
>> El 16/06/16 a las 00:08, Michael Paquier escribió:
>>> On Wed, Jun 15, 2016 at 7:19 PM, Martín Marqués
>>> wrote:
>>>>
>>>> How
El 16/06/16 a las 09:48, Michael Paquier escribió:
> On Thu, Jun 16, 2016 at 8:37 PM, Martín Marqués
> 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 that excluded the
>> d
El 16/06/16 a las 00:08, Michael Paquier escribió:
> On Wed, Jun 15, 2016 at 7:19 PM, Martín Marqués
> wrote:
>>
>> How would the recovery process work? We expect the schema to be there
>> when restoring the tables?
>
> pg_dump creates the schema first via the CR
ss 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, Training & Services
ted (and empty) when
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
locking TO '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.
you 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
p_ddl_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
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 Developm
npx_device_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és
ng the disks all together.
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
misleading
> xid attached to the "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
ICS that 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
l as with other DDLs and/or DMLs with log_statement
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:/
adrant.el7.centos.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
s=# \q
I 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 & Ser
ls, 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
d 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 mailing list (pgsql-general@pos
f 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, Training &
2015-09-03 16:48 GMT-03:00 Gerdan Rezende dos Santos :
> On Thu, Sep 3, 2015 at 7:20 AM, Martín Marqués
> wrote:
>>
>> El 03/09/15 a las 00:54, Gerdan Rezende dos Santos escribió:
>> >
>> >
>> > In other server with same configuration the proccess
u *not* 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
est them more
thoroughly, 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
M pg_sleep(0.5);
EXIT WHEN _node_status = 'r';
END LOOP;
END;
$body$;
BTW, why don't you the physical join procedure with bdr_init_copy to
join nodes?
Regards,
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training
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 P
ata/base/1 ... ok
> initializing pg_authid ... oke
> initializing dependencies ... ok
> creating system views ... TRAP: FailedAssertion("!(const
> Node*)(field1))->type) == T_String))", File: "parse_expr.c", Line: 602)
> child process was terminated by
gger based
replication would choke on large bulk loads (unless you split them up
into smaller pieces)
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
...
>> From the looks of it repmgr 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 mailin
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 "
ble, but I'm not really 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 t
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, 24x
seem acceptable.
>>
>>>
>>> Or will I be obligated to use async replication in such scenario?
>>>
>>
>> async is your friend here.
>
> And what about the timeout when using sync replication? What will happen?
There isn't any rep
aphically 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@
your editor changed the encoding? Not to be relied on, for sure.
Well, IIRC a LATIN9 encoding char which is interpreted as UTF8 will get
inserted with no error on a UTF8 server (although the final data will be
bogus).
IMO Leonardo is confused with the meaning of client_encoding, and should
may
sword for user pguser:
> psql: FATAL: password authentication failed for user "pguser"
Well, which is the IP from where you are running this command?
I guess the answer is in some place around that.
Regards,
--
Martín Marquéshttp://www.2ndQuadrant.com/
PostgreSQL
3.421.1 and accepting tcp/ip connection on port 5432.
Is 2.3.421.1 the server from above in this mail? It's obviously not running.
> any help to start server..
Logs from just after you tried to start the server. The mysterious line
2 of recovery.conf. Network parameters from postgresql.co
thing you need 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
esql.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 y
art -D /mnt/post/pgsql/data
> 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.2
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
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
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
. 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-gen
resto, 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és
2013/4/26 Richard Huxton :
> 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
squeeze-pgdg/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' ||
s that where impossible with PG functions written
in plpgsql. 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' || '@' || 'gma
2013/3/28 CR Lender :
> On 2013-03-28 13:11, Martín Marqués wrote:
>> 2013/3/27 CR Lender :
>>> 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
shold? autovacuum_vacuum_scale_factor?
autovacuum_analyze_scale_factor?
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).
ould be true if the last digits of the name attribute is equal to the
id attribute (which would mean that there is redundancy).
--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador
<>
hang and how to prevent it?
What happens if you use COPY ... 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 &#x
a 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
El día 20 de abril de 2012 05:51, Albe Laurenz
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:
>>
>> stor
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-
rting: time
Any ideas?
Last year I had memory problems with this server (changed the faulty
bank), I wouldn't want it to be happening again.
--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador
--
Sent via p
@postgresql.org)
> To make changes to your subscription:
> http://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
El día 4 de noviembre de 2011 13:15, Scott Marlowe
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.marqu
2011/11/4 Hannes Erven :
> 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'
El día 3 de noviembre de 2011 09:18, Rodrigo Gonzalez
escribió:
> El 02/11/11 22:40, Martín Marqués escribió:
>>
>> 2011/11/2 John R Pierce:
>>>
>>> On 11/02/11 11:21 AM, Martín Marqués wrote:
>>>>
>>>> Don't worry, they are both x86
2011/11/2 John R Pierce :
> 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
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
escribió:
>
> 2011/11/2 Martín Marqués
>>
>> I have two servers, one a x86 32bit server
?
--
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
El día 20 de octubre de 2011 14:28, Rodrigo Gonzalez
escribió:
> El 20/10/11 14:13, Martín Marqués escribió:
>
> El día 19 de octubre de 2011 23:20, Jeff Davis escribió:
>
> On Wed, 2011-10-19 at 14:30 -0300, Martín Marqués wrote:
>
> The only concern I have is that on
El día 19 de octubre de 2011 23:20, Jeff Davis 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: U
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 Marq
2011/9/21 Thomas Kellerer :
> 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$
&
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' || '@' || 'gm
1004.571 s
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
issing?
>
> 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.m
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, Admini
El día 29 de agosto de 2011 16:12, Pavel Stehule
escribió:
> 2011/8/29 Martín Marqués :
>>>
>>> refcursors can be dynamic defined
>>
>> OK, I'm totally lost. How do you define a dynamic cursor? Couldn't
>> find anything in the manuals.
>>
El día 29 de agosto de 2011 15:52, Pavel Stehule
escribió:
> 2011/8/29 Martín Marqués :
>> El día 29 de agosto de 2011 15:28, Pavel Stehule
>> escribió:
>>> 2011/8/29 Martín Marqués :
>>>> Actually, what we are trying to do is return 2 recordsets with the
El día 29 de agosto de 2011 15:28, Pavel Stehule
escribió:
> 2011/8/29 Martín Marqués :
>> 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 ou
r.
I 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
escribió:
> El día 26 de agosto de 2011 09:15, Merlin Moncure
> escribió:
>> 2011/8/26 Martín Marqués :
>>> El día 26 de agosto de 2011 00:04, Merlin Moncure
>>> escr
El día 26 de agosto de 2011 09:15, Merlin Moncure escribió:
> 2011/8/26 Martín Marqués :
>> El día 26 de agosto de 2011 00:04, Merlin Moncure
>> escribió:
>>> 2011/8/25 Martín Marqués :
>>>> CREATE OR REPLACE FUNCTION prueba_cursor(codigo integer, curCursor
El día 26 de agosto de 2011 00:04, Merlin Moncure escribió:
> 2011/8/25 Martín Marqués :
>> CREATE OR REPLACE FUNCTION prueba_cursor(codigo integer, curCursor refcursor)
>> RETURNS SETOF refcursor AS
>> $BODY$
>> DECLARE
>> cur alias
2011 21:46, Martín Marqués
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 *
'plpgsql' VOLATILE
COST 100
ROWS 1000;
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
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
--
El día 22 de agosto de 2011 18:39, Greg Smith 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 p
n in
postgresql.conf and saw this mail.
My question regarding 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
--
ng the maths
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.or
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
escribió:
> 2011/3/23 Vick Khera :
>
2011/3/23 Vick Khera :
> 2011/3/23 Martín Marqués :
>> 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: «
El día 23 de marzo de 2011 14:03, Adrian Klaver
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: si
El día 23 de marzo de 2011 11:18, Adrian Klaver
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 usi
Vick Khera :
> 2011/3/23 Martín Marqués :
>> 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
campo
-++---+
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.
| 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 vi
(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, Admini
(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, Admini
1 - 100 of 134 matches
Mail list logo
