Re: [ADMIN] Linux PostgreSQL to Windows PostgreSQL

[CoL]

hi,
Sudhakar Kurumella wrote:
Hello,
 
We have to move from Linux based PostgreSQL to Windows based PostgreSQL. 
Highly appreciated for Any ideas of smooth export/import options.
http://www.postgresql.org/docs/7.4/interactive/migration.html
http://www.postgresql.org/docs/7.4/interactive/backup.html
C.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] Tool to compare db schemas?

[CoL]

hi,
Chris Hoover wrote:
Does anyone know of a good tool to compare db schemas?  I have over 200 db's 
that should all have identical schemas and have been asked to report on the 
differences.
if you looking for a program, check
http://ems-hitech.com/pgsqlutils/index.phtml#pgcomparer
but you can write your own scripts to compare schemas, even in plpgsql 
too with different servers (using dblink)

C.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] Perl stored procedures

[CoL]

hi,
Rahul k wrote:
Im looking for some documentation on writing stored
procedures using PL/Perl. The PostrgeSQL tutorials
give only a brief introduction to this which is good
but enough :
http://www.postgresql.org/docs/7.4/static/plperl.html
Can anyone pls send any links to more documentation.
what more do you want to know? For more perl details check the perl 
manuals. If you looking for manage triggers from plperl see:
http://www.commandprompt.com/entry.lxp?lxpe=285

C.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
  http://archives.postgresql.org

Re: [ADMIN] Going from a DB using SQL_ASCII to UNICODE

[CoL]

hi,

Dion Almaer wrote, On 4/19/2004 21:44:
- ERROR:  missing data for column "noiselevel"
- CONTEXT:  COPY messages, line 1: "4393  -1  144114147   0
2000-10-12 18:30:58-05  EJB Design Questions\N  Hi,"
for this one: better to dump with: -d

C.

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] Going from a DB using SQL_ASCII to UNICODE

[CoL]

hi,

Dion Almaer wrote, On 4/19/2004 21:44:
- ERROR:  invalid byte sequence for encoding "UNICODE": 0xe9616c
and for this: convert your dump with iconv to unicode, then load it.

C.

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
 subscribe-nomail command to [EMAIL PROTECTED] so that your
 message can get through to the mailing list cleanly

Re: [ADMIN] Disable Trigger

[CoL]

hi,

Charles Haron wrote, On 3/23/2004 21:48:

Is there a way to temporarily disable a trigger without dropping and 
re-adding it?
if you ever use dump:
pg_dump --disable-triggers ...
off:
UPDATE pg_catalog.pg_class SET reltriggers = 0 WHERE oid = 
'tablename'::pg_catalog.regclass;

on:
UPDATE pg_catalog.pg_class SET reltriggers = (SELECT pg_catalog.count(*) 
FROM pg_catalog.pg_trigger where pg_class.oid = tgrelid) WHERE oid = 
'tablename'::pg_catalog.regclass;

C.

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

Re: [ADMIN] getting postgresql-7.4.1 statistics

[CoL]

hi,

Victor Sudakov wrote:
I still cannot find the average number of queries per second. Could
you please be more specific.
there is no such. You have to write it for your own if you want. Or you 
can log statements to a log file, and then parse that file.

C.

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
  http://www.postgresql.org/docs/faqs/FAQ.html

Re: [ADMIN] ERD tool for postgres?

[CoL]

Hi,

Grega Bremec wrote, On 1/3/2004 5:53 PM:
and on Fri, Jan 02, 2004 at 11:10:30AM -, Nigel Bishop used the keyboard:
Hi

Has anyone come across a ERD tool for postgres - preferably free

Regrads

Nigel
Hello, Nigel.

There was a thread on this topic opened by Gautam Saha in early november 2003.

What came out of it was the following list of apps/URLs:
on more:
http://ems-hitech.com/pgmanager/
30 days trial.
C.

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

Re: [ADMIN] PostgreSQL: query optimizer: viewing query plans

[CoL]

Hi,

Neil Zanella wrote:

Hello,

Several textbooks talk about query trees and query plans including the following
relatively recent book  which covers
how to apply performance tuning techniques by using knowledge about the query 
optimizer to rewrite SQL queries so that they get interpreted more efficiently.

