""Chun Yit(Chronos)"" <[EMAIL PROTECTED]> wrote
> postmaster give me error every time i try to start it
> LOG: redo starts at A/46315F50
> PANIC: btree_delete_page_redo: uninitialized right sibling
>
So the last resort I can think of is to use pg_resetxlog to pass the startup
failure -- but no
"Chun Yit\(Chronos\)" <[EMAIL PROTECTED]> writes:
> PANIC: btree_delete_page_redo: uninitialized right sibling
> LOG: startup process (PID 5043) was terminated by signal 6
> LOG: aborting startup due to startup process failure
That's pretty ugly :-(. I think your only hope to get out of it is
"Qingqing Zhou" <[EMAIL PROTECTED]> writes:
But not sure why it reports the following error
message (which looks like a post-commit cleanup caused error):
DEBUG: AbortCurrentTransaction
PANIC: cannot abort transaction 14135438, it was already committed
I think this is an artifact o
4) how can i solve this problem?
The base table pg_class should be ok(pg_class_oid_ind indicates both have
the same cardinality). Try to reindex pg_class as the superuser.
but not i not be able to reindex the table because i cannot start the
postmaster.
postmaster give me error every time
On Mon, 2006-05-15 at 17:12 -0500, Jim C. Nasby wrote:
> On Wed, May 10, 2006 at 02:08:46PM -0300, Bruno Almeida do Lago wrote:
> > Sometime ago I saw a project with the purpose of creating Oracle views over
> > the PostgreSQL catalog.
> >
> > I can't remember/find it anymore. Do you know if it's
You should try the new MacBook Jim! The 17" is out now. I used to
have the 17" PB G4, but now I have a 15" MacBook Pro with 2GB of RAM.
It's a sweet machine! Very fast too.
Brendan Duddridge | CTO | 403-277-5591 x24 | [EMAI
Don Y <[EMAIL PROTECTED]> writes:
> I'm writing a set of casts to/from various user defined
> types. As is unexpected, there are cases where one
> data type doesn't neatly map to another (for certain
> values). In these cases I emit an INVALID_PARAMETER_VALUE
> or OUT_OF_RANGE error -- depending
Hi,
I'm writing a set of casts to/from various user defined
types. As is unexpected, there are cases where one
data type doesn't neatly map to another (for certain
values). In these cases I emit an INVALID_PARAMETER_VALUE
or OUT_OF_RANGE error -- depending on the situation.
But, should I also
On Mon, 15 May 2006, dfx wrote:
I am spending about 10 hours on little problem: to pass a parameter (text)
to a PostgreSQL (v. 8.1 on Win2000). The
relevant code is:
java side:
private CallableStatement cs;
cs = conn.prepareCall(INSERT_CONGRESSO);
cs.setString(1, itemCongresso.getCongresso())
And I just demonstrated it on a test 7.4.7 database here (Debian
7.4.7-6 to be precise).
test=# select ctid, xmin, xmax, cmin, cmax, * from test;
ctid |xmin| xmax | cmin | cmax | x
---++--+--+--+---
(0,1) |541 |0 |0 |0 | 1
(0,2) | 214748
Hi guys i have a database on WINXP machine unfotunatly, the OS crashed . i want to retriev my data how can this be done. Regards
Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low rates.
On Fri, May 12, 2006 at 02:02:27PM -0400, Bruce Momjian wrote:
> Scott Marlowe wrote:
> > On Fri, 2006-05-12 at 11:39, Joshua D. Drake wrote:
> > > > I am regularly dealing with customers, and specifically developers that
> > > > are running Linux+PostgreSQL on the server... but their desktop of
On Wed, May 10, 2006 at 02:08:46PM -0300, Bruno Almeida do Lago wrote:
> Sometime ago I saw a project with the purpose of creating Oracle views over
> the PostgreSQL catalog.
>
> I can't remember/find it anymore. Do you know if it's still available?
>
> Is there any other project aiming to create
On Wed, May 10, 2006 at 11:00:14PM +1000, chris smith wrote:
> On 5/10/06, Alban Hertroys <[EMAIL PROTECTED]> wrote:
> >Sim Zacks wrote:
> >> Something such as: with this explain data, adding an index on table tbl
> >> column A would drastically improve the efficiency. Or at least an
> >> applicati
On Wed, May 10, 2006 at 11:55:49AM +0200, Houssais Hugues wrote:
> Hi,
>
> In order to unify many distant Postgres databases, we decided to use WAL
> archiving. The idea is to concatenate a distant WAL archive at the
> beginning of a local WAL archive before launching PITR restore.
>
> Does anyon
On Tue, May 09, 2006 at 08:57:57AM -0700, John Purser wrote:
> > I am running postgres 7.4.7 on debian sarge.
> First:
> psql -U -o --pset format=unaligned
> --pset fieldsep=',' -c '' -d
>
> I think that will give you the output you were after assuming you're
> scripting psql and that you repl
On Tue, May 09, 2006 at 10:10:50AM +0200, Houssais Hugues wrote:
> Each distant database works on its own domain of data. Then no conflict
> should happen during updates.
> One thing I have not specified is that the distant databases don't handle
> global data but only data collected at the local
On Mon, May 08, 2006 at 04:17:53PM -0700, Casey Duncan wrote:
> From personal experience (and others will disagree), I find putting
> logic in the database to be a bad idea. I only use stored procedures
> for triggers and the like, and I try to avoid those whenever possible.
>
> Here are my re
On Mon, 2006-05-15 at 14:24, TJ O'Donnell wrote:
> I've written some extensions to postgres to implement
> chemical structure searching. I get inquiries about
> the performance of postgres vs. oracle. This is a huge
> topic, with lots of opinions and lots of facts. But,
> today I got some feedba
I've written some extensions to postgres to implement
chemical structure searching. I get inquiries about
the performance of postgres vs. oracle. This is a huge
topic, with lots of opinions and lots of facts. But,
today I got some feedback stating the opinion that:
"Postgres performance diminis
On Sat, May 06, 2006 at 12:08:32AM -0300, Marcelo Fabiano da Silveira wrote:
> Hi,
>
> I Have some questions of use PQtrace in Windows' systens
>
> 1- The implementation of PQtrace, is possible ONLY with non bloking
> connections ???
> 2- Please, I need same samples of implementation of PQtr
On Fri, May 05, 2006 at 12:41:56PM -0600, Brendan Duddridge wrote:
> They both have a click_count column that we update with "update
> attribute set click_count = click_count + 1;" and the same for the
> attribute_value table. Postgres is getting hung up on any transaction
> that attempts to
> -Original Message-
> From: Tony Caduto [mailto:[EMAIL PROTECTED]
> Sent: 13 May 2006 14:58
> To: Dave Page
> Subject: Re: [GENERAL] GUI Interface
>
> All that page mentions is the weird quirks on win32, I am
> sure you know what those are, i.e. windows suddenly lose
> there size an
entendi, só que o problema é q estou usando
annotations do hibernate p/a gerar esse campo
@NotNull(message =
FramexMessages.FRAMEX_REQUIRED_FIELD) @Lob @Basic(fetch = FetchType.EAGER)
public byte[] getArquivoImagem() {
return arquivoImagem; }
alguém jah passou por ess
On Mon, May 15, 2006 at 03:04:47PM -0400, Tom Lane wrote:
> Martijn van Oosterhout writes:
> > Vacuum will make anything that disappeared by wraparound in the last
> > billion transactions reappear, so a databasewide vacuum should solve
> > all your problems, no need to dump...
>
> Oh, I had forg
On Mon, 2006-05-15 at 14:07, Michael L. Boscia wrote:
> On 5/15/06, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> > This is one of those rare instances when I'd shut down the server and
> > take a file system backup if I could. However, at 1.4 TB, that might be
> > a bit difficult... :)
>
> What do
On 5/15/06, Scott Marlowe <[EMAIL PROTECTED]> wrote:
On Mon, 2006-05-15 at 13:48, Martijn van Oosterhout wrote:
> On Mon, May 15, 2006 at 11:44:01AM -0700, Michael L. Boscia wrote:
> > Hello-
> >
> > I currently have a 1.4 TB database (pg version 7.4.8) that is experiencing
> > transaction id wra
Martijn van Oosterhout writes:
> Vacuum will make anything that disappeared by wraparound in the last
> billion transactions reappear, so a databasewide vacuum should solve
> all your problems, no need to dump...
Oh, I had forgotten about that. Did we establish that 7.4.* works that
way? I thin
"Michael L. Boscia" <[EMAIL PROTECTED]> writes:
> My current plan is selectively dump a portion of the data (most current,
> organized in tables by date ex xxx_2006_may) and reload. I plan to vaccuum
> each table before dumping. Please warn me if this is not enough. Any
> assistance is greatly a
On Mon, May 15, 2006 at 08:48:54PM +0200, Martijn van Oosterhout wrote:
> Vacuum will make anything that disappeared by wraparound in the last
> billion transactions reappear, so a databasewide vacuum should solve
> all your problems, no need to dump...
Also, for future reference. If you have a lo
On Mon, 2006-05-15 at 13:48, Martijn van Oosterhout wrote:
> On Mon, May 15, 2006 at 11:44:01AM -0700, Michael L. Boscia wrote:
> > Hello-
> >
> > I currently have a 1.4 TB database (pg version 7.4.8) that is experiencing
> > transaction id wraparound. I plan to pg_dump the database and initdb an
> -Original Message-
> From: Florian G. Pflug [mailto:[EMAIL PROTECTED]
> Sent: 15 May 2006 19:05
> To: Dave Page
> Cc: Tino Wildenhain; Kenneth Downs; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] GUI Interface
>
> Here are the details of my configuration which shows the probl
On Mon, May 15, 2006 at 11:44:01AM -0700, Michael L. Boscia wrote:
> Hello-
>
> I currently have a 1.4 TB database (pg version 7.4.8) that is experiencing
> transaction id wraparound. I plan to pg_dump the database and initdb and
> reload. I may reload into an 8.1 database at this time.
>
> I a
Hello-
I currently have a 1.4 TB database (pg version 7.4.8) that is
experiencing transaction id wraparound. I plan to pg_dump the database
and initdb and reload. I may reload into an 8.1 database at this
time.
I am curious how to make sure that I indeed get all the data out of the
tables fro
Dave Page wrote:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Florian G. Pflug
Sent: 14 May 2006 18:50
To: Tino Wildenhain
Cc: Kenneth Downs; pgsql-general@postgresql.org
Subject: Re: [GENERAL] GUI Interface
It only happens in pgAdmin III, though,
On May 14, 2006, at 12:27 AM, Ed L. wrote:
While watching a 9-hour 60GB network load from 7.4.6 pg_dump into
8.1.2, I noticed the order in which indices and constraints are
created appears to be their creation order.
If you use the 8.1.2 pg_dump to make the dump from your 7.4.6 DB,
what is
Estou com problemas ao tentar inserir um array de
bytes em um campo do tipo oid.
Caused by: org.springframework.jdbc.UncategorizedSQLException:
Hibernate operation: could not insert:
[br.com.atlantico.maragato.cadastrosauxiliares.model.ImagemTO]; uncategorized
SQLException for SQL [insert
Mark Campbell wrote:
> Hi All
>
> I downloaded version 7.3 and compiled that.
>
> First I had to compile newer versions of "m4" and "bison"
>
> At least I now have an up and running postgres server
>
> Thanks for all the help
>
> Mark Campbell
>
>
> Confidentiality Notice: http://ucs.co.za/c
Martijn van Oosterhout writes:
> On Mon, May 15, 2006 at 10:44:15AM -0400, Tom Lane wrote:
>> I haven't been able to think of a way to do that, unless you want to
>> assume the existence of a plpgsql helper function. There's an open
>> request to list last_values in psql's "\ds", and it'd be real
On Mon, May 15, 2006 at 10:44:15AM -0400, Tom Lane wrote:
> I haven't been able to think of a way to do that, unless you want to
> assume the existence of a plpgsql helper function. There's an open
> request to list last_values in psql's "\ds", and it'd be real nice
> to be able to do it all in on
Martijn van Oosterhout writes:
> On Mon, May 15, 2006 at 03:55:49PM +0300, Forums @ Existanze wrote:
>> I have been able to get the sequence names, but I can get their values all
>> in one query.
> Select sequence.last_value;
The hard part of the request is to do it "all in one query", though,
i
Nis Jorgensen <[EMAIL PROTECTED]> writes:
> Try removing the DISTINCT ON from your view - that should make things
> clearer to you. When t.approved is true, the row is joined to all rows
> of the datum table satisfying the criteria. The sort order you specify
> does not guarantee a unique ordering
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kenneth
DownsSent: 15 May 2006 15:14To:
pgsql-general@postgresql.orgSubject: Re: [GENERAL] GUI
Interface
Kenneth Downs wrote:
Dave Page wrote:
kernel 2.6.8KDE
3.3.2gtk
Kenneth Downs wrote:
Dave Page wrote:
kernel 2.6.8
KDE 3.3.2
gtk+ 2.4.14
pgadmin3 1.2.2
The window manager would be whatever the default for KDE is.
OK, the first thing you really should do is
upgrade to pgAdmin 1.4.2 and (if b
On Mon, May 15, 2006 at 03:55:49PM +0300, Forums @ Existanze wrote:
> Hello all,
>
> I would like to ask if anyone can explain or point me to some sort of query
> that would get the sequences for a database along with the current value
> they contain.
>
> I have been able to get the sequence na
"Qingqing Zhou" <[EMAIL PROTECTED]> writes:
> But not sure why it reports the following error
> message (which looks like a post-commit cleanup caused error):
> DEBUG: AbortCurrentTransaction
> PANIC: cannot abort transaction 14135438, it was already committed
I think this is an artifa
""Chun Yit(Chronos)"" <[EMAIL PROTECTED]> wrote
> saw from the log file, it's possible that server crash during
> vacuum process...
>
> Question :
> 1) what happen to my database server? what the error meaning?
>
It looks like index "pg_class_relname_nsp_index" (which is an index on
pg_class) is
Sebastian Böck wrote:
> Hello all,
>
> I think I found a little but annoying bug in views when ordering is
> involved. First, my version of Postgres:
>
> PostgreSQL 8.1.3 on i386-portbld-freebsd6.1, compiled by GCC cc (GCC)
> 3.4.4 [FreeBSD] 20050518
>
> Please try the following:
>
> CREATE TAB
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kenneth
DownsSent: 15 May 2006 14:24Cc:
pgsql-general@postgresql.orgSubject: Re: [GENERAL] GUI
Interface
Dave Page wrote:
kernel 2.6.8KDE
3.3.2gtk+ 2.4.14pgadmin3 1.2.2The window ma
Dave Page wrote:
kernel 2.6.8
KDE 3.3.2
gtk+ 2.4.14
pgadmin3 1.2.2
The window manager would be whatever the default for KDE is.
OK, the first thing you really should do is
upgrade to pgAdmin 1.4.2 and (if building form source) wxWidgets 2.6.3.
There have b
Hello
all,
I would like to ask
if anyone can explain or point me to some sort of query that would get the
sequences for a database along with the current value they
contain.
I have been able to
get the sequence names, but I can get their values all in one query. >From the
documentation
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Florian G. Pflug
> Sent: 14 May 2006 18:50
> To: Tino Wildenhain
> Cc: Kenneth Downs; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] GUI Interface
>
> It only happens in pgAdmin III, thoug
Use 'EXECUTE' to dynamically build SQL:http://www.postgresql.org/docs/8.1/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
-MikeOn 13 May 2006 14:15:52 -0700, [EMAIL PROTECTED] <[EMAIL PROTECTED]
> wrote:Using PL/PGSQL, I am trying to create a procedure to display the count
of
am 13.05.2006, um 14:15:52 -0700 mailte [EMAIL PROTECTED] folgendes:
> Using PL/PGSQL, I am trying to create a procedure to display the count
> of rows in any single table of a database. The End-user would pass in a
> table name and the prodecure would display the table name with the row
> count.
The core file usually appears in the data directory of the backend.
If you still can't find it, you can try attaching gdb to the running
backend. After the connection has started, find the backend (not the
postmaster) and attach using:
gdb -p
Once connected, type "cont" and proceed with the act
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] (Tom Lane) wrote:
> Martijn van Oosterhout writes:
> > I beleive you can set it to EXTERNAL, which it will always toast.
>
> I don't think that will help; if the overall row size is below the
> threshold, the code is not going to pick it apart t
Hi,
I have done the below command and restarted the server and built my
triggers with the -g command using gcc, but I cannot seem to find any
core files nor any reference to where postgres may place them. Where
would they normally appear?
Cheers
Chris
Probably the easiest thing to do is make s
Hello all,
I think I found a little but annoying bug in views when ordering is
involved. First, my version of Postgres:
PostgreSQL 8.1.3 on i386-portbld-freebsd6.1, compiled by GCC cc (GCC)
3.4.4 [FreeBSD] 20050518
Please try the following:
CREATE TABLE datum (
projekt_id INTEGER NOT NUL
Hi to all!
I am a student in Computer Science, and in Databases' Technology
course I must to write
a report on physical structures of DBMS's. I choosed PostgreSQL; I
looked the sources, and
I have understood the block structure. And relations? And databases?
How are structured?
Thanks!!!
--
Using PL/PGSQL, I am trying to create a procedure to display the count
of rows in any single table of a database. The End-user would pass in a
table name and the prodecure would display the table name with the row
count.
I am able to hardcode the variable for table and get the appropriate
results f
On Fri, 2006-05-12 at 07:31 -0500, Tony Caduto wrote:
> Dave Page wrote:
> > Only runs on Windows though doesn't it?
> >
> > Regards, Dave
> >
> >
> Hardly a limitation since Linux and other Unix based operating systems
> account for a trivial percent of the desktop market. I would guess that
After you install postgres using 'root', create your postgres database
cluster (initdb ) as "postgres" rather than "root". Your database
files therefore should be owned by "postgres" not root.
--
Husam
http://firstdba.googlepages.com
Martijn van Oosterhout wrote:
> On Thu, May 11, 2006 a
Hi,
my postgresql version 7.4.5 cannot start until this
morning, when i check the log file, it give me this error
this is part of my log file
DEBUG: vacuuming
"pg_catalog.pg_class"DEBUG: "pg_class": found 9823 removable, 1017
nonremovable row versions in 205 pagesDETAIL: 0 dead row ver
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kenneth
DownsSent: 14 May 2006 23:12To:
pgsql-general@postgresql.orgSubject: Re: [GENERAL] GUI
Interface
gentoo linux on an AMD. here are some stats, if you tell me any
other packages you need versions
64 matches
Mail list logo
