pg.ddx.io pgsql-hackers@postgresql.org mailing list archive
help / color / mirror / Atom feedMajor Problem, need help! Can't run our website!
7+ messages / 6 participants
[nested] [flat]
* Major Problem, need help! Can't run our website!
@ 2005-11-15 03:19 ITS ONT Alcazar, Jose Aguedo C <jacalcazar@exportbank.com.ph>
0 siblings, 1 reply; 7+ messages in thread
From: ITS ONT Alcazar, Jose Aguedo C @ 2005-11-15 03:19 UTC (permalink / raw)
To: pgsql-admin@postgresql.org
Anyone!
Before anything else, I have no background in PostgreSQL. But I have a
little knowledge in Linux. We used postgreSQL to run one of our website. It
runs in Redhat Linux 7.3. Our System Administrator, who used to maintain
this server, had resigned and didn't have a proper documentation on how to
maintain this server. Right now, our NEW System Administrator is clearing
some logs in /var/lib/pgsql/data/pg_xlog in able to free some space in the
/var file system. It used to work before, but now, its not working anymore.
Information below is the message we are encountering when we are trying to
connect to the website. Please, ANYONE, help us!
Warning: Unable to connect to PostgreSQL server: could not connect to
server: Connection refused Is the server running on host localhost and
accepting TCP/IP connections on port 5432? in
/var/lib/phplib-7.2d/php/db_pgsql.inc on line 48
Database error: Link-ID == false, pconnect failed
ODBC Error: 0 ()
Session halted.
Thanks! --AGUEDO
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Major Problem, need help! Can't run our website!
@ 2005-11-15 03:48 Tim Allen <tim@proximity.com.au>
parent: ITS ONT Alcazar, Jose Aguedo C <jacalcazar@exportbank.com.ph>
0 siblings, 3 replies; 7+ messages in thread
From: Tim Allen @ 2005-11-15 03:48 UTC (permalink / raw)
To: pgsql-hackers; +Cc: pgsql-admin@postgresql.org
ITS ONT Alcazar, Jose Aguedo C wrote:
> Anyone!
>
> Before anything else, I have no background in PostgreSQL. But I have a
> little knowledge in Linux. We used postgreSQL to run one of our website. It
> runs in Redhat Linux 7.3. Our System Administrator, who used to maintain
> this server, had resigned and didn't have a proper documentation on how to
> maintain this server. Right now, our NEW System Administrator is clearing
> some logs in /var/lib/pgsql/data/pg_xlog in able to free some space in the
> /var file system. It used to work before, but now, its not working anymore.
> Information below is the message we are encountering when we are trying to
> connect to the website. Please, ANYONE, help us!
We've seen reports of people firing this particular foot-gun before,
haven't we? Would it make sense to rename pg_xlog to something that
doesn't sound like it's "just" full of log files? Eg pg_wal - something
where the half-educated will have no idea what it is, and therefore not
think they know what they can do with it.
Tim
--
-----------------------------------------------
Tim Allen tim@proximity.com.au
Proximity Pty Ltd http://www.proximity.com.au/
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [HACKERS] Major Problem, need help! Can't run our website!
@ 2005-11-15 04:02 Tom Lane <tgl@sss.pgh.pa.us>
parent: Tim Allen <tim@proximity.com.au>
2 siblings, 0 replies; 7+ messages in thread
From: Tom Lane @ 2005-11-15 04:02 UTC (permalink / raw)
To: Tim Allen <tim@proximity.com.au>; +Cc: pgsql-hackers; pgsql-admin@postgresql.org
Tim Allen <tim@proximity.com.au> writes:
> We've seen reports of people firing this particular foot-gun before,
> haven't we? Would it make sense to rename pg_xlog to something that
> doesn't sound like it's "just" full of log files? Eg pg_wal - something
> where the half-educated will have no idea what it is, and therefore not
> think they know what they can do with it.
There's something in what you say. We'd have to rename pg_clog as well,
since that's even more critical than pg_xlog ...
regards, tom lane
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [HACKERS] Major Problem, need help! Can't run our website!
@ 2005-11-15 04:05 Christopher Kings-Lynne <chriskl@familyhealth.com.au>
parent: Tim Allen <tim@proximity.com.au>
2 siblings, 1 reply; 7+ messages in thread
From: Christopher Kings-Lynne @ 2005-11-15 04:05 UTC (permalink / raw)
To: Tim Allen <tim@proximity.com.au>; +Cc: pgsql-hackers; pgsql-admin@postgresql.org
> We've seen reports of people firing this particular foot-gun before,
> haven't we? Would it make sense to rename pg_xlog to something that
> doesn't sound like it's "just" full of log files? Eg pg_wal - something
> where the half-educated will have no idea what it is, and therefore not
> think they know what they can do with it.
Would it be wise or insane for us to to mention in the startup error a
HINT that if you've removed such files, only hope is full restore from
backup or pg_resetxlog with data loss?
Chris
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [HACKERS] Major Problem, need help! Can't run our website!
@ 2005-11-15 04:17 Tom Lane <tgl@sss.pgh.pa.us>
parent: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
0 siblings, 0 replies; 7+ messages in thread
From: Tom Lane @ 2005-11-15 04:17 UTC (permalink / raw)
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>; +Cc: Tim Allen <tim@proximity.com.au>; pgsql-hackers; pgsql-admin@postgresql.org
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> Would it be wise or insane for us to to mention in the startup error a
> HINT that if you've removed such files, only hope is full restore from
> backup or pg_resetxlog with data loss?
Not sure that we should have a HINT recommending a worst-case-scenario
course of action as the first resort. We'll have people blowing away
their data for what might be relatively fixable problems (eg, bogus
permissions on the pg_xlog directory, which I think was an issue that
just came up a day or two ago ...)
(We're all really jumping to conclusions here anyway. The guy may have
been foolish to remove xlog files, but that doesn't explain why his
postmaster isn't running. There's some facts missing in that report.)
regards, tom lane
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [ADMIN] Major Problem, need help! Can't run our website!
@ 2005-11-15 23:27 Trent Shipley <tshipley@deru.com>
parent: Tim Allen <tim@proximity.com.au>
2 siblings, 1 reply; 7+ messages in thread
From: Trent Shipley @ 2005-11-15 23:27 UTC (permalink / raw)
To: pgsql-hackers
On Monday 2005-11-14 20:48, Tim Allen wrote:
<snip>
OOPS deleted pg_xlog because surely it was only a log file.
</snip>
>
> We've seen reports of people firing this particular foot-gun before,
> haven't we? Would it make sense to rename pg_xlog to something that
> doesn't sound like it's "just" full of log files? Eg pg_wal - something
> where the half-educated will have no idea what it is, and therefore not
> think they know what they can do with it.
>
> Tim
Renaming the file sounds like an excellent design decision since the current
name is a proven "human factor" bug.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [ADMIN] Major Problem, need help! Can't run our website!
@ 2005-11-16 01:27 Joshua D. Drake <jd@commandprompt.com>
parent: Trent Shipley <tshipley@deru.com>
0 siblings, 0 replies; 7+ messages in thread
From: Joshua D. Drake @ 2005-11-16 01:27 UTC (permalink / raw)
To: tshipley@deru.com; +Cc: pgsql-hackers
>
> Renaming the file sounds like an excellent design decision since the current
> name is a proven "human factor" bug.
>
I am sorry, but as soon as you look at the files it is obvious that they
are not "just" log files. If someone
is going to delete the xlog they are going to do it no matter what we
call it. Unless of course we change
the directory to pg_xlogs_do_not_ever_delete, but I doubt that would
help either.
Sincerely,
Joshua D. Drake
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2005-11-16 01:27 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-11-15 03:19 Major Problem, need help! Can't run our website! ITS ONT Alcazar, Jose Aguedo C <jacalcazar@exportbank.com.ph>
2005-11-15 03:48 ` Tim Allen <tim@proximity.com.au>
2005-11-15 04:02 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-11-15 04:05 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2005-11-15 04:17 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-11-15 23:27 ` Trent Shipley <tshipley@deru.com>
2005-11-16 01:27 ` Joshua D. Drake <jd@commandprompt.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox