[ADMIN] pg 7.3.4 and linux box crash

Hi, I am runing linux red hat 7.3 (standart install) on dual athlon box , 1 GB ram and pg 7.3.4. If I try to access with pgAdmin one from my tables (i contains ~ 1 M records) the linux box crashes. In my pg log I can find: ERROR: Invalid page header in block 5604 of a_acc before this error I

[ADMIN] unsubsribe

unsubsribe pgsql-admin __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?

[ADMIN] Problem with Sequences

Hello all, I am new here... I have a Problem by one of our Applications. The Frontend ist an Access-Application who connects through ODBC to the postgres-database (7.3.2). Two of the three Applications works fine. The other have possibly an Problem with Sequences. The Problem is the folowing:

Re: [ADMIN] Row locking during UPDATE

I didn't see any response to this. Sorry if this is already stale for you. On Thu, Sep 04, 2003 at 08:21:17AM -0400, David F. Skoll wrote: Questions: 1) Am I on the right track? Is this how PostgreSQL works? More or less, yes. The significant part here is that the postmaster won't notice

Re: [ADMIN] Row locking during UPDATE

On Fri, 12 Sep 2003, Andrew Sullivan wrote: More or less, yes. The significant part here is that the postmaster won't notice that the client is gone until it returns from the work it was trying to do. It'll eventually come back, but it'll take some time. How low does your contention need

Re: [ADMIN] pg 7.3.4 and linux box crash

pginfo [EMAIL PROTECTED] writes: In my pg log I can find: ERROR: Invalid page header in block 5604 of a_acc You have a corrupt table. Can you drop and recreate a_acc? before this error I see also : FATAL: Database template0 is not currently accepting connections ERROR: Relation

Re: [ADMIN] Problem with Sequences

Markus Espenhain [EMAIL PROTECTED] writes: On user who works with the Database create an new record and save this. Here the record becomes an ID and another Number from an two sequences. One other user ist in this moment working with the database and create an new record, too. Now he

[ADMIN]

unsubscribe pgsql-admin ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [ADMIN] pg 7.3.4 and linux box crash

Hi, Tom Lane wrote: pginfo [EMAIL PROTECTED] writes: In my pg log I can find: ERROR: Invalid page header in block 5604 of a_acc You have a corrupt table. Can you drop and recreate a_acc? Yes I can.The problem is that it is happen for 4 times in this week. It is happen on 2 diferent

Re: [ADMIN] pg 7.3.4 and linux box crash

pginfo [EMAIL PROTECTED] writes: Tom Lane wrote: You have a corrupt table. Can you drop and recreate a_acc? Yes I can.The problem is that it is happen for 4 times in this week. Oh? Perhaps you should be looking at the contents of the complained-of pages to try to see what's going on. Is

Re: [ADMIN] pg 7.3.4 and linux box crash

Tom Lane wrote: pginfo [EMAIL PROTECTED] writes: Tom Lane wrote: You have a corrupt table. Can you drop and recreate a_acc? Yes I can.The problem is that it is happen for 4 times in this week. Oh? Perhaps you should be looking at the contents of the complained-of pages to try to

[ADMIN] object creation date

How can I identify table creation date as opposed to last modified? Thanks. -Marie ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [ADMIN] pg 7.3.4 and linux box crash

On Fri, 12 Sep 2003, pginfo wrote: Hi, I am runing linux red hat 7.3 (standart install) on dual athlon box , 1 GB ram and pg 7.3.4. If I try to access with pgAdmin one from my tables (i contains ~ 1 M records) the linux box crashes. WAIT. Do you mean you get a kernel panic? Or the box

[ADMIN] timestamp with timezone

Folks, Our databases stores most of the dates as timestamp with timezone format, so the data looks like this... 09/12/2003 12:51:31.268 PDT 09/12/2003 12:50:20 PDT some has centiseconds in them along with TZ. Now i'm wondering is there a way to just extract date and timestamp alone leaving the

Re: [ADMIN] timestamp with timezone

oops forgot to mention, database version is 7.3.2 --- Shankar K [EMAIL PROTECTED] wrote: Folks, Our databases stores most of the dates as timestamp with timezone format, so the data looks like this... 09/12/2003 12:51:31.268 PDT 09/12/2003 12:50:20 PDT some has centiseconds in them

Re: [ADMIN] object creation date

Marie G. Tuite writes: How can I identify table creation date as opposed to last modified? Not unless you keep track of it yourself. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives?

[ADMIN] Casting varchar to bytea

Hi. Could someone please tell me how to convert a varchar to a bytea datatype. I have a column which contains a number stored as a varchar. I have another column of type bytea. I'm trying to insert the value of the varchar column in the bytea column, but the conversion won't work. Something

Re: [ADMIN] object creation date

Hello Marie, In most of my tables, I have the same two columns: lastupdateTIMESTAMP not null default ('now'::text)::timestamp(8), createdateTIMESTAMP not null default ('now'::text)::timestamp(8)

Re: [ADMIN] Row locking during UPDATE

On Fri, Sep 12, 2003 at 09:53:47AM -0400, David F. Skoll wrote: Note that if you do this very frequently, and you have also to select the summary data, it won't work (as I have learned from painful experience) because the holding table will gradually build up a lot of dead tuples. That

Re: [ADMIN] Casting varchar to bytea

On Friday 12 September 2003 20:39, Dylan Milks wrote: Hi. Could someone please tell me how to convert a varchar to a bytea datatype. I have a column which contains a number stored as a varchar. I have another column of type bytea. I'm trying to insert the value of the varchar column in the

Re: [ADMIN] Casting varchar to bytea

Thanks, that helped. This is what we did: (to encode VARCHAR - BYTEA) update webuser set ccnum = decode(ccnumstring, 'escape') where userid=userid (to decode BYTEA - VARCHAR) select encode(ccnum, 'escape') from webuser But what about decrypting with the AES encryption algorithm? Dylan

[ADMIN] unsubscribe

Fondo de Gráficos circulares.jpgBEGIN:VCARD VERSION:2.1 N:Albospino;Héctor A. FN:Héctor A. Albospino EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20030912T205149Z END:VCARD ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] timestamp with timezone

Shankar K [EMAIL PROTECTED] writes: some has centiseconds in them along with TZ. Now i'm wondering is there a way to just extract date and timestamp alone leaving the centisecods as well the TZ part. You mean you want to round off to even seconds? Try date_trunc, or cast to timestamp(0)

Re: [ADMIN] timestamp with timezone

You mean you want to round off to even seconds? Try date_trunc, or cast to timestamp(0) with time zone. well, i just need to trunc whatever thats after the timestamp i.e from 06/10/2003 12:50:19.188 PDT, i need to remove .188 PDT i'll see if date_trunc helps me or not. thanks for the

[ADMIN] table-column relation

Hi, does anybody know the internal pg_ tables that has table/column definitions defined (similar to user_tab_columns in oracle) thanks, Shankar __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com