Hi, first of all thanks for postgresql, it has never given a problem
and is performing great.
Now my question: my employer wants to do backups every 12 hours, and
save the logs evry 2 hours to... Can I simply save the logs
(cp pg_xlog/* ...) or do I need something more elaborate?
Now in a restor
[EMAIL PROTECTED] wrote:
Hi, first of all thanks for postgresql, it has never given a problem
and is performing great.
Now my question: my employer wants to do backups every 12 hours, and
save the logs evry 2 hours to... Can I simply save the logs
(cp pg_xlog/* ...) or do I need something more ela
On this issue,
Is a good idea to ln -s the pg_xlog directory onto another place, while the
postmaster is running?
I agree with pablo, documentation at this point is not easy to found.
Regards,
> [EMAIL PROTECTED] wrote:
>
> > Hi, first of all thanks for postgresql, it has never given
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
G u i d o B a r o s i o wrote:
| On this issue,
|
|
|
|Is a good idea to ln -s the pg_xlog directory onto another place, while the
postmaster is running?
I don't think so
| I agree with pablo, documentation at this point is not easy to found.
What I meant(And I guess that Pablo asked for this also), was that is not easy to
found information or howto work on the pg_xlog directory.
I didn't take it as "read the FINE manual" anyway ;)
Regards,
Guido
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> G u i d o B a r o s i o wrote:
Hola a todos,
Tengo una inquietud sobre el porstgres, soy nuevo
en esto y no se como hacerlo.
Tengo una base de datos maestra en PostgreSQL
V7.4.3 sobre Linux Red Hat 9, de la cual a cada usuario le genero un dump con la
estructura y alguna data de la misma y se las importo en sus notebook
The server is running Postgres 7.4.1 on Linux.
I tried to do a "vacuum pg_attribute" but its taking a while (I guess because of the size- abt 2GB) and the load on the server is going very high. Because of this the database server is not responding. So I killed the psql session.
1) Can you tell
Dear all,
Any hints on how to estimate a downtime performing a reindex on a postgres
standalone?
Thanks in advance.
Guido
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
[EMAIL PROTECTED] writes:
> Now my question: my employer wants to do backups every 12 hours, and
> save the logs evry 2 hours to... Can I simply save the logs
> (cp pg_xlog/* ...) or do I need something more elaborate?
You can't realistically do this in any pre-8.0 release; it's perhaps
doable in
kris pal <[EMAIL PROTECTED]> writes:
> * So how can I REINDEX this one ?
Read the REINDEX man page. There are special hoops you have to jump
through when reindexing system catalogs (fewer in more recent versions,
but I forget what you are running. Anyway be sure to read the manual
*for your vers
[EMAIL PROTECTED] (kris pal) writes:
> The server is running Postgres 7.4.1 on Linux.
>
> I tried to do a "vacuum pg_attribute" but its taking a while (I guess because of the
> size- abt 2GB) and
> the load on the server is going very high. Because of this the database server is
> not responding.
>>> 1) Can you tell me if there is any other work around to vacuum the>> pg_attribute system table ? Like doing it in parts so that it won't> >cause a high load.
Chris Browne <[EMAIL PROTECTED]> wrote:>No, you need to let the vacuum finish. >If you stop it early, it'll jus
G u i d o B a r o s i o wrote:
Dear all,
Any hints on how to estimate a downtime performing a reindex on a postgres standalone?
Depends on hom much the tables are big, and on your HW too.
One question, why do you habe to do it in standalone ?
Regards
Gaetano Mendola
---(e
After a long battle with technology, [EMAIL PROTECTED] (kris pal), an earthling, wrote:
>
>
>>
>>> 1) Can you tell me if there is any other work around to vacuum the
>>> pg_attribute system table ? Like doing it in parts so that it won't
>> >cause a high load.
>
> Chris Br
Hi All,
I have installed Fedora 2 (linux) on my system with
database postgresql. I have done initdb and createddb
and created all the tables. Till that it was
successful. It worked fine for one day. the next day
when I started the database and tried to do psql
I got an error "psql: error while
loa
Hi
My biggest bugbear with Postgresql is the double quoting when writing
functions. Has anyone suggested a possible syntax such as :-
create or replace function sp_AddContact(varchar)
returns integer from '' LANGUAGE 'plpgsql';
This would remove the issue with parsing for begin...ends (or whate
Thanks for the advice. I'll relax the constraints on the table, and
reload that table from the dump, might take a while to fix any problems,
but it should be safer.
Regards, Andrew
Tom Lane wrote:
Andrew Farmer <[EMAIL PROTECTED]> writes:
My question is, if I load the good dump into a clean
When connecting from a psql client version xyz to a postgresql server
version zyx across the network, what are the rules to follow for
assuring compatibility between different versions?
For example, is it possible to connect from psql 7.2.x to postgresql
server 7.4.x?
Thank you. Kind regards,
I AM TOTALLY FRUSTRATED. Every time I send something to the list, it
gets stalled, saying I am not a proper member. I've been on the list
for a long time, and never had this problem before. I write and and
write and nobody can help me!!!
Please! Can you help me?
Frederic M
Hello you out there,
I'm having some strange problem with a server postgresql 7.4.3, some times
the server crashes and restarts inmediatly, heres is the error message
catch from the log file
ERROR: cache lookup failed for namespace 105183855
LOG: server process (PID 3942) exited with exit code
Frederic Massot wrote:
> Hi,
>
> How can I know the size of the database on a server Postgresql 7.3.4 ?
>
> Regards.
try contrib/dbsize
Its a bit of a pain, but better than nothing.
--
-
Naomi Walker
Kieran McCusker wrote:
Hi
My biggest bugbear with Postgresql is the double quoting when writing
functions. Has anyone suggested a possible syntax such as :-
create or replace function sp_AddContact(varchar)
returns integer from '' LANGUAGE 'plpgsql';
No, but in the near future with 8.0 version you
Christopher,
Thanks for your detailed response. Now I get the idea why vacuum is causing so much load. We should have vacuumed the database more often but didn't do it as we are more used to managing Oracle databases. This is the first Postgres instance that I am managing.
The datafile for pr
23 matches
Mail list logo
