Hi,
I just ran into an error from pg_dump:
/usr/local/pgsql/bin/pg_dump -F p my_db
pg_dump: ERROR: unexpected chunk number 3292 (expected 5) for toast value
144391872
pg_dump: SQL command to dump the contents of table "measured_bioassay_base"
failed: PQendcopy() failed.
pg_dump: Error message
On 7/9/05 10:50 am, "Adam Witney" <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I just ran into an error from pg_dump:
>
> /usr/local/pgsql/bin/pg_dump -F p my_db
>
> pg_dump: ERROR: unexpected chunk number 3292 (expected 5) for toast value
> 144391872
>
> I would be interested to see "pg_filedump -i -f" output for the toast
> table's index before you blow it away, if you have time for that.
Yep I can run this Can't seem to locate pg_filedump though... Its not in
contrib... Anyone know where it is these days?
--
This message has been scann
On 7/9/05 4:28 pm, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> Adam Witney <[EMAIL PROTECTED]> writes:
>>> I would be interested to see "pg_filedump -i -f" output for the toast
>>> table's index before you blow it away, if you have time f
On 7/9/05 6:12 pm, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> I wrote
>> Adam Witney <[EMAIL PROTECTED]> writes:
>>> I think I have found the offending row in measured_bioassay_base... The
>>> entry in its toast table looks like this
>
>>&g
On 8/9/05 2:38 pm, "Alvaro Herrera" <[EMAIL PROTECTED]> wrote:
> On Thu, Sep 08, 2005 at 10:32:41AM +0100, Adam Witney wrote:
>
>> Unfortunately the pg_filedump you requested gives an error:
>>
>>
On 8/9/05 3:46 pm, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> Adam Witney <[EMAIL PROTECTED]> writes:
>> Here you go
>
>> pg_filedump-3.0/pg_filedump -i -f -R 34318 34320 134401986.1
>
> Thanks. What it looks like to me is that block 34320
> How many columns does that table have?
It has 77 columns. INSERTS are always done on both this table and the table
that had the toast table error within the same transaction if that matters?
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed
On 6/4/06 4:11 pm, "Gábriel Ákos" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I tried to download pg_backup.sh from here:
> http://database.sourceforge.net/scripts/pg_backup.tgz
>
> ... but it is no more available.
> Could somebody send it to me please?
Just looking on google, I found what looks to be
> But i am getting an error as mentioned below
>
> *org.postgresql.util.PSQLException: Connection refused. Check that the
> hostname and port are correct and that the postmaster is accepting
> TCP/IP connections.*
> **
> What are the changes that i have to do for changing port.
>
> If i am r
I think the tablefunc module in contrib will do crosstab queries
HTH
adam
> Is there a plan to implement crosstab query feature? Are there ways
> other than using some frontend tool, COPY or pg_dump?
>
> Thanks,
> Ben
>
>
> ---(end of broadcast)
Hi all,
I am experimenting with a few OS's for my new hardware. I plan to have a
software RAID5 device for my pgsql data directory.
I have been experimenting with FreeBSD and with Linux, does anyone have any
thoughts on whether vinum RAID devices are better than Linux software RAID?
Or vice vers
On 17/12/03 3:45 pm, "scott.marlowe" <[EMAIL PROTECTED]> wrote:
> On Tue, 16 Dec 2003, Robert Creager wrote:
>
>> When grilled further on (Tue, 16 Dec 2003 22:30:04 -0600),
>> Patrick Spinler <[EMAIL PROTECTED]> confessed:
>>
>>>
>>> According to the theory they expound, a database with any sig
On 18/12/03 5:39 am, "Sean Chittenden" <[EMAIL PROTECTED]> wrote:
>> I am experimenting with a few OS's for my new hardware. I plan to have a
>> software RAID5 device for my pgsql data directory.
>>
>> I have been experimenting with FreeBSD and with Linux, does anyone have any
>> thoughts on whet
Something strange has just appeared in my database, can anyone explain this
duplication of columns:
test=# \d plate_reporter
Table "plate_reporter"
Column | Type | Modifiers
---+-+
On 10/2/05 5:45 pm, "Bruce Momjian" wrote:
> Adam Witney wrote:
>>
>> Something strange has just appeared in my database, can anyone explain this
>> duplication of columns:
>>
>> test=# \d plate_reporter
>>
Hi,
I have a process running and I am trying to work out what it is doing.
Supposedly it is running a SELECT
23093 ?R 6:35 postgres: lubrook bugasbase SELECT
However in pg_stat_activity, I get no current_query
bugasbase=# SELECT * from pg_stat_activity ;
datid | datname | p
On 29/3/05 4:27 pm, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> Adam Witney <[EMAIL PROTECTED]> writes:
>> Shouldn't there be something in current_query?
>
> Only if (a) you have stats_command_string turned on, *and* (b) you
> are a superuser or the ow
On 29/3/05 5:06 pm, "Scott Marlowe" <[EMAIL PROTECTED]> wrote:
> On Tue, 2005-03-29 at 09:50, Adam Witney wrote:
>> On 29/3/05 4:27 pm, "Tom Lane" <[EMAIL PROTECTED]> wrote:
>>
>>> Adam Witney <[EMAIL PROTECTED]> writes:
>>&
You can unsubscribe here
http://www.postgresql.org/community/lists/subscribe
On 11/1/07 14:05, in article [EMAIL PROTECTED],
""raphael ferrer"" <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I would like to stop receive emails from pg forum.
>
> How could i do that?
>
> Thanks
>
> ___
On 30/4/07 16:22, in article [EMAIL PROTECTED], "Hannes
Dorbath" <[EMAIL PROTECTED]> wrote:
> Excluding warehousing setups, where XFS might give some benefit, any
> modern file system on Linux should perform OK. I'd use what I'm
> comfortable with. In case your data set fits in RAM, it will sta
But with puTTY you are connecting to the Master server via telnet/ssh and
then connecting to PostgreSQL from that server. So PostgreSQL sees the
connection as coming from the Master server, which is presumably allowed in
your pg_hba.conf. When connecting directly to PostgreSQL from your laptop,
yo
I assume you mean finding out the OS of the machine running PostgreSQL??
Maybe this will give a clue:
db=>select version();
(I've never run it on Windows so I don't know what that produces for that
OS)
adam
---(end of broadcast)---
TIP 3: Have
I had this trouble also. As a workaround 7.2.2 can be compiled and installed
using fink
fink.sourceforge.net
HTH
adam
> I am able to compile and install 7.3(b1 and b2) on osx 10.2.1 without problem.
> However, I can not get 7.2.x to compile.
>
> Is there a fix?
>
> Ted
>
>
>
> ---
If compiled from source you can find the configure options used in
config.status, not sure about with the rpm though
adam
> I was just wondering if there was an easy/standard way of finding out what
> configure options were used on installation (either from source or rpm).
> Any help would be g
Hi, I am trying to get 7.3.1 running on my Sun server. It all seemed to
install ok, but when running initdb I get this appearing
bash-2.03$ /usr/local/pgsql7.3.1/bin/initdb -D /usr/local/pgsql7.3.1/data/
The program
'/usr/local/pgsql7.3.1/bin/postgres'
needed by initdb does not belong to Pos
When installing PostgreSQL from source you need to tell it where the
readline libraries are. If you installed readline using fink you would do
this...
./configure --with-libs=/sw/lib --with-includes=/sw/include
..or you could just install postgresql using fink...
You may need to be more specifi
27 matches
Mail list logo
