wiki.postgresql.org/wiki/Pg_dump_improvements
regards,
--
Rafael Martinez Guerrero
Center for Information Technology
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
)
^
QUERY: INSERT INTO public.test_close_trigger
(id, close)
VALUES (NEW.id, NEW.close)
CONTEXT: PL/pgSQL function test_close() line 3 at SQL statement
-
Thanks in advance.
regards,
--
Rafael Martinez Guerrero
Center for Information
On Thu, 2014-02-06 at 07:11 -0800, Adrian Klaver wrote:
On 02/06/2014 06:35 AM, Rafael Martinez Guerrero wrote:
We think the behavior should be consistent, either it is allow to use
them or not, but not like it is today.
As a general rule, if you get spurious parser errors for commands
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/11/2013 11:20 PM, Josh Berkus wrote:
On 11/11/2013 06:24 AM, Stephen Frost wrote:
* Rafael Martinez (r.m.guerr...@usit.uio.no) wrote:
* We need a pg_dump solution that can generate in one step all
the necessary pieces of information needed
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/12/2013 03:28 PM, Stephen Frost wrote:
* Rafael Martinez (r.m.guerr...@usit.uio.no) wrote:
Comments?
Create a wiki page for it. :)
What about this to start with?:
https://wiki.postgresql.org/wiki/Pg_dump_improvements
- --
Rafael
to implement some of these changes?
Thanks in advance for your time.
Some background information:
Ref:
http://wiki.postgresql.org/wiki/Todo
http://www.postgresql.org/message-id/4864f001.50...@archonet.com
http://www.postgresql.org/message-id/11646.1272814...@sss.pgh.pa.us
regards,
- --
Rafael Martinez
that this parameter only works together
with -f or update the psql code so psql -1 file.sql also works.
regards,
- --
Rafael Martinez Guerrero
Center for Information Technology
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
-BEGIN PGP SIGNATURE-
Version: GnuPG v2.0.14
.
regards,
- --
Rafael Martinez, r.m.guerr...@usit.uio.no
Center for Information Technology Services
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.10 (GNU/Linux)
iEYEARECAAYFAkwZyJ4ACgkQBhuKQurGihT3kgCgn4iQkZ8YKr/nAk5
startet in the master.
The only different I can see at the OS level is that in a) the
connection continues to have the status ESTABLISHED forever, and in b)
it gets status TIME_WAIT in the moment postgres is down in the master.
regards,
- --
Rafael Martinez, r.m.guerr...@usit.uio.no
Center
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Robert Haas wrote:
On Fri, Jun 11, 2010 at 9:29 PM, Rafael Martinez
I'm somewhat disinclined to try to address this for 9.0. We've had
this problem for a long time, and I'm not sure that the fact that it
can now happen in a slightly wider set
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
-
regards,
- --
Rafael Martinez, r.m.guerr...@usit.uio.no
Center for Information Technology Services
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Fujii Masao wrote:
On Mon, Feb 1, 2010 at 7:33 PM, Rafael Martinez
r.m.guerr...@usit.uio.no wrote:
Any thoughts about this? Is this a bug or a 'feature'?
This is not a bug. Since pg_start_backup() uses %X/%X (not %08X/%08X)
as the format
not ends with '00'
* We have had WAL files ending with '00' with versions 8.3.9 and the
format used have been the expected (some number/8 digits).
Any thoughts about this? Is this a bug or a 'feature'?
Thanks in advance.
regards,
--
Rafael Martinez, r.m.guerr...@usit.uio.no
Center
.
Is it normal to get the same 2nd part of the file name all the time? How
is this value generated?
This behavior is strange and I wonder if there is anything wrong with
this new server. Everything else looks ok and works without problems.
Thanks in advance.
--
Rafael Martinez, r.m.guerr
Tom Lane wrote:
Rafael Martinez r.m.guerr...@usit.uio.no writes:
All PITR backup history files created when running a PITR base backup on
all PostgreSQL clusters running in this new server (at different hours
during the night) got an identical 2nd part file name.
24 digits.0020
of implementing a way of knowing when was the last
time statistics delivered via pg_stat_* were reset?
regards,
- --
Rafael Martinez, r.m.guerr...@usit.uio.no
Center for Information Technology Services
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
-BEGIN PGP SIGNATURE
of the database once the individual pieces are exposed.
Great, this is good enough and we get what we need. Thanks :-)
regards
--
Rafael Martinez, r.m.guerr...@usit.uio.no
Center for Information Technology Services
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
--
Sent via
+indexes and pg_relation_size() to return data+toast.
Is this a deliberate decision? Could we change this behavior in the future?
We are using a 8.3 database.
Thanks in advance.
regards,
- --
Rafael Martinez, r.m.guerr...@usit.uio.no
Center for Information Technology Services
University of Oslo
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
Rafael Martinez r.m.guerr...@usit.uio.no writes:
I wonder why the function pg_relation_size(text) does not take into
account the space used by toast data in a table when returning the space
used by the table.
It's not supposed
not differentiate
between data saved via toast or not.
The size of the table without the indexes should be reported regardless
the technique used to save the data on the disk.
regards,
- --
Rafael Martinez, r.m.guerr...@usit.uio.no
Center for Information Technology Services
University of Oslo
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
Rafael Martinez r.m.guerr...@usit.uio.no writes:
I am probably missing the point here, why is it not supposed to show the
size of the table(data) *without* indexes?
Because pg_relation_size is defined at the physical level
or authentication method.
regards,
- --
Rafael Martinez, r.m.guerr...@usit.uio.no
Center for Information Technology Services
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.7 (GNU/Linux)
iD8DBQFKp7GVBhuKQurGihQRAhCZAJ9y5BhdWbrpJeW12g
Andrew Dunstan wrote:
Rafael Martinez wrote:
Or throw an error saying 'ALL' is not a valid value and *not* reload the
pg_hba.conf file.
But it's not invalid. It would designate a database or user named ALL.
That might be a silly thing to do, but that's another question
Alvaro Herrera wrote:
Rafael Martinez wrote:
Shouldn't 'all' be a reserved word?, it has a special meaning when used
in pg_hba.conf.
No, it works fine with a line like this:
local all all md5
Ok, then all and ALL should be valid values but not all and ALL
compliant)
* More exotic datatypes
* More query optimizer improvements
* Elimination of vacuum
* Improve XML support
* Pre-parsing phase that converts non-ISO syntax to supported syntax.
Thanks in advance for your feedback.
[1] http://friprog.no/ez/index.php?/nor/English
regards,
--
Rafael Martinez
back the main release. We are testing and planing
the move to 8.2 now, and it won't happen until desember. In a 6 month
cycle we will have to jump over every second release.
regards
--
Rafael Martinez, [EMAIL PROTECTED]
Center for Information Technology Services
University of Oslo, Norway
PGP
+
transactions and 2millons+ inserts/updates a day and we have never had
to run a reindex to get a good performance
PS.- RAID-0 for a database is a disaster waiting to happen.
regards
--
Rafael Martinez, [EMAIL PROTECTED]
Center for Information Technology Services
University of Oslo, Norway
PGP Public
On Tue, 2006-05-30 at 09:45 -0400, Tom Lane wrote:
Rafael Martinez, Guerrero [EMAIL PROTECTED] writes:
The problem was that 000100080010.0006D5E8.backup was
already archived, but under pg_xlog/archive_status/ there were two
files
some
time. The total running time of the PITR_basebackup script was 2412 sec.
If we get the same problem again, I will try to get more information
from the system. As I said in my last e-mail, this has been a one time
problem.
regards,
--
Rafael Martinez, [EMAIL PROTECTED]
Center for Information
releases. Thanks again!
Thanks to you for finding and fixing the problem :-)
It looks like you are finish so I will update the server and you will
lose access to it.
regards
--
Rafael Martinez, [EMAIL PROTECTED]
Center for Information Technology Services
University of Oslo, Norway
PGP Public Key
to compile:
pg_dbsize.c: In function `relation_size':
pg_dbsize.c:295: too few arguments to function `textToQualifiedNameList'
make: *** [pg_dbsize] Error 1
Is the second parameter back again?
[1]: http://archives.postgresql.org/pgsql-patches/2005-05/msg00307.php
--
Rafael Martinez, [EMAIL
.
--
Rafael Martinez, [EMAIL PROTECTED]
Center for Information Technology Services
University of Oslo, Norway
signature.asc
Description: This is a digitally signed message part
32 matches
Mail list logo