[BUGS] I used postgresql

[root]

at rpm pachage.
but , I take server Xen in www.server-linux.info
and postgresql install,
I couldn't initdb , at www.
'Report bugs to ' you.
thanks.


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] Postgresql 7.0 bug

[root]

POSTGRESQL BUG REPORT TEMPLATE



Your name   : Eric Prevost-Dansereau
Your email address  : [EMAIL PROTECTED]


System Configuration
-
  Architecture (example: Intel Pentium) : Intel Pentium II

  Operating System (example: Linux 2.0.26 ELF)  : Linux 2.2.13 ELF

  PostgreSQL version (example: PostgreSQL-6.5.1):  PostgreSQL-7.0

  Compiler used (example:  gcc 2.8.0)   : gcc 2.91.66


Please enter a FULL description of your problem:


When I execute from psql: 
SELECT '2000-04-03'::timestamp - '2000-04-02'::timestamp;

I get:
 ?column?
--
 23:00
(1 row)

Why april 2nd, 2000 don't last 1 day (or 24 hours) ?






Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible: 
--

SELECT '2000-04-03'::timestamp - '2000-04-02'::timestamp;




If you know how this problem might be fixed, list the solution below:
-

I don't have any idea

[BUGS] WAL couse die my database?

[root]

Hellow.
Unfortunaly for me postgresql 7.1.2 builds by default with WAL (and there were'n 
configure options to turn it of). So one of files in $database/xlog was corrupted. 
Postgres is not starting cose of corrupted WAL files:
===
DEBUG:  database system was shut down at 2001-08-13 18:38:03 MSD
DEBUG:  ReadRecord: record with zero len at (0, 888385420)
DEBUG:  Invalid primary checkPoint record
DEBUG:  ReadRecord: record with zero len at (0, 888385356)
DEBUG:  Invalid secondary checkPoint record
FATAL 2:  Unable to locate a valid CheckPoint record
===

So how to save my bases and repare WAL files?

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

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

[BUGS] BUG #6607: Strange select behavior

[suvisor . root]

The following bug has been logged on the website:

Bug reference:  6607
Logged by:  Sheplyakov Alexander
Email address:  suvisor.r...@gmail.com
PostgreSQL version: 9.1.3
Operating system:   Debian GNU/Linux Wheezy kernel ver 3.3.1
Description:

Create test table in such manner:
create table testt (id serial PRIMARY KEY, val text not null);
Populate table with test data:
 insert into testt (val) values ('1'), ('2'), ('3'), ('4'), ('5'), ('6'),
('7'), ('8'), ('9');
(repeat next line until table doesn't contain approx 100 rows)
insert into testt (id, val) select nextval('testt_id_seq'::regclass),
currval('testt_id_seq'::regclass) + val::integer from testt;

And then, repeat some times such query:
select * from testt where id = (random()* 10)::integer;

And sometimes it comes out something like this:
id | val
---+
11894 | 15051
29233 | 42198
80725 | 90213
85688 | 100992
88017 | 108075
(5 rows)
Here can be 2, 3 or other rows amount in result... But must be only one!


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs