Re: [ADMIN] create view with check option

are you trying to declare a view with check option using a 8.2 engine? Can you show us the part of manual that say you can use that syntax? I see: CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] VIEW name [ ( column_name [, ...] ) ] AS query Regards Gaetano Mendola ---(end

Re: [ADMIN] create table like syntax

; Regards Gaetano Mendola ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [ADMIN] archive_command

| grep -v ${FILE} | xargs -i rm -fr {} } At that time Tom Lane agreed to provide some functions to ask the engine the name of WAL currently in use, dunno if in the new 8.1 something was done in order to help this process. Regards Gaetano Mendola ---(end of broadcast

Re: [ADMIN] Altering WAL Segment File Size

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

Re: [ADMIN] Disk Access Question

partition ( on Linux ) specifing the noatime option this will avoid your inode access time to be updated when files are only read. Postgres do not use this information so you are safe. Regards Gaetano Mendola ---(end of broadcast)--- TIP 9

[ADMIN] RPM 8.0.3 for RH7.3, RH7.2 and AS2.1

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'm trying to create the rpm for these distributions, I'm using the one available for RH9.0 but I got: On RH7.3, RH7.2 and AS2.1 I get: # rpmbuild --rebuild postgresql-8.0.3-1PGDG.src.rpm [...] checking for perl... /usr/bin/perl checking for

Re: [ADMIN] Creating tables...not a usual question (I think)

of the database??? Why it should? If an user have permission to create table why the tables created shall be owned by another user ? It's like you create a file in your filesystem and the owner is someone else. Regards Gaetano Mendola ---(end of broadcast

[ADMIN] Vacuum full on a big table

that table for a long period. It will work decresing the FSM settings ? Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.5 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCOfIs7UpzwH2SGd4RAsXaAKDIgcNZLqsYULjnNVNhTktXvWmJTgCg4zcK V

Re: [ADMIN] Vacuum full on a big table

running pg_autovacuum since one month now, but I see that for same table is a disaster do not vacuum full once in a day. and no, you can't vacuum parts at a time. it's all or nothing. (*Unless that changes in 8.0...*) I wish that this happen. Regards Gaetano Mendola -BEGIN PGP

Re: [ADMIN] Partitioning Option?

. Regards Gaetano Mendola ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [ADMIN] Partitioning Option?

with 7.4.x the horizontal partition is not applicable, see my post on performance ( horizontal partition ) As soon you use the view with all UNION joined with other table you loose the index usage on that view :-( Regards Gaetano Mendola ---(end of broadcast

Re: [ADMIN] Partitioning Option?

runtime: 37122.069 ms (10 rows) I did a similar attempt with UNION ALL but the result is the same. Regards Gaetano Mendola ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister

Re: [ADMIN] Determining current WAL

created one Regards Gaetano Mendola ---(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] max connections from one ip

wrote: Hi all! Can I restrict max number of connections from one IP address? -- Thanks No within postgres, may be you can play with iptables or something like that Regards Gaetano Mendola ---(end of broadcast)--- TIP 8: explain analyze

Re: [ADMIN] Index relation size

to newest version at the moment). Are these index sizes indicating some problems with our Postgres server? If you do not vacuum full, this is normal. Using a version 7.4 then a normal vacuum shall be enough. Regards Gaetano Mendola ---(end of broadcast

Re: [ADMIN] About System Catalogs

in the 8.0. Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [ADMIN] replication using WAL archives

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Simon Riggs wrote: |Gaetano Mendola wrote |Postgres can help this process, as suggested by Tom creating a | | pg_current_wal() | |or even better having two new GUC parameters: archive_current_wal_command | | and | |archive_current_wal_delay. | | | OK

Re: [ADMIN] replication using WAL archives

die, the restore.sh will copy logN+2 in the archived directory, the spare node will execute restore.sh with file logN+1 as argument and if is not found then the restore.sh will exit. Regards Gaetano Mendola ---(end of broadcast)--- TIP 8: explain

Re: [ADMIN] NIC to NIC connection

is not sent to all ports but only to that ports where someone sent an arp packet saying the he was registered to a multicast address. However I don't think exist a standard. Regards Gaetano Mendola ---(end of broadcast)--- TIP 2: you can get off all lists

Re: [ADMIN] replication using WAL archives

:-( == I hope that is clear. Regards Gaetano Mendola #!/bin/bash SOURCE=$1 TARGET=$2 PARTIAL=$3 SIZE_EXPECTED=16777216 #bytes 16 MB DIED_TIME=60#seconds function test_existence { if [ -f ${SOURCE} ] then COUNTER=0 #I have to check

Re: [ADMIN] NIC to NIC connection

Jay A. Kreibich wrote: On Thu, Oct 21, 2004 at 10:07:33AM +0200, Gaetano Mendola scratched on the wall: Bruno Wolff III wrote: Also I believe that if a switch doesn't remember where a particular mac address is it will send the packet to all of the attached ports. I don't think so, I guess

Re: [ADMIN] NIC to NIC connection

Jay A. Kreibich wrote: On Thu, Oct 21, 2004 at 07:05:40PM +0200, Gaetano Mendola scratched on the wall: We have some switches that are able to do ip routing too... :-( So called layer-three switches are a whole different game. Ok that's explain all, I was able to create two different

[ADMIN] Single table vacuum full different when vacuum full the whole database

aggressive. My FSM setting are enough: INFO: free space map: 281 relations, 33804 pages stored; 27344 total pages needed DETAIL: Allocated FSM size: 1000 relations + 200 pages = 11780 kB shared memory. Regards Gaetano Mendola ---(end of broadcast

Re: [ADMIN] Single table vacuum full different when vacuum full the whole

Tom Lane wrote: Gaetano Mendola [EMAIL PROTECTED] writes: it seems that a vacuum full on the whole DB is more aggressive. It is not. A much more plausible theory is that this is the result of concurrent changes to the table. It is clear from the dead row versions stats that there were

Re: [ADMIN] Postmaster terminated without any error message

roger wrote: Thanks for your information. I couldn't find the ulimit setting in postgresql.conf. Where can I find it? I use the default settings in pgsql. Emh. ulimit is a OS command. Do an: ulimit -a and let us know... Regards Gaetano Mendola ---(end of broadcast

Re: [ADMIN] service not starting

are sure that postmaster is down, try to start it manually and see what it say: your_bin_path/postmaster -D path to your data directory if you are in a REDHAT or Fedora: /usr/bin/postmaster -D /var/lib/pgsql/data the command above suppose you already did an initdb... Regards Gaetano Mendola

Re: [ADMIN] Multiple WALs for PITR ?

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

Re: [ADMIN] Failover Solution for Postgres

recovery along with the other features that will be in that version. But that will have to wait. We use the cluster RH solution. Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] PLEASE GOD HELP US!

that the OP is running the server with sequential scan disabled ? Reagards Gaetano Mendola ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [ADMIN] logging

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

Re: [ADMIN] PLEASE GOD HELP US!

= true stats_command_string = true stats_block_level = true stats_row_level = true stats_reset_on_server_start = false Regards Gaetano Mendola ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [ADMIN] moving pg_xlog

Anjan Dave wrote: All: Whats the best way to separate pg_xlog to another drive? I am using a soft link currently in the data directory (per docs), but is there another way of doing this? Nope currently. Regards Gaetano Mendola ---(end of broadcast

Re: [ADMIN] stopping pg_autovacuum

? Do you know what does it mean that -9 ? Usually is not a good idea stop *nix process with the -9 signal. Be more nice with a kill -SIGTERM. Regards Gaetano Mendola ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister

Re: [ADMIN] Getting the OID of inserted row in a rule

'); give 1 #section2 select currval('test_a_seq'); give 2 Regards Gaetano Mendola ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [ADMIN] Important Question.

? kidding You have to install both in differents jails otherwise the code of one will try to overwrite the code of the other one, do you know corewars ? :-) /kidding I'm not aware of any problem. Regards Gaetano Mendola ---(end of broadcast)--- TIP 4

Re: [ADMIN] VACUUM FULL achieves nothing / Postgres 7.3.2 + RedHat 7.3

R. Willmington wrote: Gaetano Mendola [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... Are you sure you dont have connection in status: idle in transaction? Check with: ps -eafwww | grep post Gaetano Hello Gaetano, Thank you for the reply. I have checked the connections

Re: [ADMIN] VACUUM FULL achieves nothing / Postgres 7.3.2 + RedHat 7.3

R. Willmington wrote: Additional information: The applications using the database are java - based and create persistent connections (from a connection pool) to the postgres database. These connections are on autocommit, thus, there should not be any opened transactions preventing the vacuum

Re: [ADMIN] Dump/Restore vs Vacuum Full

for a vacuum full and reindex of all tables. The advantages are that the dump/restore is longer if your vacuum the database quite enough BTW, with 7.4.x there is no needs to run vacuum full so much Regards Gaetano Mendola ---(end of broadcast)--- TIP 1

Re: [ADMIN] backups and WAL

. I disagree instead: 1) Go on the first doc page: http://www.postgresql.org/docs/7.4/interactive/index.html 2) Search for backups 3) The first 4 entries are what you have to know Please do not take this as RTFM Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (MingW32

Re: [ADMIN] add serial no

6 | 4 8 | 5 (5 rows) Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [ADMIN] PostgreSQL as a DDBMS

it is horizontally fragmented and each fragment is located on different places (postgresql servers)? See that the Data Base is Unique, but the Data are distributed throught a horizontal partitioning. How PostgreSQL could help me to solve this problem? In one word: no. Regards Gaetano Mendola

Re: [ADMIN] What's the best way to use a Solid State HDD?

PostgreSQL? Depend what do you want obtain. Do you want speed up writes ? Are you annoyed by a full scan table that you can not avoid ? or what ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 7: don't forget to increase your free space map

[ADMIN] Documents storage

Hi all, where I work some times we need to find our documents searching for a couple of words. I was thinking to use the tsearch2. Shall I use OpenFTS? Do you have any suggestion ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you

Re: [ADMIN] Documents storage

Oleg Bartunov wrote: On Tue, 17 Aug 2004, Gaetano Mendola wrote: Hi all, where I work some times we need to find our documents searching for a couple of words. I was thinking to use the tsearch2. Shall I use OpenFTS? Do you have any suggestion ? tsearch2 is ok if you have docs and db on the same

Re: [ADMIN] Killing Long running query or user session

to be killed and kill it. Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] Killing Long running query or user session

if this can help you and/or if solve your problem. Regards Gaetano Mendola ---(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

Re: [ADMIN] Win32 and Tablespaces

Thomas Wegner wrote: Why are tablespaces not supported under Win32? Who sayd that ? In the last days Andreas Pflug commited a patch that will permit Win32 version to have tablespace. Regards Gaetano Mendola ---(end of broadcast)--- TIP 5: Have you

[ADMIN] running only pg_autovacuum for one week

recover 600MB of wasted space. Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFBDjzJ7UpzwH2SGd4RAvq0AKDYWd1yfdZDcTSsnfr8lrkcWFIftwCfRMrZ qEyKk6YppI6mM1scBRgdMHg= =4M5I -END PGP

Re: [ADMIN] running only pg_autovacuum for one week

Scott Marlowe wrote: On Mon, 2004-08-02 at 07:08, Gaetano Mendola wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I did the experiment of running only the autovacuum for one week without running my daily autovacuum full and reindex on heavy updated/inserted tables. Yesterday I

Re: [ADMIN] replication and linux-ha?

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

Re: [ADMIN] Utilizing multiple disks

Steve wrote: Gaetano, Thanks for your reply. Gaetano Mendola wrote: Are you performing queries using the like operator? If yes did you define an index on it using the right operator class ? Yes I do use the like operator to perform queries on a few 'varchar' and 'text' fields. I have indexed

Re: [ADMIN] Can't increase max connections

, thanks. Most likely you are out of shared memory segments that you OS allow. If you are on Linux try to pump-up shmmax and shmall Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

Re: [ADMIN] could not fork new process for connection: Cannot allocate memory

tipical usage of your system. I seen many Postgres installation with bunch of SHM wasted !!! Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFBBD0x7UpzwH2SGd4RAiGqAKDai6Pyu

Re: [ADMIN] Utilizing multiple disks

disk is the last optimization step, are you sure did you already reach the bootleneck of your sistem ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [ADMIN] Profiling

Mendola ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [ADMIN] Replication in main PostgreSQL codebase

to perform heavy queries on it without affect the master performances? You have to see the faces when the answer is: with an add-in. I believe that with the PITR + NT an or more integrated solutions in postgres are not too far away to be developed Regards Gaetano Mendola ---(end

Re: [ADMIN] Logging PostgreSQL output

LOCAL0.none in your /var/log.messages log ad ad that - char in front of your file location log now you have to SIGHUP both postgres and syslogd. Regards Gaetano Mendola ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose

Re: [ADMIN] [HACKERS] Point in Time Recovery

which problem PITR is addressing, I mean I know that is addressing a power off but how I will recover it ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [ADMIN] users connected

Cardoso Patrick wrote: Hi, Is it possible to know the number of users connected to a database ? select * from pg_stat_activity. I'm not sure about permissions you need for it, try. Regards Gaetano Mendola ---(end of broadcast)--- TIP 9

Re: [ADMIN] Slony NG

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Robert Treat wrote: | On Tue, 2004-07-13 at 19:56, Gaetano Mendola wrote: | |-BEGIN PGP SIGNED MESSAGE- |Hash: SHA1 | |Bruno Wolff III wrote: | || On Tue, Jul 13, 2004 at 15:32:49 +0200, || Gaetano Mendola [EMAIL PROTECTED] wrote

Re: [ADMIN] Slony NG

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Bruno Wolff III wrote: | On Tue, Jul 13, 2004 at 09:54:29 +0200, | Gaetano Mendola [EMAIL PROTECTED] wrote: | |Hi all, |why don't you create comp.database.postgresql.slony NG ? | | | It isn't that simple. For big 8 newsgroups you have to make

Re: [ADMIN] Slony NG

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Bruno Wolff III wrote: | On Tue, Jul 13, 2004 at 15:32:49 +0200, | Gaetano Mendola [EMAIL PROTECTED] wrote: | |-BEGIN PGP SIGNED MESSAGE- |Hash: SHA1 | |Bruno Wolff III wrote: | || On Tue, Jul 13, 2004 at 09:54:29 +0200, || Gaetano Mendola

Re: [ADMIN] How to list what queries are running in postgres?

Tom Lane wrote: Gaetano Mendola [EMAIL PROTECTED] writes: P.A.M. van Dam wrote: I'm looking for a command or method to find out what queries are currently being serviced by the database. select * from pg_stat_activity; ... having first remembered to turn on stats_command_string; and thou shalt

Re: [ADMIN] Capacity Planning

average ( the unix one ) is under 2. Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [ADMIN] How to list what queries are running in postgres?

P.A.M. van Dam wrote: Hi! I'm looking for a command or method to find out what queries are currently being serviced by the database. select * from pg_stat_activity; Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list

Re: [ADMIN] Capacity Planning

mode with a not so tuned RAID system and only 1 GB of RAM. I think that with 8 processors, good fiber channel access to your RAID, and good ammount of memory you can easily reach that numbers. This is a challenging task to accomplish, do you need any help out there ;-) ? Regards Gaetano Mendola

Re: [ADMIN] PostgreSQL Performance

, No. of CPUs, Hard discs capasity...?) What operating system shall I use? (I think about RedHat 8.x) I don't have 300 insert per day, but 300 update per day for the rest I have more then your numbers and in 3 years I had no one singol data loss or performance problem. regards Gaetano Mendola

Re: [ADMIN] ALTER table taking ages...

| ExclusiveLock | t | | NULL | NULL | 116230307 | 24758 | ExclusiveLock | t | +--+--+-+---+---+-+ (17 rows) May I know how you obtain this kind of output ( biq square around results ) ? Regards Gaetano Mendola

Re: [ADMIN] determining when a database was created

Somasekhar Bangalore wrote: Hi All, Is there a tool , where in i can convert data from postgres 7.3.2 to oracle 9i. http://www.oracle.com/support/index.html?contact.html thanks in advance som U'r welcome. Regards Gaeatano Mendola ---(end of broadcast

Re: [ADMIN] postmaster terminated abnormally..

[EMAIL PROTECTED] wrote: Hi, Under what circumstances would the postmaster receive signal 11 my postgres server crashed today and analysis of log yeilded sig 11 is SIGSEGV . Any idea on how it prevent it? Are you running your own functions written in C ? Regards Gaetano Mendola

Re: [ADMIN] Can't restore from pg_dump. Authentication failed

: [archiver (db)] connection to database ppr failed: FATAL: IDENT authentication failed for user postgres I don't know what is going on since I can login to ppr database like that (in shell) su - postgres psql -dppr try in this way: su - postgres psql -f baza.sql dppr Regards Gaetano Mendola

Re: [ADMIN] Table maintenance: order of operations important?

and the REINDEX are both utterly redundant. Without cluster with 7.4.2 a REINDEX is redundant after a VACUUM FULL ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[ADMIN] HEC Montreal use Postgres

Interesting article on May Linux Journal ( pag 44 ): [...] we installed Spamity, which parses mail logs from the four Postfix servers and update a Postgresql database running on the test server [...] Regards Gaetano Mendola ---(end of broadcast

Re: [ADMIN] Log msg

query), but not how execute (process) . Decrease the verbosity of your logs using: log_error_verbosity = terse Regards Gaetano Mendola ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[ADMIN] cast not IMMUTABLE?

) ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [ADMIN] Limiting user access to a view only

/docs/7.4/interactive/sql-grant.html ) in your case: GRANT SELECT ON view_name TO user_name Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] Postmaster hogs CPU

often that causes the problem. You can basically renice the process that is performing the query. See 'man nice' for details. Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] Postmaster hogs CPU

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tom Lane wrote: | Gaetano Mendola [EMAIL PROTECTED] writes: | |You can basically renice the process that is performing the query. | | | However, that's unlikely to do anything very pleasant, since you'll have | priority-inversion problems. nice has

