[ADMIN] Why dos select work when pg_dump fails?

For whatever reason, I'm back dealing with corrupted tables but curiously while this fails: pg_dump -U postgres -a -t table -f /data/table.dump this works: psql -U postgres -A -o /data/table.dump -c "SELECT * FROM table;" Graned the format of the data is different, but regardless, the data is

[ADMIN] Enable Syslog on Postgres

Hi, I have installed Postgres 8.2.5 on windows xp machine using the windows installer. I am trying to enable syslogs on Postgres so that all Postgress logs should be forwarded Syslog server. I have installed Syslog server WinSyslog on the same machine. I have modified 'log_destination' paramet

Re: [ADMIN] Enable Syslog on Postgres

> I have installed Postgres 8.2.5 on windows xp machine using the windows > installer. I am trying to enable syslogs on Postgres so that all Postgress > logs should be forwarded Syslog server. I have installed Syslog server > WinSyslog on the same machine. > > I have modified 'log_destination' para

Re: [ADMIN] Why dos select work when pg_dump fails?

Darren Reed <[EMAIL PROTECTED]> writes: > For whatever reason, I'm back dealing with corrupted tables but > curiously while this fails: > pg_dump -U postgres -a -t table -f /data/table.dump > this works: > psql -U postgres -A -o /data/table.dump -c "SELECT * FROM table;" pg_dump is evidently fa

Re: [ADMIN] Enable Syslog on Postgres

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 28 Nov 2007 18:55:38 +0800 "Bansal, Gaurav (Gaurav)" <[EMAIL PROTECTED]> wrote: > Hi, > > I have installed Postgres 8.2.5 on windows xp machine using the > windows installer. I am trying to enable syslogs on Postgres so that > all Postgress

[ADMIN] clear statistics in pg_stat

How can I clear pg_stat views? I thought there was a command I could do. I added a series of indexes. I would like to start out fresh with the stats. I ran vacuum full analyze. Thanks, Lance Campbell Project Manager/Software Architect Web Services at Public Affairs University of Illi

[ADMIN] Converting from SQL_ASCII to UTF8

Hi all, I'd like to move my database encoding from SQL_ASCII to UTF8, mostly because "No encoding conversion will be done when the setting is SQL_ASCII. Thus, this setting is not so much a declaration that a specific encoding is in use, as a declaration of ignorance about the encoding." (from http

Re: [ADMIN] clear statistics in pg_stat

On Thu, Nov 29, 2007 at 03:32:59PM -0600, Campbell, Lance wrote: > How can I clear pg_stat views? I thought there was a command I could According to the manual, there's this: pg_stat_reset() I suggest you read the section of the manual about stats collection. A -- Andrew Sullivan Old sigs wi

Re: [ADMIN] clear statistics in pg_stat

Campbell, Lance написа: > How can I clear pg_stat views? I thought there was a command I could > do. I added a series of indexes. I would like to start out fresh with > the stats. I ran vacuum full analyze. "pg_stat_reset()"? (http://www.postgresql.org/docs/current/static/monitoring-stats.ht

Re: [ADMIN] Converting from SQL_ASCII to UTF8

"Peter Koczan" <[EMAIL PROTECTED]> writes: > I have some UTF-8 data in my databases, and it's causing dump/restore > to fail. Specifically, I'm seeing messages like: > pg_restore: [archiver (db)] COPY failed: ERROR: invalid byte sequence > for encoding "UTF8": 0xe14c65 This is, in fact, not UTF8,