> I need to set up a daily cron job that performs a pg_dump on a remote
> database. I can't figure out how to pass a password to it. How do I do
> this. Everything I've tried still comes up with asking me for a password
> when I test it.
>
$ export PGPASSWORD=user_pass
$ echo -e "Would do the tr
Devinder K Rajput wrote:
> Hi,
>
> The TODO list shows that views, queries, etc. across multiple databases are
> to be implemented. when is the latter expected to be completed? Thanks,
Also, 7.3beta has schemas, which may allow you to merge some of your
databases into one database.
--
Bruce
There is /contrib/dblink in 7.3beta that allows one query to get data
from another database.
---
Devinder K Rajput wrote:
> Hi,
>
> The TODO list shows that views, queries, etc. across multiple databases are
> to be impleme
One way is to do this is by configuring the remote server to trust the host
that is going to be doing the back up. This can be done in the pg_hba.conf
file which is located in "/var/lib/pgsql/data" on my server.
If the Server that is going to be doing the back up has the IP address of say
192.16
Hi Folks,
Fairly basic question here, I think. I've looked through the archives, but
can't seem to find anything.
I need to set up a daily cron job that performs a pg_dump on a remote
database. I can't figure out how to pass a password to it. How do I do
this. Everything I've tried still comes up
Hi,
The TODO list shows that views, queries, etc. across multiple databases are
to be implemented. when is the latter expected to be completed? Thanks,
Devinder
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an a
Thanks, worked like a charm.
Danny L. Morgan
-Original Message-
From: bruno [mailto:bruno@;wolff.to]
Sent: Monday, October 28, 2002 4:42 PM
To: dmorgan
Cc: pgsql-admin
Subject: Re: [ADMIN] Sequences
On Mon, Oct 28, 2002 at 14:00:44 -0500,
Danny Morgan <[EMAIL PROTECTED]> wrote:
> I ha
On Mon, Oct 28, 2002 at 14:00:44 -0500,
Danny Morgan <[EMAIL PROTECTED]> wrote:
> I have a strange dilemma. I've created a couple sequences I can't
> remove.
>
> Here is an example
>
> I can
> CREATE SEQUENCE "count1" ..;
> DROP SEQUENCE count1;
>
> I can't
> CREAT
I have a strange dilemma. I've created a couple sequences I can't
remove.
Here is an example
I can
CREATE SEQUENCE "count1" ..;
DROP SEQUENCE count1;
I can't
CREATE SEQUENCE "count1ListItems1" ..;
DROP SEQUENCE count1ListItems1;
It stat
"Peter Darley" <[EMAIL PROTECTED]> writes:
> I got the following error while doing a vacuum full: 'NOTICE: Child itemid
> in update-chain marked as unused - can't continue repair_frag'. I couldn't
> find any corresponding message in the log.
> I couldn't find anything in the archives
Friends,
To answer the obvious question, I'm using PostgreSQL 7.2.1 on
i686-pc-linux-gnu, compiled by GCC 2.96.
Thanks,
Peter Darley
-Original Message-
From: [EMAIL PROTECTED]
[mailto:pgsql-admin-owner@;postgresql.org]On Behalf Of Peter Darley
Sent: Monday, October 28, 2002 9:19 AM
Friends,
I got the following error while doing a vacuum full: 'NOTICE: Child itemid
in update-chain marked as unused - can't continue repair_frag'. I couldn't
find any corresponding message in the log.
I couldn't find anything in the archives except for a message from 2001
that wa
Hi. I have been a happy user of PostgreSQL for some time now. I am
begining a project that, much to my very slight annoyance, will involve
either CLOBs or BLOBs. My understanding is that neither is backed-up by
pg_dumpall (my backup strategy is that I do a pg_dumpall and mark the
actuall databa
On 26 Oct 2002, Pandurang wrote:
> But Later on as the DB size get increased the time was also get
> increased. And at one point i noticed the time required to gererate
> this report is very high near abt 10 to 15 hrs. So I checked for
> performanance.
>
> Site was also become very slow. A simple
Hi folks,
There is "reltuples" in pg_class which is approximately equal to
select count(*) from relation.
i think its updated only on VACUUMING ?
(david its not answer to ur question sorry)
regds
mallah.
> I couldn't find anything relating to getting the cardinality of a table. I know a
Hi Pandurang,
Are you sure your queries are optimised and using the right indexes
whereever applicable?
Try the EXPLAIN command with the slow queries is there a sequence scan on a
large table?
Pg does not at all detoriate like u have described if you do the rite
mantainence like VACUUMMING for
Hello Friends,
I found very a strange thing about postgres Database. I am running
postgres under Linux operating system.
I am having a website in PHP and having one perl program which runs
every friday to generate a report. The size of thsi postgres DB is
near about 5-7 MB.
In the start when reco
I couldn't find anything relating to getting the cardinality of a table. I
know a select will display number of rows. I was hoping there was a
'cheaper' (less expensive) way than doing a full select.
--
David Bear
College of Public Programs/ASU
---(end of broadcast)--
Hi,
I use postgresql 7.2. Last night i received a strange error and the
postmaster was crashed. It reported
'cannot read block 1470 of pg_log: no such file or directory'.
While googling i found,
"You can change "/\name/" to "/name/" in src/backend/catalog/genbki.sh,
then re-make install in tha
Hi all,
today I had a strange beaviour on a table with a partial index:
push=# select count(*) from jobs;
count
426197
(1 row)
push=# select count(*) from jobs where status = 'r';
count
---
6
(1 row)
the partial index is defined like this:
create index idx_jobs_status_r on j
20 matches
Mail list logo