[ADMIN] index not used for boolean

Hi all, is it normal that in a select like: select * from foo where expired; the index on expired is not used? If I rewrite that query: select * from foo where expired = true; then the index is used! I'm using postrgres 7.4.2 Regards Gaetano Mendola ---(end of broadcast

Re: [ADMIN] Real time replication of PG DBs accross two servers - any experiences?

to production levels still. We are using a SAN server, and 2 nodes running a Red Hat HA. Regards Gaetano Mendola ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

[ADMIN] CONTEXT: in log file

to remove the CONTEXT information on the log. May I remove the CONTEXT information ? Or at least have the same information on one line. Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

Re: [ADMIN] CONTEXT: in log file

Tom Lane wrote: Gaetano Mendola [EMAIL PROTECTED] writes: using Postgres 7.4.2 I'm seeing in my log file thousand of line with CONTEXT: Any particular context? No just mine own: LOG: statement: select sp_id_admin(); LOG: statement: SELECT id_admin FROM administrators WHERE user_name

[ADMIN] release note missing

Hi all, I want avice you that the interactive and as well the static documentation of postgres 7.4 is missing 7.4.1 and 7.3.5 release note. And the documentation of 7.3 is missing the release note 7.3.1 - 5 Regards Gaetano mendola ---(end of broadcast

Re: [ADMIN] commit after dead lock

at least rise a warning. regards Geetano Mendola ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

[ADMIN] commit after dead lock

40181; blocked by process 4144. kalman=# commit; COMMIT kalman=# Regards Gaetano Mendola ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] Error seen when vacuuming pg_largeobject table

in order to have te core file. May be is a good idea ship this file with the core file on ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 8: explain analyze is your friend

[ADMIN] Postgres 7.3.5

Hi all, I'm not finding the version 7.3.5 in any ftp mirror. I need to build the rpms someone did the SRPMS ? Example: ftp://ftp3.it.postgresql.org/postgresql/src no mention of 7.3.5 Regards Gaetano Menodla ---(end of broadcast)--- TIP 6: Have you

Re: [ADMIN] vacuum slowed by syslogd

disables syslog usage. This is very consistent and I can reproduce the problem in some installations by toggling these factors on and off. Did you try to put a - before the file log name ? Example: LOCAL0.* -/var/log/postgresql.log Regards Gaetano Mendola

Re: [ADMIN] what is the cause that scan type is showing as 'seq scan' after

cpu_tuple_cost = 0.005 cpu_index_tuple_cost = 0.0005 cpu_operator_cost = 0.0025 Regards Gaetano Mendola ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [ADMIN] Dropping a DB while it is in use?

access to the other 50 or so databases that are being used on the system. You can do a kill -INT to backend that are managing the connection. Regards Gaeatano Mendola ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send

Re: [ADMIN] what is the cause that scan type is showing as 'seq scan' after

commented are the default values. Are there any docs that talk specificially about how to set these params and what the defaults are (the official docs don't say much)? Take a look at performance NG, at least is what I use to do. Regards Gaetano Mendola ---(end

Re: [ADMIN] How can I set the cross database reference?

select using dblink but I don't think that you can enforce cross database reference. You can anyway use schemas. Regards Gaetano Mendola ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister

Re: [ADMIN] How can I set the cross database reference?

to install or some commands I need to do? You can do db cross select using dblink but I don't think that you can enforce cross database reference. You can anyway use schemas. Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (MingW32) Comment: Using GnuPG with Thunderbird

[ADMIN] Oracle - Postgres migration stories

Hi all, I must convince all the managment to convert all Oracle databases to postgres, do you have some stories like the red sheriff one: http://www.redsheriff.com/us/news/news_4_201.html Regards Gaetano Mendola ---(end of broadcast)--- TIP 5

Re: [ADMIN] Debugging PL/PGSQL

CLIFFORD ILKAY wrote: Hi, What do you use for debugging PL/PGSQL code? raise notice Regards Gaetano Mendola ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [ADMIN] vacuum full problem

you see the queries running. Also the command ps -eafwww | grep post show you the connection and his state, I bet you have some connection IDLE in TRANSACTION Regards Gaeatano Mendola ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [ADMIN] Upgrading to Solaris 9

Danielle Cossette wrote: Good morning, Could you please let me know if Postgres 7.1.3 will run on Solaris 9. If it does, are you aware of any issues. Seems that solaris is the worst choice for run Postgres. Am I completely wrong ? Regards Gaetano Mendola ---(end

Re: [ADMIN] Trying to pg_restore a 7.1.3 db into 7.3.4 - stalling at 100%

block of 4K from a NULL file descriptor ! Anyone any idea ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[ADMIN] cancel 3FB12A96.9090401@bigfoot.com

This message was cancelled from within Mozilla. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [ADMIN] pg_shadow dump annoying problem

Tom Lane wrote: Gaetano Mendola [EMAIL PROTECTED] writes: [ pg_dumpall emits this: ] DELETE FROM pg_shadow WHERE usesysid (SELECT datdba FROM pg_database WHERE datname = 'template0'); Now if the file pg_user.sql is used accidentally by a user that is not postgres the result is that all users

  1   2   3   >