> You can use symbolic links, if your operating system allows them.
>
>
> 1. For safety, make a full backup with pg_dumpall.
>
> 2. Identify the database directories -- they are named by the oid of the
> database in pg_databases:
>
> template1=# select datname, oid from pg_database;
>
On Sun, 2 Feb 2003, Len Conrad wrote:
> I will un-whitelist that ip and we'll see very quickly:
>
> Feb 3 03:07:41 Mgw1 postfix/smtp[74990]: 929D1EF908:
> to=<[EMAIL PROTECTED]>,
> relay=mail.postgresql.org[64.49.215.8], delay=1, status=deliverable (250 Ok)
>
> Excellent! Thanks for fixing postg
> Reading between the lines of the error message, it looks to me like
> meiway.com's mail server is programmed to take the MAIL FROM address,
> connect back to the sending server
Wrong, but it's a fully understandable error when firing from the hip with
head up the ass.
The attempt to deliver
yOn Sun, 2 Feb 2003, Tom Lane wrote:
> "Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> > 'K, this doesn't make sense ... is [EMAIL PROTECTED] a valid
> > recipient? *puzzled look*
>
> > In: MAIL FROM:<[EMAIL PROTECTED]> SIZE=2629
> > Out: 250 Ok
> > In: RCPT TO:<[EMAIL PROTECTED]>
> > Out: 450
"Gaetano Mendola" <[EMAIL PROTECTED]> writes:
> I'm trying to vacuum full a table ( Postgres 7.2.3 )
> but the command:
> vacuum full
> hang and all processes that are trying to update that table hang too,
> the CPU occupation for the process that perform the
> vacuum is 0. What is going on?
Are
Bruce Momjian <[EMAIL PROTECTED]> writes:
> This seems very strange. Are you sure those binaries are all from the
> same release.
I don't think they could be. Our build procedure computes just one LIBS
list and uses it for all executables, so in ordinary circumstances all
the executables will ha
Bruce Momjian writes:
> Is all this stuff in our docs?
At least I didn't find it, while I was searching for "how to logrotate the
postmaster logfile properly" last week (IIRC only the "pipe postmasters
output into a logrotate script" possibility is discussed, not the way like 2)
below). Finall
are u sure VACUUM FULL is hanging?
run in verbose mode...
VACUUM FULL VERBOSE ANALYZE
and you are really desperate get the pid of the
backend who is doing the vacuum and
strace -pi am sure u will see it spitting lots of read and writes.
;-)
regds
mallah.
> <[EMAIL PROTECTED]> wrote in
<[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
>
> Hmm. VACUUM FULL is supposed to do that only i guess.
>
> since version 7.2 ordinary VACUUM does not locks the table.
> and VACUUM can be performed on a live system.
>
> VACUUM FULL does the disk space reclaimat
Hmm. VACUUM FULL is supposed to do that only i guess.
since version 7.2 ordinary VACUUM does not locks the table.
and VACUUM can be performed on a live system.
VACUUM FULL does the disk space reclaimation and is supposed to lock
table to prevent updates.
i guess you can do a VACUUM ANALYZE on
I'm trying to vacuum full a table ( Postgres 7.2.3 )
but the command:
vacuum full
hang and all processes that are trying to update that table hang too,
the CPU occupation for the process that perform the
vacuum is 0. What is going on?
Ciao
Gaetano
---(end of broadcast
You can't because the backend opens that file as the super-user. You
can use \copy in psql as an normal user, though.
---
Jaume Teixi wrote:
> how should I use " COPY arti FROM 'ARTI.txt' USING DELIMITERS '|' " as normal u
This seems very strange. Are you sure those binaries are all from the
same release. Is your pg_hba.conf a cause? I know of now special
connection requirements for pg_restore.
---
Chris White wrote:
> I am trying to run pg_
Is all this stuff in our docs?
---
Rajesh Kumar Mallah. wrote:
>
>
>
> This is someones' elses' posting that i have preserved
> shud be useful.
>
> regds
> mallah.
>
> ~~~
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> 'K, this doesn't make sense ... is [EMAIL PROTECTED] a valid
> recipient? *puzzled look*
> In: MAIL FROM:<[EMAIL PROTECTED]> SIZE=2629
> Out: 250 Ok
> In: RCPT TO:<[EMAIL PROTECTED]>
> Out: 450 <[EMAIL PROTECTED]>: Sender address rejected:
> unver
15 matches
Mail list logo