Unfortunately the book only shows how to view the query plan associated witht the
given query for Oracle, IBM DB2, and MS SQL Server. I wonder whether PostgreSQL
also has a way to let the user see the heuristically computed query plan created
by the query optimizer. Is it possible to view query plans with PostgreSQL server
and its related command line interfaces? How would I run such a command?
explain query
explain analyze query
and you can set logging in postgres.conf, and you can log 
debug_print_XXX  things (xxx like parse, rewritten query, the plan)

C.

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

Re: [ADMIN] performance problem - 10.000 databases

[CoL]

Hi,

Christopher Browne wrote, On 11/6/2003 4:40 PM:

[EMAIL PROTECTED] (Jeff) writes:
On 06 Nov 2003 15:21:03 +0100
Marek Florianczyk <[EMAIL PROTECTED]> wrote:
fsync = false   
HOLD THE BOAT THERE BATMAN!

I would *STRONGLY* advise not running with fsync=false in production as
PG _CANNOT_ guaruntee data consistancy in the event of a hardware
failure.  It would sure suck to have a power failure screw up your nice
db for the users!
On one of our test servers, I set "fsync=false", and a test load's
load time dropped from about 90 minutes to 3 minutes.  (It was REALLY
update heavy, with huge numbers of tiny transactions.)
Which is, yes, quite spectacularly faster.  But also quite
spectacularly unsafe.
I'm willing to live with the risk on a test box whose purpose is
_testing_; it's certainly not a good thing to do in production.
There is something like: set fsync to off; or set fsync to on;
But it says: 'fsync' cannot be changed now. However could be very useful 
to set this option from sql, not just from config.

Tom Lane probably knows why :)

C.

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
 joining column's datatypes do not match

Re: [ADMIN] Multi-Language server

[CoL]

Using unicode?

C.

Stephen J. Thompson wrote, On 10/22/2003 8:55 PM:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello all,

I am looking for suggestions to the following problem. I need to run a 
database server that needs to allow the entry and searching in multiple 
languages including multibyte ones. 

Does anyone have reccomendations on the database server configuration, 
pitfalls etc.

Thanks.



---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[ADMIN] Version number question

[Villalba, Juan Jose - (Col)]

   Hi all. I have just installed PostgreSQL 7.0 using Cygwin under Windows
2000 Professional + SP2. It seems to work fine, but when I start the
database (by running postgres.exe) it reports an error:

DEBUG:  Data Base System is starting up at Tue Sep  2 08:12:36 2003
DEBUG:  Data Base System was interrupted being in production at Wed May 24
09:27:52 2000
DEBUG:  Data Base System is in production state at Tue Sep  2 08:12:36 2003
FATAL 1:  Version number in file 'd:\databases\postgresql70/PG_VERSION'
should be 7.0
, not 7.0
.
FATAL 1:  Version number in file 'd:\databases\postgresql70/PG_VERSION'
should be 7.0
, not 7.0
.

   Does anyone know why this happens and/or how can I solve it? thanks a
lot.



---(end of broadcast)---
TIP 8: explain analyze is your friend

Re: [ADMIN] Is there any eqvivalent or alternative to UPDATE(column) or COLUMNS_UPDATED()

[CoL]

Yes, i know, I just write, that these are the possibilities. Or are 
there any else?

C.

Klaus Sonnenleiter wrote, On 12/31/2002 3:25 PM:
I think the question was how to find out which columns were affected by the 
update statement. TG_OP will only tell you whether an update fired the 
trigger.

Klaus

On Thursday 26 December 2002 03:29, CoL wrote:
http://www.postgresql.org/idocs/index.php?trigger-manager.html
http://www.postgresql.org/idocs/index.php?plpgsql-trigger.html
TG_OP ?

C.

