Re: [HACKERS] A more useful way to split the distribution

2001-04-08 Thread Christopher Sawtell

On Sun, 08 Apr 2001 11:24, Peter Eisentraut wrote:
 Since people suddenly seem to be suffering from bandwidth concerns I
 have devised a new distribution split to address this issue. 

[  ...  snipping the many tarballs argument  ...  ]

For me and I expect many other folk on the edge of civilization it is a 
total PITA to have to fiddle around and download many separate tarball 
files. What I want is to be able to start a d/l going and then come back 
when it's finished and know that I have _everything_ I actually need to 
have a working and documented product in one shot. 

For developers, contributors and testers and I would like to suggest that 
an exact snapshot of the complete CVS source archive is appropriate.  We 
can then track the changes every day using cvs or cvsup - wonderful tool 
btw - 

What is really _really_ needed is a text README which explains exactly 
what file contains.

Personally I have found that the limitations of the packaging systems to 
be such a nuisence that I always compile everything from source.

-- 
Sincerely etc.,

 NAME   Christopher Sawtell
 CELL PHONE 021 257 4451
 ICQ UIN45863470
 EMAIL  csawtell @ xtra . co . nz
 CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz

 -- Please refrain from using HTML or WORD attachments in e-mails to me 
--


---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl



Re: [HACKERS] More on elog and error codes

2001-03-20 Thread Christopher Sawtell

On Tue, 20 Mar 2001 10:56, you wrote:
 I've looked at the elog calls in the source, about 1700 in total (only

[ ... ]

 So we need some good error numbering scheme.  Any ideas?

Just that it might be a good idea to incorporate the  version / release 
details in some way so that when somebody on the list is squeaking about 
an error message it is obvious to the helper that the advice needed is to 
upgrade from the Cretatious Period version to a modern release, and have 
another go.

-- 
Sincerely etc.,

 NAME   Christopher Sawtell
 CELL PHONE 021 257 4451
 ICQ UIN45863470
 EMAIL  csawtell @ xtra . co . nz
 CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz

 -- Please refrain from using HTML or WORD attachments in e-mails to me 
--


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



[HACKERS] FATAL 2: XLogFlush: request is not satisfied

2001-03-15 Thread Christopher Sawtell

Greetings,

  I'm getting errors as a result of making queries. The attached log from 
the last two queries gives an idea as to what is happening.

  I suspect I must have done something bad when I upgraded via cvsup.

  Does this mean that I should do an initdb?

-- 
Sincerely etc.,

 NAME   Christopher Sawtell
 CELL PHONE 021 257 4451
 ICQ UIN45863470
 EMAIL  csawtell @ xtra . co . nz
 CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz

 -- Please refrain from using HTML or WORD attachments in e-mails to me 
--



chris=# select * from pupil where number=127;
-[ RECORD 1 ]-+---
number| 127
first_name| Savannah
last_name | Palme
date_of_birth | 1991-10-17
mother_name   | Lesley
mother_phone  | 384-5151
father_name   | Philip
father_phone  | 338-1857
home_phone| 366-3588
doctor_name   | Carl Denny
doctor_phone  | 377-6014
class_number  |
lessons   | {0,0}

chris=# select first_name, last_name from pupil;
FATAL 2:  XLogFlush: request is not satisfied
FATAL 2:  XLogFlush: request is not satisfied
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Server process (pid 10700) 
exited with status 512 at Fri Mar 16 15:38:49 2001
Terminating any active server processes...
Server processes were terminated at Fri Mar 16 15:38:49 2001
Reinitializing shared memory and semaphores
The Data Base System is starting up
Failed.
!# DEBUG:  database system was interrupted at 2001-03-16 15:10:46 NZDT
DEBUG:  CheckPoint record at (0, 108)
DEBUG:  Redo record at (0, 108); Undo record at (0, 0); Shutdown FALSE
DEBUG:  NextTransactionId: 117853; NextOid: 201268
DEBUG:  database system was not properly shut down; automatic recovery in progress...
DEBUG:  redo starts at (0, 172)
DEBUG:  ReadRecord: record with zero len at (0, 376)
DEBUG:  redo done at (0, 340)
FATAL 2:  XLogFlush: request is not satisfied
./bin/postmaster: Startup proc 10797 exited with status 512 - abort

!#
!#
!# \q
15:39:44 postgres@berty:~ $ ./bin/pg_ctl -o -i start
postmaster successfully started
15:40:18 postgres@berty:~ $ DEBUG:  database system shutdown was interrupted at 
2001-03-16 15:38:49 NZDT
DEBUG:  CheckPoint record at (0, 108)
DEBUG:  Redo record at (0, 108); Undo record at (0, 0); Shutdown FALSE
DEBUG:  NextTransactionId: 117853; NextOid: 201268
DEBUG:  database system was not properly shut down; automatic recovery in progress...
DEBUG:  redo starts at (0, 172)
DEBUG:  ReadRecord: record with zero len at (0, 376)
DEBUG:  redo done at (0, 340)
FATAL 2:  XLogFlush: request is not satisfied
./bin/postmaster: Startup proc 10808 exited with status 512 - abort

15:40:20 postgres@berty:~ $


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html