Re: [ADMIN] Problem with timestamp

Mageshwaran <[EMAIL PROTECTED]> writes: > We have our application which uses postgres 7.1.3 version in > that we use a time functions like now(),timestamp. etc mostly > timestamp without timezone.We don't need the timezone in that variable > so we ignore it using timestamp without

[ADMIN] Problem with timestamp

Hi, We have our application which uses postgres 7.1.3 version in that we use a time functions like now(),timestamp. etc mostly timestamp without timezone.We don't need the timezone in that variable so we ignore it using timestamp without timezone. The same is not working with high

[ADMIN] pg_dump: Error message from server: ERROR: compressed data is corrupt

Do usual pg_dump today and have got an error. - pg_dump: SQL command failed pg_dump: Error message from server: ERROR: compressed data is corrupt pg_dump: The command was: COPY public.candidates (id, name, surname, mid_name, compensation, created, birthday, updated, creator_i

Re: [ADMIN] ALTER TABLE - ALTER COLUMN question

After I sent my request I found the notes related to ALTER TABLE on page 1,331 of the 8.1 manual, so that helped to explain it. Your reply to my post confirmed what I thought I was reading. Thanks for the reply, Keaton On Tue, 2007-05-29 at 17:16 -0400, Tom Lane wrote: > Keaton Adams <[EMAIL

Re: [ADMIN] ALTER TABLE - ALTER COLUMN question

Keaton Adams <[EMAIL PROTECTED]> writes: > In this example the created and msg_datetime columns are currently > defined as TIMESTAMP WITHOUT TIME ZONE and no default. If the alter > table for these changes is not in-place then I would want to run it as a > single alter with all of the changes, suc

[ADMIN] ALTER TABLE - ALTER COLUMN question

When I issue an alter table . alter column command, the table contents are copied from the old structure to the new, correct? So I need 2x the table space available so the old and new tables can exist at the same time? PostgreSQL doesn't use an in-place alter-table for these types of changes,

Re: [ADMIN] Grant SELECT on all tables of a database

This does the JOB...thank you very much Oliver Elphick <[EMAIL PROTECTED]> wrote: On Tue, 2007-05-29 at 10:21 -0700, Marsha Ramsey wrote: > Hello all, > > How do I GRANT SELECT to all my tables at once? I have over 1026 > tables in this database... I don't think there is any direct SQL co

Re: [ADMIN] Grant SELECT on all tables of a database

On Tue, 2007-05-29 at 10:21 -0700, Marsha Ramsey wrote: > Hello all, > > How do I GRANT SELECT to all my tables at once? I have over 1026 > tables in this database... I don't think there is any direct SQL command to do it. But try this: psql -d your_database \t \a \o /tm

[ADMIN] Grant SELECT on all tables of a database

Hello all, How do I GRANT SELECT to all my tables at once? I have over 1026 tables in this database... Thanks...Marsha - It's here! Your new message! Get new email alerts with the free Yahoo! Toolbar.

[ADMIN] Out of Memory on Reindex

I am getting the following error when trying to run a reindex on one of my databases. reindexdb: reindexing of database "xxx" failed: ERROR: out of memory DETAIL: Failed on request of size 268435456. Can someone advise on what memory parameter was violated? Are we looking at work_mem, shmmax,

Re: [ADMIN] PostgreSQL Training?

Also note that RedHat does PostgreSQL training: https://www.redhat.com/training/developer/courses/rdb147.html Note, however, that this is "RedHat Database" training. "RedHat Database" was a rebranded PostgreSQL 7.3.4 introduced back around 2004; so I'm not sure if this training would include

Re: [ADMIN] ERROR: invalid memory alloc request size

On Mon, May 28, 2007 at 11:18:37AM -0400, Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > Johann Spies wrote: > >> #3 0x005ff1c8 in perform_default_encoding_conversion ( > >> src=0x2b881e87f040 "\"2007-04-20\" \"18:07:06\" \"192.168.0.100\" \"73\" > >> \"http://www.kerkbo

Re: [ADMIN] PostgreSQL Training?

On May 18, 2007, at 2:11 PM, Chris Hoover wrote: I did run across www.otg-nc.com, does anyone have comments on their admin and performance tuning classes? This is very appealing to me since they are only a few hours away. They're on the east coast, right? I know that we (EnterpriseDB) will

Re: [ADMIN] Performance Monitor

On May 23, 2007, at 10:11 PM, Jair Elton Batista wrote: How to monitor PgSQL performance, like JConsole for Java Virtual Machine? Usage of memory, CPU, etc. Use the OS level tools. There's also a chapter in the documentation dedicated to monitoring. -- Jim Nasby

Re: [ADMIN] increasing of the shared memory does not solve theproblem of "OUT of shared memory"

On May 17, 2007, at 4:14 AM, Sorin N. Ciolofan wrote: It seems that the problem was the max_fsm_relations parameter which was increased I still do not understand why in the past I received always the message: ERROR: out of shared memory Is this an appropriate message for the need for increa