shreedhar wrote, On 12/26/2002 12:57 PM:
> Is there any eqvivalent or alternative to the following IF UPDATE(column)
> or IF(COLUMNS_UPDATED()) of SQLServer2000.
>
> IF UPDATE (column)
>
> Tests for an INSERT or UPDATE action to a specified column and is not
> used with DELETE operations. More than one column can be specified.
> Because the table name is specified in the ON clause, do not include the
> table name before the column name in an IF UPDATE clause. To test for an
> INSERT or UPDATE action for more than one column, specify a separate
> UPDATE(column) clause following the first one. IF UPDATE will return the
> TRUE value in INSERT actions because the columns have either explicit
> values or implicit (NULL) values inserted.
>
> IF (COLUMNS_UPDATED())
>
> Tests, in an INSERT or UPDATE trigger only, whether the mentioned column
> or columns were inserted or updated. COLUMNS_UPDATED returns a varbinary
> bit pattern that indicates which columns in the table were inserted or
> updated.
>
> Thanks And Regards,
>
> Sreedhar

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] postsgresql-dump not found in install

[CoL]

you mean: pg_dump ?
C.

Tony Ziolkowski wrote, On 12/29/2002 9:06 PM:

I just upgraded my redhat linux from 7.2 to 8.0. During that process 
postgresql 7.2.2 was installed on the system. According to the 
documentation i should run postgresql-dump. However, I can't find that 
program anywhere. Aside from the obvious of uninstalling 7.2, what can I do?

Thanks



---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] Is there any eqvivalent or alternative to UPDATE(column) or COLUMNS_UPDATED()

[CoL]

http://www.postgresql.org/idocs/index.php?trigger-manager.html
http://www.postgresql.org/idocs/index.php?plpgsql-trigger.html
TG_OP ?

C.

shreedhar wrote, On 12/26/2002 12:57 PM:

Is there any eqvivalent or alternative to the following IF UPDATE(column) or
IF(COLUMNS_UPDATED()) of SQLServer2000.

IF UPDATE (column)

Tests for an INSERT or UPDATE action to a specified column and is not used
with DELETE operations. More than one column can be specified. Because the
table name is specified in the ON clause, do not include the table name
before the column name in an IF UPDATE clause. To test for an INSERT or
UPDATE action for more than one column, specify a separate UPDATE(column)
clause following the first one. IF UPDATE will return the TRUE value in
INSERT actions because the columns have either explicit values or implicit
(NULL) values inserted.

IF (COLUMNS_UPDATED())

Tests, in an INSERT or UPDATE trigger only, whether the mentioned column or
columns were inserted or updated. COLUMNS_UPDATED returns a varbinary bit
pattern that indicates which columns in the table were inserted or updated.

Thanks And Regards,

Sreedhar



---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Re: [ADMIN] UNICODE -> SJIS problem

[CoL]

pg_client_encoding ?
Did you set to unicode ?
C.

Jefim Matskin wrote:

I'm trying to develop an international app that will work for the far east =
countries too.
Working with the PostgreSQL 7.3 and have created a database with the Unicod=
e encoding (createdb -E unicode ...)
I have an external data source that holds some japaneese data in the UTF-8 =
encoding.=20
I'm managing to read this data source and insert the data into my postgres =
database.
The troubles start when I'm try to display the data using SJIS client encod=
ing. The data is returned as unicode (UTF-8).=20

Please help.


Jefim Matskin



---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] DB management tool for linux

[CoL]

http://ems-hitech.com/pgsqlutils/download.phtml
http://gborg.postgresql.org/browse.php?81

C.
Benjamin Stewart wrote, On 11/21/2002 11:40 PM:

Greetings,
After a few suggestions for a good DB managmen application for linux. I 
have found a few and they are a little average. Appears that there are 
some good applicaitons in windows, but not linux.

Thanks
Ben



---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] Replication, High availability

[CoL]

Hi,
check this link:
http://usogres.good-day.net/

C.

Wojciech Bernacki wrote:
>   My online app uses PostgreSQL 7.2 running on a single Debian box. I also have 
> a spare machine witch may act as a backup server. After even hardware 
> breakdowns the whole system must be up and running in no more than couple of 
> minutes. How to achieve this goal? Is Postgresql-R 7.2 already worth trying? 
> Has anyone used drbd or Coda in simmilar cases? Can you share your 
> experiences? Thanks in advance for any suggestions.
> 
>   Wojciech Bernacki


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html