Christopher Kings-Lynne has made pg_dump and pg_dumpall much more
reliable in this respect for 8.0.
Ð ÐÑÐ, 28.10.2004, Ð 16:46, Andrea D. ÐÐÑÐÑ:
> Hi, I've just upgraded Roma 7.3.x to 7.4.5 on a Mandrake 10.1 community.
> I've used pg_dumpall (Roma version 7.4.5) to dump my previous databases to a
pgsql running on port 5480, connect to template1 as non-superuser "phppgadmin"
who does not have createdb privileges. attempt to run a script that creates a
database "phppgadmin" and then do a \connect to that database. this fails
(as it should) but when it does, it loses the connection to te
On Sunday 31 October 2004 10:16, Robert Treat wrote:
> pgsql running on port 5480, connect to t\echo :PORTemplate1 as non-superuser
> "phppgadmin" who does not have createdb privileges. attempt to run a script
> that creates a database "phppgadmin" and then do a \connect to that
> database. this
"Matthew \"Cheetah\" Gabeler-Lee" <[EMAIL PROTECTED]> writes:
> [ PostgreSQL 7.4.5, Linux (Debian sarge) ]
> The date_trunc function is making some off-by-one errors when working at
> a DST border.
> => select date_trunc('minute', '2004-10-31 01:00:00-05'::timestamptz);
>date_trunc
Hi PostgreSQL developers!
Currently (i. e. in 7.4.6) psql seems to use the default database
encoding as locale for both its own messages and for database output
strings. Whereas it is only an inconvenience for the latter, psql's
own messages should really respect LANG/LC_MESSAGES environment
varia
Tom,
> Hmmm ... where is that coming from exactly? PG itself should not be
> referring to /usr/share/timezone --- we have our own TZ database now.
> And glibc-based platforms don't keep their info there either (it's in
> /usr/share/zoneinfo, at least on my Fedora machine). So there's
> something
Josh Berkus <[EMAIL PROTECTED]> writes:
>> Hmmm ... where is that coming from exactly? PG itself should not be
>> referring to /usr/share/timezone --- we have our own TZ database now.
> Let me know if you want a trace.
Please. Also, what nondefault configuration or postgresql.conf settings
are
Hi PostgreSQL developers!
The current Debian package has some patches that tweak the building of
contrib modules. I think they would be interesting for other
distributions, too. Most of this stuff was contributed by users who
actually use these modules.
25contrib-dbmirror:
- additionally instal
Tom,
> Please. Also, what nondefault configuration or postgresql.conf settings
> are you using?
Will have to get the trace tommorrow. Config options are --with-perl and
--with-odbc
--
Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)--
On Mon, 2004-11-01 at 10:49, Martin Pitt wrote:
> The current Debian package has some patches that tweak the building of
> contrib modules. I think they would be interesting for other
> distributions, too. Most of this stuff was contributed by users who
> actually use these modules.
Thanks for let
Neil Conway <[EMAIL PROTECTED]> writes:
> On Mon, 2004-11-01 at 10:49, Martin Pitt wrote:
>> 25contrib-dbmirror:
>> - additionally install some useful scripts and data files
> Makes sense to me, although I won't claim to be a dbmirror user. I'll
> apply this to HEAD unless anyone objects.
Steve
Hi,
I think this is a bug (I hope not a feature).
Description:
The table 'tmp' gets records added, and uses a serial to fill
the attribute 'strorage_id'. The table has a rule which logs
all inserts into the table 'log'.
Problem:
For each insert into tab
Hello pgsql-bugs,
The bug description is as follows:
Then server with running postmaster unexpectedly shut down, server
cannot be started next time.
I've found that manual starting of that service also unsuccessful.
I investigated the bug, and found that the .pid file exists at
PGDATA
in response to;
tar -jxf postgresql-8.0.0beta4.tar.bz2
cd postgresql-8.0.0beta4
./configure
make check
combination, i received the following message. postgres 7.4.3 makes
check fine (with a problem today caused by daylight saving)
*snip*
/bin/sh ./pg_regress --temp-install --top-builddir=../../.
14 matches
Mail list logo
