Hi,
WHen i run pg_dumpall as the super user [postgres in my case] it asks
for a password for every database. I don't know my users passwords. Is
there a way to make the super user able to backup without passwords ?
Thanks.
Jeff.
---(end of broadcast)---
Jeff wrote:
> Dave Weaver wrote:
> > For instance:
> > SELECT station, air_temp FROM obs
> > WHERE station = 'EGBB'
> > AND valid_time > '28/8/03 00:00'
> > AND valid_time < '28/10/03 00:00'
> >
> > takes 4 mins 32 secs.
>
> How many rows should that return?
> [expla
> > For instance:
> > SELECT station, air_temp FROM obs
> > WHERE station = 'EGBB'
> > AND valid_time > '28/8/03 00:00'
> > AND valid_time < '28/10/03 00:00'
> >
> > takes 4 mins 32 secs.
How many rows should that return?
[explain analyze will tell you that]
and wh
On Thu, 30 Oct 2003, Scott Chapman wrote:
> On Thursday 30 October 2003 06:38, scott.marlowe wrote:
> > On Wed, 29 Oct 2003, Scott Chapman wrote:
> > > In my further discussion with Andrew offline, we came up with a joint
> > > suggestion to have PostgreSQL do automatic auditing. This would be VE
Tom Lane wrote:
> Harald Fuchs <[EMAIL PROTECTED]> writes:
> > Tom Lane <[EMAIL PROTECTED]> writes:
> >> 7.4's pg_dump has an option to dump the contents of just one schema.
>
> > The pg_dump manpage of beta4 does not include this option,
>
> Sure it does:
>
> -n namespace
> --schema=schema
>
>
Harald Fuchs <[EMAIL PROTECTED]> writes:
> Tom Lane <[EMAIL PROTECTED]> writes:
>> 7.4's pg_dump has an option to dump the contents of just one schema.
> The pg_dump manpage of beta4 does not include this option,
Sure it does:
-n namespace
--schema=schema
Dump the contents of schema only.
On Wed, 29 Oct 2003, Scott Chapman wrote:
> In my further discussion with Andrew offline, we came up with a joint
> suggestion to have PostgreSQL do automatic auditing. This would be VERY
> NICE, imho. Any input?
>
> Scott wrote:
> > It seems like it would be nice if you could flip a toggle o
On Wed, 29 Oct 2003, Allen Landsidel wrote:
> Here's maybe a silly question, but I haven't seen it asked or answered
> so.. For those settings in the .conf file that say "this doesn't take
> effect until the database is restarted".. does that mean that "pg_ctl
> reload" also does not reload th
On Thursday 30 October 2003 06:38, scott.marlowe wrote:
> On Wed, 29 Oct 2003, Scott Chapman wrote:
> > In my further discussion with Andrew offline, we came up with a joint
> > suggestion to have PostgreSQL do automatic auditing. This would be VERY
> > NICE, imho. Any input?
> >
> > Scott wrote:
Tino Wildenhain wrote:
Hi,
Alexander Deruwe schrieb:
Hey,
I was wondering if it is possible to send email from within PL/pgsql.
I'd like to do this to avoid code duplication in multiple frontends.
Can this be done somehow? Or do I have to write a C function for this
purpose? If so, how does on
On Thu, 30 Oct 2003, Dave Weaver wrote:
> Jeff wrote:
> > Dave Weaver wrote:
> > > For instance:
> > > SELECT station, air_temp FROM obs
> > > WHERE station = 'EGBB'
> > > AND valid_time > '28/8/03 00:00'
> > > AND valid_time < '28/10/03 00:00'
> > >
> > > takes 4 mi
On Thu, 30 Oct 2003, Scott Marlowe wrote:
> "It's far more likely that optimizing your SQL queries will yield the
> greatest increase in performance. Things like replacing "select max(id)
> from table" with "select id from table order by id desc limit 1" etc..."
When I first read this I was su
"Dave Weaver" <[EMAIL PROTECTED]> writes:
> Is the upgrade likely to make a difference?
I'm not sure if it would help for this specific query, but in general
each major PG release has useful performance improvements over the
previous one.
What I'm wondering about is an index-bloat problem (see th
> > In the following situation:
> >
> > You do a large transaction where lots of rows are update
> > All of your tables/indexes cached in memory
> >
> > When are the updated rows written out to disk? When they are updated
inside
> > the transaction, or when the transaction is completed?
>
> The da
On Thu, 30 Oct 2003, David Green wrote:
>
> On Thu, 30 Oct 2003, Scott Marlowe wrote:
>
> > "It's far more likely that optimizing your SQL queries will yield the
> > greatest increase in performance. Things like replacing "select max(id)
> > from table" with "select id from table order by id de
On Thu, 30 Oct 2003, Ken Guest wrote:
> Folks,
> I have a question or two regarding PHP and Postgres on the issue of
> speed:
> 1.Is the semicolon at the end of SQL superflous when sent to Postgres?
> Should it make much of a difference if I removed it?
Yes, you can get rid of it. No, it won
Folks,
Stefano is our project's Italian translator. But he's feeling a little
overwhelmed lately. I'd desperately like to find someone to share the
responsibility of English-->Italian translation with him.
Please e-mail me ASAP; even if you can only help out on a one-time basis, this
week,
Hi all,
WE currently use PG for the local database on our POS workstations in shops. Data is
then extracted and sent back to head office. Also product updates etc are regularly
sent to the shops. I have noticed over time that the shop PG databases get slower and
slower. If I do a pg_dump, recre
"Chris Stokes" <[EMAIL PROTECTED]> writes:
> WE currently use PG for the local database on our POS workstations
> in shops. Data is then extracted and sent back to head office. Also
> product updates etc are regularly sent to the shops. I have noticed
> over time that the shop PG databases get slo
"Chris Stokes" <[EMAIL PROTECTED]> writes:
> >The REINDEX is needed because VACUUM doesn't free up index space in
> >some circumstances. 7.4 (currently in late beta) will fix this.
>
> Sorry Doug,
>
> Yes I am doing a vacuum regularly - in fact, when the speed of the
> DB becomes slower, the va
"David Busby" <[EMAIL PROTECTED]> writes:
> List,
> Which of the may Perl Modules on CPAN should I use for PostgreSQL. I'd
> prefer the fastest/most up to date module. Which is it or do I have to dig
> through them all?
The latest DBD::Pg (which I think is now hosted on
gborg.postgresql.org
21 matches
Mail list logo
