Hi, I've been trying to see whether or not autovacuum is vacuuming all
of my tables, and how often (for my peace of mind). I can see that it is
running, but I don't know what it's doing. There are a handful of key
tables in our database which suffer quite a bit if their not vacuumed
regularly (
On Saturday 08 July 2006 22:34, Michael Glaesemann wrote:
> On Jul 8, 2006, at 9:57 , [EMAIL PROTECTED] wrote:
> > FTS will get more and more important for a DBMS system, i think pgsql
> > should also consider improving this, isn't?
>
> I believe a very common FTS solution used with PostgreSQL is
Douglas McNaught wrote:
rstp <[EMAIL PROTECTED]> writes:
pg_config is telling us that we are running version 7.3.6-RH, but when
we start psql it shows that we are running 8.1.4 (which is the correct
version).
[EMAIL PROTECTED] bin]$ pg_config --version
PostgreSQL 7.3.6-RH
[EMAIL PROTEC
Jaime Casanova writes:
so you want a different logfile for every database you connect to?
An option to specify a log for database.
where do you will log database shared operations like autovacuum, role
creation, maybe even a database creation, tablespace creation, etc...
In a global logfil
Alvaro Herrera wrote:
> > I'm considering building a .so on a scratch machine and copying it to the
> > production server but I'm not confident that I understand every possible
> > implication.
>
> Or maybe you could install the development Perl package, which at least
> on some distros I know inc
Michael Fuhr wrote:
>
> > The other thing that I'm thinking is that it's quite possible that (as
> > hypothetical examples) PL/Perl, PostGIS and PL/R wouldn't be happy on the
> > same machine, at which point the only way to merge their functionality in
> > complex work would be to use a "farm".
>
On 7/7/06, Francisco Reyes <[EMAIL PROTECTED]> wrote:
I am currently using a log with the file name format:
log_filename = 'postgresql-%Y-%m.log'
Is there any way to change the filename do start witht he database name?
For now just added to add the database name to each line, but it would be
us
> With the untrusted version of a language you can do essentially
> anything that language supports. For example, with plperlu, you
> could use DBI to open a connection to another database (even another
> DBMS like Oracle, MySQL, etc.), issue a query, fetch the results,
> and do whatever you want
Marc Haber wrote:
> Please note that exim is so flexible that it is possible to implement
> mail spool storage in an SQL database. In this case, we'd write data
> which originated in an untrusted source to the database, not knowing
> about encoding at all.
If you are going to store things in mult
Mark Morgan Lloyd wrote:
> Thanks for that. One of the reasons that I am contemplating this is that when
> I
> built the server it wouldn't build PL/Perl since the underlying distro didn't
> provide a libperl.so file. Now I could obviously recompile the distro's Perl
> sources but that would mean
On Sun, Jul 09, 2006 at 06:16:48PM +0200, Marc Haber wrote:
> > I'd suggest adding a PQsetClientEncoding(conn, "Latin1") right after
> > you establish a connection. I'm not sure if Exim has any kind of
> > declaration about what encoding strings have internally.
>
> No, it does not.
That's your f
* Martijn van Oosterhout:
> * If application always sends untrusted strings as out-of-line
> parameters, instead of embedding them into SQL commands, it is not
> vulnerable.
This paragraph should explictly mention PQexecParams (which everybody
should use anyway).
It seems that Exim's archite
On Sun, Jul 09, 2006 at 03:00:08PM +, Mark Morgan Lloyd wrote:
> The other thing that I'm thinking is that it's quite possible that (as
> hypothetical examples) PL/Perl, PostGIS and PL/R wouldn't be happy on the same
> machine, at which point the only way to merge their functionality in complex
Hi,
On Fri, Jul 07, 2006 at 05:15:11PM +0200, Martijn van Oosterhout wrote:
> On Fri, Jul 07, 2006 at 03:48:00PM +0200, Marc Haber wrote:
> > From what I understand, the correct way would be to use
> > PQescapeStringConn, but that function needs an established connection,
> > and exim performs str
On Fri, Jul 07, 2006 at 04:53:14PM +0200, Martijn van Oosterhout wrote:
> On Fri, Jul 07, 2006 at 03:48:00PM +0200, Marc Haber wrote:
> > I am the maintainer of Debian's packages for exim4, a powerful and
> > versatile Mail Transfer Agent developed in Cambridge and in wide use
> > throughout the Fr
On Sun, Jul 09, 2006 at 12:40:56PM +, Mark Morgan Lloyd wrote:
> I know that the FAQ says that the only way to implement a query
> across databases is to use dblink,
The FAQ doesn't say dblink is the only way, it says "contrib/dblink
allows cross-database queries using function calls." Howeve
Merlin Moncure wrote:
>
> > Similarly, if I have PostGIS or PL/R on the hacker's server, or- heaven
> > forfend- both, is the best way to get at the production server still to use
> > dblink?
>
> dblink allows you to send queries from one server to another in a
> couple of different ways. What th
On 7/9/06, Mark Morgan Lloyd <[EMAIL PROTECTED]> wrote:
I know that the FAQ says that the only way to implement a query across databases
is to use dblink, is this the only way available if additional procedural
languages are installed?
For example, assume I have a production server A that does n
I know that the FAQ says that the only way to implement a query across databases
is to use dblink, is this the only way available if additional procedural
languages are installed?
For example, assume I have a production server A that does not have PL/Perl
installed, and a hacker's server B (let's
On Sat, Jul 08, 2006 at 11:02:26PM -0700, Richard Broersma Jr wrote:
> > > > 3. If you call currval() will it return 20? I would think it does.
> >
> > Yes it does.
> >
> > > My understanding is that it will provided your are within a transaction.
> >
> > As long as you're in the same session
Richard Broersma Jr <[EMAIL PROTECTED]> writes:
> Just to clarify, currval() is isolated by the session on not
> necessarily by a transaction?
Yes, this is spelled out quite clearly in the docs if you care to read
them. :)
-Doug
---(end of broadcast)
rstp <[EMAIL PROTECTED]> writes:
> pg_config is telling us that we are running version 7.3.6-RH, but when
> we start psql it shows that we are running 8.1.4 (which is the correct
> version).
> [EMAIL PROTECTED] bin]$ pg_config --version
> PostgreSQL 7.3.6-RH
> [EMAIL PROTECTED] bin]$ which p
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Carlos H. Reimer
> Sent: 09 July 2006 12:17
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Mobile servers replication
>
> Hi,
>
> We´re looking for a replication solution that could add
Hi,
We´re looking for a replication solution that could address the following
situation: every morning our sellers connect to the master server and make a
copy of all tables they will need during the day to their laptop database.
After a day of work, with a lot of work done at their local database
# [EMAIL PROTECTED] / 2006-07-07 14:08:08 -0600:
> --On July 7, 2006 12:35:53 PM + Roman Neuhauser <[EMAIL PROTECTED]>
> wrote:
>
> ># [EMAIL PROTECTED] / 2006-07-06 22:41:27 -0600:
> >>OK I know this is an odd question but I'm working on an app that will
> >>rely more and more on database d
25 matches
Mail list logo
