need so many standbys?
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
Phone: +593 4 5107566 Cell: +593 987171157
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.
e 11, and postgres database is at
> version 9.0.4.
>
you really need to upgrade to 9.0.12, you can upgrade very easily when
the first 2 numbers (9.0) are the same
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
Phone: +593 4 5107566
ntil the next
postgresql minor version to be released
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
Phone: +593 4 5107566 Cell: +593 987171157
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to
municating with a master through the streaming replication protocol. As
> any other standby would do.
>
more to the point...
if this is happening on master (where you can create and drop
databases), then repmgrd has no reason to be running there... and very
limited subset of commands (master
>new_data" seems better and i
guess you can use hstore functions on it
(http://www.postgresql.org/docs/9.0/static/hstore.html)
The other one uses arrays to store column names, old values, new
values, still more parseable
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL:
On Wed, Aug 10, 2011 at 9:51 AM, A J wrote:
> What are the tentative release dates of 9.1 and 9.2 versions ?
about 9.1:
http://archives.postgresql.org/message-id/19869.1312298...@sss.pgh.pa.us
9.2 is just starting its dev cicle, it will be released next year
--
Jaime Casanova
le)
but you shouldn't be setting synchronous_commit on postgresql.conf
normally but from the application
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make chan
On Sun, Mar 20, 2011 at 10:38 PM, jonathan ferguson wrote:
> hi.
>
> On Mar 20, 2011, at 9:05 PM, Jaime Casanova wrote:
>
>> On Sun, Mar 20, 2011 at 8:04 PM, Jaime Casanova
>> wrote:
>>> On Fri, Mar 18, 2011 at 4:25 PM, John P Weatherman
>>> wrote:
On Sun, Mar 20, 2011 at 8:04 PM, Jaime Casanova wrote:
> On Fri, Mar 18, 2011 at 4:25 PM, John P Weatherman
> wrote:
>>
>> Has anyone run into this already and have an idea for a work around? I
>> am primarily an Oracle guy and in that environment I would set up a
&g
odule dblink for this:
http://www.postgresql.org/docs/9.0/static/dblink.html
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte y capacitación de PostgreSQL
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscr
yet released) as a contrib module
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte y capacitación de PostgreSQL
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
hat info is on the standby, you need to execute pg_controldata on the
standby and read the Latest checkpoint location, IIRC...
then, from that you can now what the segment you need is, but you have
to look for it on the master
--
Jaime Casanova www.2ndQuadrant.com
Professional Pos
p; restore the only real way to do this?
>
it's safe to just install any version of 8.2.x, copy the whole data
directory (plus any tablespace's directories you could have) and start
again... probably you want to REINDEX your indexes (read the release
notes to see what specific kind of in
/objects/PostgreSQL/8.4/data"
>
>
>
> I have checked the archives but did not see any solution so far.
>
> The data directory does have inheritable permissions for user postgres to
> read, write, modify etc.
>
>
are you executing the installer with a privileged user?
ur user doesn't have
enough permissions
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
e column change happen. How
> safe if this and would potentially cause any corruption?
>
no, that's insane
>
> 4) Is there a more practical and safe method to alter a huge table
> with reasonable amount of time?
>
>
use text fields instead of varchar(n)
--
Atenta
aces path could be a problem too...
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.pos
On Tue, Oct 20, 2009 at 10:56 AM, Tom Lane wrote:
> Jaime Casanova writes:
>> On Tue, Oct 20, 2009 at 9:25 AM, Tom Lane wrote:
>>> OS per se shouldn't matter
>
>> unless you try to do it between windows and some flavor of linux
>
> hmmm ... even ther
On Tue, Oct 20, 2009 at 9:25 AM, Tom Lane wrote:
> OS per se shouldn't matter
>
unless you try to do it between windows and some flavor of linux
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +5938717115
ances of postgresql running? if so, you only
have to vacuum the one that is giving you troubles...
> vacuum;
you execute this inside psql... rigth?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
s error can you show what were you doing?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www
nd now the
autovacuum is integrated so things are a lot better
--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Guayaquil - Ecuador
Cel. (593) 87171157
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
ctions-admin.html#FUNCTIONS-ADMIN-DBSIZE
else
there is a contrib/dbsize
end if
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Guayaquil - Ecuador
Cel. (593) 087171157
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription
ser "postgres" or the DB role "postgres"?
if the former you tell that to your sysadmin in order to him to reset it...
then change the pg_hba.conf file and put trust as the method
authorization for local access or maybe sameuser then reset it with
ALTER ROLE
of course, you nee
do que el problema es
el que mencione arriba, no se me ocurre que mas pudo ser...
--
Atentamente,
Jaime Casanova
"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
es esta?
ejecutas vacuum o vacuum full regularmente?
--
Atentamente,
Jaime Casanova
"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
On 2/7/07, Ezequiel Luis Pellettieri <[EMAIL PROTECTED]> wrote:
thanks guys, is it possible to go with it, without stopping the postmaster?
maybe just rejecting conns to the DB...
this is cos I had another DB's running...
thanks again.
AFAIR, no
--
regards,
Jaime Casanova
&
es...
you shoukd think in upgrading... ;)
--
regards,
Jaime Casanova
"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, th
ce (2 or 3 years ago)
is that a pg_dump and/or reindex will return all to it's original
state...
--
regards,
Jaime Casanova
"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idio
sql.org/docs/8.1/interactive/sql-alterindex.html
ALTER INDEX name SET TABLESPACE tablespace_name
Haven't tried this for my own, so take care (and test).
i think we should add: "in >= 8.1"
--
regards,
Jaime Casanova
"Programming today is a race between software engineers striving
On 6/13/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Jaime Casanova wrote:
> On 6/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>> In a function implemented in 7.4.8 I had the following error when I call
>> the function:
>>
>> ERROR: syntax error
ved, all is well.
that's because that construction was added in 8.0, you have to upgrade to use it
--
regards,
Jaime Casanova
"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and
ervice with that account(postgres)
any hits are appreciated
Regards
Jeff
the installation completes? if so, try to start the service by hand
and show the error (eventlog should have a description)
--
Atentamente,
Jaime Casanova
"Programming today is a race between software engineers strivin
he
server...
it also install some pgadmin support functions by default...
just ignore warnings works for me because i don't use most of these
things, and for plpgsql i create it by hand in linux before run the
script generated by pg_dump
--
regards,
Jaime Casanova
(DBA: DataBase Aniquila
rom machine A and paste it in machine B
(previously you must be deleted the machines B's data directory or at
least its contents)
- start service in machine B
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
gger than just go and do it. :(
>
ahh... then execute it once a week or once a day, for avoid excessive growing...
> Thanks
> Szabek
>
>
--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
ain.
>
> What more needs to be done ?
>
> TIA,
> Eran
>
i guess you remove the # symbol in front of that line
--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
ed before the
> isolation level was set Is this correct? Any transactions that are commited
> while the backup is running are not seen by pg_dump.
>
> Correct?
>
> Thanks,
>
> Chris
>
correct
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On 1/9/06, Chris Hoover <[EMAIL PROTECTED]> wrote:
> I'm trying to understand better what happens to a transaction that is
> commited in the middle of a pg_dump. Is the transaction included in the
> database dump, or is it excluded.
>
AFAIK, it's excluded...
--
HI,
is there a site where we can see all technical papers that postgresql
is based on?
i mean algorithm and other stuff related...
if not is worth the effort to maintain such a site?
some of us live in countries where this kind of info is very difficult to get...
--
regards,
Jaime Casanova
ing every weekend a full analyze, but actually i think it's
> need again, but just for feel i couldn't stop the server.
> I need evidence. (oldspice rulez ;))
>
> Szabek
a plain VACUUM (without full) is enough in most cases... and you don't
need to stop the server for a plain V
Szabek
VACUUM is needed at least every billion transactions...
execute it in a script periodically... if you are in doubt if you need
VACUUM then you need it urgently, execute it right now!!!
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---(end of broadcast)---
t know if this is enough.
> Thanks
>
look at the postgresql logs...
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index sc
help with the little info you are giving us...
--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PRO
ed our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
>
> ---(end of broadcast)---
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column
that you have?
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
note: I can't forbid a "too fast" connections by IP because they come
> throught firewall.
>
> Thanks,
> Szabek
>
>
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---(end of broadcast)---
TIP 1: if posting/reading
sist you can send info about the
query, tables (and views) involved, indexes, explain analyze (from
7.3.8 if possible, and from 7.4.2)...
> Regards
> Nirmal
>
>
> --- Jaime Casanova <[EMAIL PROTECTED]> wrote:
>
> > On 11/21/05, Nirmal Kumar <[EMAIL PROTECTED]
low?
had you run VACUUM ANALYZE (or ANALYZE at least) recently?
it's all the system that slow or just queries? (maybe it is a problem
of lack of resources)
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---(end of broadcast)--
g(32) | not null
> curr_size| bigint | not null default 0
> vol_num | integer| not null
> start_time | integer |
> stop_time| integer|
> Indexes:
> "volumes_i1" unique, btree (label)
>
>
> Secondly does anyone know a way to insert a column instead of
> appending a column to a table. That way I could just avoid the
> entire mess.
>
http://archives.postgresql.org/pgsql-hackers/2004-09/msg00102.php
--
Regards,
Jaime Casanova
(DBA: DataB
lo haremos para informarte eso, al menos en las listas en
ingles.
PD: Podrias mandar a la lista en español, la definicion de tu tabla?
Hicistes la prueba que te sugirio Alvaro de ingresar via script para
confirmar si el problema es el pgAdmin y no el postgres?
--
Atentamente,
Jaime Casanova
(DBA: DataB
t of memory, 53300 too many connections), class 57
> operator intervention, class 58 system error, and a few others.
>
I don't know if it can be useful for you but there is a project called
pgMail. You need he pl/tclu to run it.
hope it can help you.
regards,
Jaime Casa
vacuum
> verbose commands ?
>
maybe
select count(*) from pg_class where relname like
'some-prefix-youuse%';
but you need to do this per-database. besides your
tables must have a prefix to identify them if they
have not maybe the owner if it is postgres,
--- Tom Lane <[EMAIL PROTECTED]> escribió:
> Jaime Casanova <[EMAIL PROTECTED]> writes:
> > => select to_ascii('Jiménez');
> > will retrieve 'Jimenez' at least it works on
> Latin1
> > encoding.
>
> > Why it not work on Lat
Hi,
someone show me that if had accents in a word i can
suppress it with the to_ascii function.
=> select to_ascii('Jiménez');
will retrieve 'Jimenez' at least it works on Latin1
encoding.
Why it not work on Latin9, there's another way of
doing such a thi
mmand are displayed on to the
> screen. In one file I am
> trying to populate a table with values ( There are
> more than 5000 tuples to
> be inserted).
> When I run this command, it displays the results on
> to the screen which I
> don't want to do.
> Could anyone help
ww.postgresql.org/docs/7.4/static/queries-table-expressions.html#QUERIES-JOIN
What do you mean with *complex joins*?
regards,
Jaime Casanova
_
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticia
n should be done at the PERFORMANCE
list.
What about creating the index on the extract
expresion?
CREATE INDEX tuIndice ON correo (date_part('year',
fecha));
I found the other way i suggested in the spanish list
is not correct (sintax) but this way it works (i have
proved it).
rega
#x27;s not the same thing) that
when you drop and recreate the database.
Here is an explanation why VACUUM is necessary:
http://www.postgresql.org/docs/7.4/interactive/maintenance.html
Here you can find some other performance-tips:
http://www.postgresql.org/docs/7.4/i
conf, but i said info about your database,
your tables and data is needed.
Maybe the PERFORMANCE list is more adecuate.
>
> Thx
> berger
>
>
you welcome.
regards,
Jaime Casanova
_
Do You Yahoo
t how to make it. Can someone help me?
>
> Use ALTER DATABASE to set per database defaults.
>
Hi,
set the parameter in the postgresql.conf
Regards,
Jaime Casanova
_
Do You Yahoo!?
Información de Estados Unidos y América Latina,
--- Stephan Szabo <[EMAIL PROTECTED]>
escribió:
>
> On Mon, 20 Sep 2004, Jaime Casanova wrote:
>
> > There is a way to not enforce the creation of a
> > primary or unique index on a referenced table?
>
> Not really. It's not the index that's impo
ique index on a referenced table?
(I mean, a way that not involves the use of a "set"
instruction because the odbc not allow such
instructions)
Thanx in advance,
Jaime Casanova
_
Do You Yahoo!?
Información de Estados Unidos y
Hello,
Db-designer is a nice tool, can work with importing Oracle databases, and
use it with PG and >MySQL.
Hope this helps
BR,
Miguel
Can someone suggest an E-R tool that will read a _PG_ database and create
an E-R diagram - crows feet and all? Are there any that are available for
free?
Thank
sorry if my questions are so primitive or show all my poor knowledge but ask
is the way to find the right path. the dumber the question the smarter i
will become.
_
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
http://j
hi all, again.
i can't find how can i store bynary fields (images, ¿¿pdfs?? is it
possible?) in postgres. i'm using vb as frontend.
any help??
thanx in advance,
Jaime Casanova
_
Tired of spam? Get advanced junk mail
hi all, there is a way to use my own index with pk constraint instead of the
implicitly created one?
why? just because i don't like the name, maybe can i change the generated
name?
thanx in advance,
Jaime Casanova
_
Help STOP
nd it give me the
results. maybe aproblem of the odbc, if yes what solution can be.
thanx in advance,
Jaime Casanova
_
Help STOP SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/jun
ok. if i don't misunderstand you (english is not my mother tongue, so i can
be wrong). your point is that speed is not necesarily performance, that's
right.
so, the real question is what is the best filesystem for optimal speed in
postgresql?
___
Can you tell me (or at least guide me to a palce where i can find the
answer) what are the benefits of filesystems over raw devices?
And what filesystem is the best for postgresql performance?
_
The new MSN 8: advanced junk mail pro
Hi, all.
I was thinking about using postgresql and want to know if i can use raw devices with it? if it is possible, how i can configure it? and what are your opinions about postgresql performance on raw devices.
thanx in advance, el_vigiaHelp STOP spam with the new MSN 8 and get 2 months
what is the solution you recommend?
also i was thought that even when DBMS support dbspaces DELETEing records
may
cause data fragmentation anyway.
so, can i think of DELETE statement as a double-edged sword?
it is indifferent in pgsql - it doesn't support dbspaces anyway?
thanks in adva
Hi everybody, can anyone tell me if there's a way to retrieve the select
instruction executed from the catalogs, or maybe via some structure in a
trigger?
The reason is that i have some selects constructed on-the-fly (just part of
it) and i want to save that in a table in order to know what are
74 matches
Mail list logo