On Fri, 2006-03-24 at 17:43, Jim C. Nasby wrote:
>
> Therein lies part of the problem: enough disk space. Now that we're
> seeing more and more use of PostgreSQL in data warehousing, it's
> becomming less safe to assume you'll have enough disk space to fix bloat
> on large tables. Plus I suspect
Please can anyone help me here? I've been so frustrated.:( If there is
auto-created password
> for this auto-created postgres user, please anyone tell me what it is?? And
> also otherwise, how
> can I log-in using the "ident auth" method??
If you just getting started with postgresql you will
Hi,
We are trying to setup PITR system based on documentation
http://www.postgresql.org/docs/8.1/interactive/backup-online.html
We have 3 questions regarding
1. Selection of archived WAL records that can be safely removed.
2. Knowing the relevant WAL record just after pg_stop_backup()
3. Recomme
Hi,
Sorry last posting was accidently sent , incomplete,plese ignore.
We are trying to setup PITR system based on documentation
http://www.postgresql.org/docs/8.1/interactive/backup-online.html
We have 3 questions regarding
1. Selection of archived WAL records that can be safely removed.
2. Kno
QUOTE:
Exactly this issue and that you have to make a 'full' dump/restore
between major release is a big minus I hear everywhere I
explain/discuss about postgres for 24/7 and big databases.
END QUOTE
Yes but how often does a major release come out? 17th Jan 2005 wa
we want to remove
archived WAL log files which are no longer needed
so that the size of wal_archive folder is under control.
The DOCs say that filenames numerically less than the WAL record that
pg_stop_backup()
suggests can be removed. Will an alphabetical sorting be different from
numeri
"Andy Shellam" <[EMAIL PROTECTED]> writes:
> The DOCs say that filenames numerically less than the WAL record that
> pg_stop_backup() suggests can be removed. Will an alphabetical sorting
> be different from numerically sorted filename ?
If you're worried about that, try "LANG=C ls ..." to make su
Hi,
Thanks everyone for the reply,
is it reasonable/advisable to start with the output of
pg_stop_backup() in a shell script to find the WAL
file being discussed, ie the FILE which can be used
as a reference for removing the older files ?
secondly , i was asking about the tool for copying the
da
Hi Rich,
Thank you very much!! Have some further question:
> Please can anyone help me here? I've been so frustrated.:( If there is
> auto-created password
> > for this auto-created postgres user, please anyone tell me what it is?? And
> also otherwise, how
> > can I log-in using the "ident
On Tue, Mar 28, 2006 at 03:54:30PM +0100, Andy Shellam wrote:
> QUOTE:
> Exactly this issue and that you have to make a 'full' dump/restore
> between major release is a big minus I hear everywhere I
> explain/discuss about postgres for 24/7 and big databases.
> END QUOTE
>
On Mon, Mar 27, 2006 at 09:28:43AM -0800, Sriram Dandapani wrote:
> I was referring to the logs in the archive folder specified when WAL
> archiving is turned on...not the pg_xlog folder.
>
> I assume postgres will not use the logs in the archive folder
Correct. And I believe if you have PITR ena
On Mon, Mar 27, 2006 at 06:32:42PM -0800, Mark Liberman wrote:
> So, I have finally complete this auto-pruning solution. It has proven
> effective in keeping the size of the db under whichever threshold I set in an
> unattended fashion.
>
> I have one final question. If my goal is to maximize
> How should I do this? The current auto-generated pg_hba.conf file read as:
> "local all postgresident sameuser"
> on the first line, and the first line also after the # TYPE
> DATABASEMETHOD line.
>
>
> Do you mean I should change the "ident sameuser" at the end to "trust"?
Belo
Title: RE: [ADMIN] Feedback on auto-pruning approach
> Probably your biggest issue will be temporary files created by temporary tables, sorts that spill to disk, etc.
Is there any way to monitor this so I can estimate?
> What I'm confused by is the concern about disk space in the first plac
On Tue, 2006-03-28 at 12:23, Mark Liberman wrote:
> > Probably your biggest issue will be temporary files created by
> temporary tables, sorts that spill to disk, etc.
>
> Is there any way to monitor this so I can estimate?
>
> > What I'm confused by is the concern about disk space in the first
>
On Tue, Mar 28, 2006 at 10:23:45AM -0800, Mark Liberman wrote:
> > Probably your biggest issue will be temporary files created by temporary
> > tables, sorts that spill to disk, etc.
>
> Is there any way to monitor this so I can estimate?
Keep an eye on $PGDATA/base/{database_oid}/pgsql_tmp.
>
Could RRS be implemented in a similar fashion to OPC-HDA?
Regards,
Richard
--- "Jim C. Nasby" <[EMAIL PROTECTED]> wrote:
> On Tue, Mar 28, 2006 at 10:23:45AM -0800, Mark Liberman wrote:
> > > Probably your biggest issue will be temporary files created by temporary
> > > tables, sorts that
> spi
I just want to make sure that I've got a good enough understanding of
the built-in on-line backup facility to be able to minimize data loss
and unavailability of the database during a remote recovery from on-
line backup.
Here are the steps I'm proposing:
1. Set up archive_command in postgr
On Tue, 2006-03-28 at 12:09 -0600, Jim C. Nasby wrote:
>
> Fortunately, you can use Slony to migrate between versions, greatly
> reducing downtime.
Yes, this is true, but the problem is that if the database is 'big' and
running in an expensive system you need to double your investment only
for t
On Tue, Mar 28, 2006 at 10:42:13AM -0800, Richard Broersma Jr wrote:
> Could RRS be implemented in a similar fashion to OPC-HDA?
I'm not really familiar with that. The idea behind RRS is that you keep
historical information, but you don't keep the detailed data, similar to
how RRD works.
--
Jim C
On Tue, 2006-03-28 at 13:51, Rafael Martinez wrote:
> On Tue, 2006-03-28 at 12:09 -0600, Jim C. Nasby wrote:
>
> >
> > Fortunately, you can use Slony to migrate between versions, greatly
> > reducing downtime.
>
> Yes, this is true, but the problem is that if the database is 'big' and
> running
I am trying to set up a persistent connection to a handful of postgres dbs
at startup using Apache::DBI (also using mod_perl)
Here is what I am doing but I am not sure how to check if it's working
right.
in httpd.conf I have
PerlRequire startup.pl
in startup.pl I load all the necessary perl mo
> > How should I do this? The current auto-generated pg_hba.conf file read as:
> > "local all postgresident sameuser"
> > on the first line, and the first line also after the # TYPE
> > DATABASEMETHOD
> line.
> >
> >
> > Do you mean I should change the "ident sameuser" at the end t
On Tue, 2006-03-28 at 15:15 -0600, Scott Marlowe wrote:
> On Tue, 2006-03-28 at 13:51, Rafael Martinez wrote:
> > On Tue, 2006-03-28 at 12:09 -0600, Jim C. Nasby wrote:
> >
> > >
> > > Fortunately, you can use Slony to migrate between versions, greatly
> > > reducing downtime.
> >
> > Yes, this
On Wed, Mar 29, 2006 at 01:05:59AM +0200, Rafael Martinez wrote:
> I work with postgresql every day and I am very happy with it, but this
> does not mean I can not see the issues that could be improve to have a
> even better open source DBMS. And I think in my humble opinion that
> bloated indexes
lmyho wrote:
Some examples of pg_hba.conf entries are shown in Example 19-1. See the next
section for details on the different authentication methods.
Thank you Richard!! I've made the changes and can login to the DBs through
pgAdmin
now!:) Really appreciated your help!!! I am star
> >
> >
> >>Some examples of pg_hba.conf entries are shown in Example 19-1. See the next
> >>section for details on the different authentication methods.
> >>
> >
> The authentication methods are handled between the libraries (libpq and
> libpxx) and the server. They are transparent to the ap
Hello admins!i need to collect as much informationpro/cons on a possible upgrade from7.4 ---> 8.0/8.1 versionAside from getting our users vote on this, I wanted to ask you firstin order to collect any possible issues one might run into from upgrading to suchversions.Thanks in advance!
Yahoo! Me
On Tue, 2006-03-28 at 19:47, sh test wrote:
> Hello admins!
>
> i need to collect as much information
>
> pro/cons on a possible upgrade from
>
> 7.4 ---> 8.0/8.1 version
>
> Aside from getting our users vote on this, I wanted to ask you first
> in order to collect any possible issues one might
lmyho wrote:
Some examples of pg_hba.conf entries are shown in Example 19-1. See the next
section for details on the different authentication methods.
The authentication methods are handled between the libraries (libpq and
libpxx) and the server. They are transparent to th
Scott Marlowe wrote:
On Tue, 2006-03-28 at 19:47, sh test wrote:
Hello admins!
i need to collect as much information
pro/cons on a possible upgrade from
7.4 ---> 8.0/8.1 version
Aside from getting our users vote on this, I wanted to ask you first
in order to collect any possible issues o
31 matches
Mail list logo
