[ADMIN] where is my bottleneck?

Hello everybody. I'm trying to build a postgres server to act as the repository for a bunch of data-crunching clients. Hardware-wise, the machine is a dual p3 700 with 768MB of RAM and 3 striped 10k RPM u160 drives sitting on a DPT SmartRAID V. Software-wise, I've installed linux 2.4.18 and postg

Re: [ADMIN] [GENERAL] where is my bottleneck?

just one client attached; attaching more than one client makes the number jump up to the 3/sec mark. On Sat, 2 Mar 2002, Helge Bahmann wrote: > On Sat, 2 Mar 2002, Ben wrote: > > I've checked all the sql commands I use, and all the lookups and updates > > are using indi

[ADMIN] pg_ident.conf file?

Hi, I can't seem to find the pg_ident.conf file or the format for such file. Could you e-mail me a format for the pg_ident.conf file or where can I find an example of this file on the net? Thanks Ben Hoang Nortern Telecom [EMAIL PROTECTED]

[ADMIN] pg_ident.conf file?

Hi, I can't seem to find the pg_ident.conf file or the format for such file. Could you e-mail me a format for the pg_ident.conf file or where can I find an example of this file on the internet? Thanks Ben Hoang Nortern Telecom [EMAIL PROTECTED]

RE: [ADMIN] Automation/scheduling of Backup stratetgy

Title: RE: [ADMIN] Automation/scheduling of Backup stratetgy It is already built in.  Use pg_dump or pg_dumpall when online. Only problem is OIDs and large objects.  pg_dump -o to keep OIDs not sure about large objects. Hope this is what you mean by live/hot backup. Ben > -Origi

[ADMIN] Getting postgres to echo queries.

echo queries seems to be passed through correctly. Any help with this matter will be very much appreciated. Regards, Ben -- ======== | Ben Warren |

RE: [ADMIN] Foriegn key constraint

to do is drop these triggers and then sort out your table before setting up your foreign key constraint. Hope this helps Ben -Original Message- From: Sivagami . [mailto:[EMAIL PROTECTED]] Sent: 05 December 2000 22:04 To: [EMAIL PROTECTED] Subject: [ADMIN] Foriegn key constraint Hi

RE: [ADMIN] date_part bug?

Title: RE: [ADMIN] date_part bug? Are you using Mandrake 7.x.  It seems to have some problems with rounding and dates because of its use of certain compiler settings.  If you are, try using the Postgres 7.0.3 RPMs from one of the ftp mirrors.  They seem to work correctly. Regards Ben

Re: [ADMIN] restore database from bare files

d over from the previous line. My 2 pence... Regards, Ben Kim Developer College of Education Texas A&M University ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [ADMIN] restore database from bare files

>psql: FATAL: IDENT authentication failed for user "ezpublish" This might help, or you may want to check or post your pg_hba.conf. http://archives.postgresql.org/pgsql-sql/2004-03/msg00202.php (or http://www.postgresql.org/docs/7.4/interactive/auth-methods.html#AUTH-IDENT)

[ADMIN] Changing

I just wondered if there is a way to change the variable sign from : to $, like \set avar 32 select :avar ; ---> select $avar ; so I can copy and paste my perl code directly to psql when debugging, assuming I do a proper \set. TIA. Ben Kim Developer College of Education Texas A&M Uni

Re: [ADMIN] SQL Server 2000 to PostgreSQL 8.0.3

mismatches in data types, but you can convert data using scripts inisde the DTS task on the fly. Regards, Ben Kim Developer College of Education Texas A&M University ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [ADMIN] SQL Server 2000 to PostgreSQL 8.0.3

, > "StatusID" int4, > "TrackingNumber" varchar(50), > ponumber varchar(50), <--HERE > "Comment" char(254), > "sfOrderNumber" varchar(50), > "UpdateDate" timestamptz >) >WITH OIDS; >ALTER TABLE "Orders&q

Re: [ADMIN] SQL Help - Obtaining ID of record INSERTED

, but this works and sometimes this way is convenient for batch processing. >SELECT @@identity as orderid My 0.02$. Regards, Ben Kim Developer College of Education Texas A&M University ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[ADMIN] Backup / Restore help

by pg_dump, leaving the rest of the database intact? Thanks, -Ben Mitchell ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message

[ADMIN] pg_hba.conf setup

appear in pg_hba.conf. Any assistance will be most appreciated. --- local  all  all ident   sameuser host all all 127.0.0.1 255.255.255.255 md5 host 255.255.255.255 trust --- Thanks, -- Ben Sullins Enterprise Reporting Team  

Re: [ADMIN] full data disk -- any chance of recovery

of broadcast)--- >TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > Regards, Ben Kim Developer http://benix.tamu.edu ---(e

Re: [ADMIN] strange hung processes

revent this >from happening again. If it's not sensitive information, what does this show? lsof | grep 'pid of hung process' Regards, Ben Kim Developer http://benix.tamu.edu ---(end of broadcast)--- TIP 3: Have

[ADMIN] encoding question

020 02e2130: 2020 2020 2020 2020 2020 2020 2020 2020 02e2140: 2020 2020 2020 2020 2020 2020 2020 2020 02e2150: 2020 2020 2020 2020 2020 2020 2020 2020 02e2160: 2020 2020 2020 2020 2020 2020 2020 2020 02e2170: 2020 2020 2020 2009 4b6e 6f77 6c65 6467 .Knowledg Where could this be coming from? W

Re: [ADMIN] encoding question

) http://archives.postgresql.org/pgsql-general/2004-02/msg01192.php dump database, recode the dump, drop database, restore from recoded dump Especially, any experience with recode vs. manual inspection ? I'm just reasoning from pieces of information. I'd appreciate any ad

Re: [ADMIN] encoding question

a row, and if the crc matches, would it be reasonably sufficient? Is there a stronger validation method? Thanks. Ben K. Developer http://benix.tamu.edu ---(end of broadcast)--- TIP 4: Have you searched our list archives?

[ADMIN] log connections to database

table | {postgres=arwdRxt/postgres,ddd=arwdRxt/postgres} drop group ddd; ERROR: role "ddd" cannot be dropped because some objects depend on it DETAIL: access to table atable I couldn't see this from 8.0. Regards, Ben K. Developer http://benix.tamu.edu

Re: [ADMIN] log connections to database

Yup, this is intended and new in 8.1. You need to REVOKE the privileges before being able to drop the role. Thanks. Ben K. Developer http://benix.tamu.edu ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [ADMIN] New system recommendations

es in database related performance. http://ourworld.compuserve.com/homepages/Ken_North/ODBCPERF.HTM Thought odbc performance might be also a thing to consider but this article seemed to attest otherwise. Hence the question. Regards, Ben K. ---(end of broa

Re: [ADMIN] Is there an efficient way to check whether a particular

Are there equivalent ways to check for indeces and constraints? pg_constraint and pg_indexes? Regards, Ben ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining

Re: [ADMIN] How to list all the privileges a user has?

') ~ 'givenuser/'; Thought there was a thread a short while ago, but couldn't find it. String functions can be used to manipulate the acl string. If it's changed to ~'/givenuser' you will get the list of privs the user gave to others.

Re: FW: [ADMIN] reset all sequences

Select setval('mytable_id_seq',1); So when I insert a new row the value will be "2" and not "1" as it should be Select setval('mytable_id_seq',1,false); http://www.postgresql.org/docs/8.1/interactive/functions-sequence.html HTH.

Re: [ADMIN] lock a database from new connections, without modifying

a database) ... Just in case ... update pg_catalog.pg_database set datallowconn = false where datname = '...'; http://archives.postgresql.org/pgsql-docs/2004-11/msg00015.php http://www.postgresql.org/docs/8.1/interactive/manage-ag-templatedbs.html My twopence. Ben K. Developer h

Re: [ADMIN] find out all users under specific user

relname, array_to_string(relacl,',') as acl from pg_class where array_to_string(relacl,',') ~ '/ABC[,$]'; HTH Ben K. Developer http://benix.tamu.edu ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [ADMIN] biginteger to timestamp

actally i have UNIX time and that is in *1153222974* format. and i m using select to_timestamp(1153222974); http://www.postgresql.org/docs/8.1/static/functions-formatting.html if you're on 8.1. HTH. Ben K. Developer http://benix.tamu.edu ---(end of broa

Re: [ADMIN] two databases in one

ase A and so on, to avoid conflict two ID 11 records having different data? - Does the order of records matter? Once the problem is familiar, many gurus will be able to help. I just wanted to provide a starter. Regards, Ben K. Developer http://benix.tamu.edu

Re: [ADMIN] TCP/IP connection problem

t will not actually have done anything. Regards Ben ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [ADMIN] TCP/IP connection problem

know what (if any) errors are reported. Regards Ben ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [ADMIN] TCP/IP connection problem

l machine locally using tcp :- > psql -h = same.host.as.configured.from.windows.box -p = 5432 db user Then we can see if the problem still lies with pgsql, or with the firewall. BEn ---(end of broadcast)--- TIP 4: Have you searched our l

Re: [ADMIN] 100% failover + replication solution

the solution you were looking at, have you seen PGCluser :- http://pgcluster.projects.postgresql.org/index.html I have not tried it, but was looking the other week at various fail- over type solutions and came across it. It seems to be able to do what you want. Ben

[ADMIN] running initdb on running database

Admins, I'm reading this post: http://archives.postgresql.org/pgsql-novice/2005-04/msg00221.php Is it possible and safe to run initdb again on a running database to change encoding from SQL_ASCII to UTF8? Will it affect new databases only or existing databases as well? Thanks.

Re: [ADMIN] running initdb on running database

On Tue, 14 Nov 2006, Jim C. Nasby wrote: On Mon, Nov 13, 2006 at 03:10:14PM -0600, Ben K. wrote: Admins, I'm reading this post: http://archives.postgresql.org/pgsql-novice/2005-04/msg00221.php Is it possible and safe to run initdb again on a running database to change encoding from SQL_ASC

Re: [ADMIN] How to enforce the use of the sequence for serial columns

id field from being arbitrarily manipulated outside the sequence.. There may be an equivalent way using alter table, but on a first look, currval cannot be used to check existing values. Regards Ben K. Developer http://benix.tamu.edu ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [ADMIN] How to enforce the use of the sequence for serial columns

t;disable" option when adding check constraint by alter table, but the context seem a bit different from ours so may not be useful in our case, at any rate.) Regards Ben K. Developer http://benix.tamu.edu ---(end of broadcast)-

Re: [ADMIN] How to enforce the use of the sequence for serial columns

It's not a full solution anyway since it prevents any kind of update on the table due to check constraints firing even if target field not updated. See below; Right. It was not a valid idea ... Regards, Ben K. Developer http://benix.tamu.edu ---(end of broa

[ADMIN] question re double quotes

lot of keystrokes. (Also perhaps some errors related with using Access as frontend...) Even if we use mixed-case names, it's primarily for descriptive names, and we don't use same-letters-different-case names. Regards, Ben ---(end of broadcast)--

[ADMIN] question re crosstab query

Is there a plan to implement crosstab query feature? Are there ways other than using some frontend tool, COPY or pg_dump? Thanks, Ben ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org

Re: [ADMIN] question re double quotes

Thanks. Regards, Ben On Mon, 20 Oct 2003, Tom Lane wrote: > Ben Kim <[EMAIL PROTECTED]> writes: > > Thanks for the reply. I haven't looked at the source code yet, but > > assuming I understood it correctly, if we can simply add double quotes > > around tab-co

Re: [ADMIN] question re crosstab query

Thanks for the information. Regards, Ben On Thu, 16 Oct 2003, Adam Witney wrote: > > I think the tablefunc module in contrib will do crosstab queries > > HTH > > adam > > > > > Is there a plan to implement crosstab query feature? Are there ways > &

Re: [ADMIN] question re double quotes

Thanks for the reply. I haven't looked at the source code yet, but assuming I understood it correctly, if we can simply add double quotes around tab-completed names, it alone would be very convenient. Regards, Ben On Thu, 16 Oct 2003, Tom Lane wrote: > Bruno Wolff III <[EMAI

Re: [ADMIN] per-database logging

Thanks. Is there a disadvantage of running separate postmaster compared to running one postmaster with multiple databases? Regards, Ben On Sat, 6 Mar 2004, Tom Lane wrote: > bkim <[EMAIL PROTECTED]> writes: > > Is it possible to use a dedicated log file for each database? >

[ADMIN] Can I make PostgreSql namespace case-insensitive?

ytable, MyTable will all work.) I would appreciate any advice. Regards, Ben ---(end of broadcast)--- TIP 8: explain analyze is your friend

[ADMIN] tweaking scan.l

u are interested. http://www.interakt.ro/products/bbs/view_0_9873.html Thanks, Ben Kim ---(end of broadcast)--- TIP 8: explain analyze is your friend

[ADMIN] sequence value of the record just inserted.

. I would appreciate an advice. Regards, Ben Kim ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] sequence value of the record just inserted.

e perl DBI, so am not sure how I can get the oid into a perl variable. I appreciate the help. Regards, Ben Kim ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[ADMIN] sequence value of the record just inserted / DBI

It's supposed to be metadata, and CREATE USER has CATALOG|NOCATALOG option, but what would be $catalog value for a user table in this context? Thanks in advance. Ben Kim ---(end of broadcast)--- TIP 3: if posting/reading through U

[ADMIN] parametrized query

rl $sth = $dbh -> prepare ("insert into mytable values (?, ?, ?)") Is writing a function the only way? Is there another way that can be done without writing a function? Thanks, Ben Kim ---(end of broadcast)--- TIP 6: Have yo

[ADMIN] force connection timeout

each page, but somehow this problem persists. I'd appreciate any advice. Thanks, Ben Kim ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[ADMIN] analytics

so, what tools (ETL, ad-hoc reporting, etc.) work well with Postgresql? Is there any plans or projects for Postgresql in this application? Thanks. Regards, Ben Kim Database Developer/Systems Administrator College of Education Texas A&M University

Re: [ADMIN] analytics

Thanks to all who replied. I guess I realize odbc may work for most of the products as long as the analytics tool works with RDBMS. We'll be explore the Mondrian option as well. Regards, Ben Kim Database Developer/Systems Administrator College of Education Texas A&M University O

Re: [ADMIN] NIC to NIC connection

etter than that of the external link. But the former is significantly better during a busy day. (But then, the database sessions are more likely to be interactive type of traffic...) You also get security as a side benefit. (Data can't be snooped.) Regards, Ben Kim Database Develop

[ADMIN] Question: drop database problem

etc.) dropdb gives the same result. ERROR: Postmaster environment variable 'PGDATA3' not set dropdb: database removal failed Thanks in advance. Ben Kim Database Developer/Systems Administrator College of Education Texas A&M University ---

Re: [ADMIN] Question: drop database problem

PGDATA3 is not being used for new databases. I guess I need to refine the startup script if for the rest of the databases. Will I have to shut down the server and restart it (introduce PGDATA3 properly) before I can drop that particular database? Regards, Ben Kim Database Developer/Systems Admini

Re: [ADMIN] Question: drop database problem

only after all of the backends terminate normally. This is Smart Shutdown. Thanks again, you are great. Ben Kim Database Developer/Systems

[ADMIN] request for feature - mixed case name handling

' preference, it would be really great. If anyone in this list is facing a similar problem, I would like to ask for opinions on this list. Although I spoke of inconveniences, let me say I deeply appreciate the efforts of the developers. Thanks. Ben Kim Database Developer/Systems Administr

[ADMIN] relation tmp_pg_shadow already exists

ow (datdba) from '$$PATH$$/75.dat' ; I found 2 questions regarding this problem from my google search, both of them unanswered, but hope there's a way to circumvent this error, and would appreciate any help. Regards, Ben Kim Database Developer/Systems Administrator 434E Harrington

Re: [ADMIN] relation tmp_pg_shadow already exists

uestion is, is it possible with pg_dump to create a dump including users/groups, when not using pg_dumpall? Regards, Ben Kim Database Developer/Systems Administrator 434E Harrington Tower / College of Education Texas A&M University ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[ADMIN] Database audit / Associating a statement with connection

port=35644 where 128.91.23.43 is my web server. The web server log records all client connections and accessed pages, but I don't have a good method of associating the web client connections with the database client connections. I'd appreciate any pointers. Regards, Ben Kim Databa

Re: [ADMIN] Database audit / Associating a statement with connection

> > Is there a way to associate them so I know which statement came from which > > connection? > > Log the PID originating each message. Thanks. Ben Kim Database Developer/Systems Administrator 434E Harrington Tower / College of Education Texas A&M University -

Re: [ADMIN] Visual data model creation / maintenance tools

but I know there are many, many of ERD tools. Regards, Ben Kim Database Developer/Systems Administrator 434E Harrington Tower / College of Education Texas A&M University ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [ADMIN] Database audit / Associating a statement with connection

>Ben Kim <[EMAIL PROTECTED]> writes: >> Is there a way to associate them so I know which statement came from which >> connection? > Log the PID originating each message. > regards, tom lane This is a follow up in addition to the log pid. It&#

Re: [ADMIN] Dump and Query (fwd)

l $database > dumpfile < query.txt or 2. Same, on the fly psql $database > dumpfile <<_eof_ select field1,field2 from table _eof_ Regards, Ben K. Developer http://benix.tamu.edu ---(end of broadcast)--- TIP 4: Have you

[ADMIN] PITR recovery

s it possible to use the PITR method with SQL dump? (pg_start_backup -> sql dump -> pg_stop_backup) I guess not, but just want to make sure. Thanks. Ben K. Developer http://benix.tamu.edu ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [ADMIN] PITR recovery

On Fri, 2007-01-05 at 12:59 -0600, Ben K. wrote: 2. sql dump and PITR Is it possible to use the PITR method with SQL dump? (pg_start_backup -> sql dump -> pg_stop_backup) I guess not, but just want to make sure. No, because there is no reason or benefit. Thanks. I guess the PITR play

Re: [ADMIN] PITR recovery

on the platform, but also on the configure options used for the build. Thanks. Ben K. Developer http://benix.tamu.edu ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your

Re: [ADMIN] PITR recovery

ems like scalability and speed. Thanks. Ben K. Developer http://benix.tamu.edu ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [ADMIN] PITR recovery

ld your breath while waiting for that. It was not that it's essential. Thanks for sharing the insight. Regards, Ben K. Developer http://benix.tamu.edu ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [ADMIN] Postgres encyrption export

be fairly assured that they have heard of PostgreSQL, but how that affects what you are distributing I'm not sure. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [ADMIN] Fastest DB restore options

If you are just looking for the least down time between stopping one server and starting the new one you could try Slony see http://gborg.postgresql.org/project/slony1/projdisplay.php Regards, Ben <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello, > > I have

Re: [ADMIN] Issue while installing RPM's

rpm -e postgresql-libs-7.4.8* error: Failed dependencies: libpq.so is needed by (installed) postgresql-server-7.4.17-1PGDG.i686 rpm -e --nodeps post... Regards, Ben K. Developer http://benix.tamu.edu ---(end of broadcast)--- TIP 5: don&#

Re: [ADMIN] replicating postgresql database to ms-sql database

er. Massaging can be done by custom conversion scripts, in perl or vb, within the task definition. My 2 cents. Regards, Ben K. Developer http://benix.tamu.edu ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send

Re: [ADMIN] "_" in a serach pattern

nce on this subject other than the source code? Thanks. Ben K. Developer http://benix.tamu.edu ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [ADMIN] merge two rows where value are null

ll) This will fail if you also have John, Smith, student, NULL, dog, NULL in addition to John, Smith, student, NULL, cat, NULL You can test for offending rows by: select array_to_string( array( select distinct Pet from thetable where Name = 'name1' and Surname = '

Re: [ADMIN] adding a user with the permission to create trimmed users

arate from superuser. But it seemed if a user is given createrole, even though he's not given the superuser, s/he can drop other users (who s/he didn't create.) So alter user...createuser may not fit here. Please correct me if I'm wrong. HTH Ben K. Develop

Re: [ADMIN] adding a user with the permission to create trimmed users

If you're on 8.1 and upwards, createrole is not separate from superuser. But Sorry, please read "createrole is not separate" as "createrole is NOW separate". I also wanted to add that a good testing is needed. Regards, Ben K. Developer http://benix.tamu.edu --

Re: [ADMIN] HELP, can't implement e filter

;;7 3)133664;2;"0039";"00121";12 4)133665;2;"0039";"00121";12 6)135460;2;"0039";"01152"; 8)135471;2;"0050";"00153";4 There should be something better but this might work. select * from testtable where (c1,c2) in (select c1, max(c2) from testtable group by c1 ); HTH Ben K. Developer http://benix.tamu.edu ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [ADMIN] How to monitor resources on Linux.

. (Running legacy software inside a legacy guest OS) My experience was with vmware and I think it will do the job but then I haven't used others yet. http://www-128.ibm.com/developerworks/library/l-linuxvirt/index.html#resources My 2pence Ben K. Developer http://benix.tam

Re: [ADMIN] How to monitor resources on Linux.

en host and guest. (http://pubs.vmware.com/vmci-sdk/VMCI_intro.html) Just thought it might be worth exploring. HTH. Regards, Ben K. Developer http://benix.tamu.edu ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donatin

[ADMIN] Restoring Backup With OIDs As Primary Key

Hello, I am trying to restore from a backup db that used oids as primary keys * ... when I do this the max oid value in the new database is around the 1700 mark where as the database I am pulling in is around 20,000,000 . which means any new data added to the dataabse is going to be clobbered.

Re: [ADMIN] privileges

Could it be the search path (schema) issue? Just a quick thought... Regards, Ben Kim On Thu, 28 Aug 2008, Carol Walter wrote: Hello, I asked this question yesterday, but perhaps I did so in an unintelligible way. I didn't get any answer that time. Someone usually answers my ques

Re: [ADMIN] Database Conversion

k mysql has anything that exports data into postgresql. Unless he is talking about the likes of DTS/SSIS or perl DBI, or other tools. Or the tables are simple and he thinks he can ingeniously craft queries and run them through pipes eventually to psql. DDL will be more difficult. Regards, Ben

Re: [ADMIN] Default data directory

x=... will likely be where the "data" sits? Regards, Ben Kim -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] problem with pg_stat_activity view

fe80::104d:416e:a8dc:c02e %12 Since %12 is a "space" character, it seems first thing to do might be an extra space in your code. Just a quick guess. Regards, Ben Kim On Mon, 8 Sep 2008, Sofer, Yuval wrote: Hello, postgres version: 8.2.0.4 platform windows: server 2008

Re: [ADMIN] problem with pg_stat_activity view

Sorry, I apologize for the mistake. %20 is the space, and the extra %12 seems to be DC3 (device control 3). Regards, Ben Kim On Mon, 8 Sep 2008, Ben Kim wrote: fe80::104d:416e:a8dc:c02e %12 Since %12 is a "space" character, it seems first thing to do might be an extra spa

Re: [ADMIN] problem with pg_stat_activity view

That explains it... I thought it was a precent encoding but at the same time a strange place for a control character. Regards, Ben Kim On Mon, 8 Sep 2008, Alvaro Herrera wrote: ERROR: invalid input syntax for type inet: "fe80::104d:416e:a8dc:c02e%12" SQL state: 22P02 I

Re: [ADMIN] [GENERAL] FW: How to upload data to postgres

for export), assuming the table is already created in postgresql. You just need to find the right node names. HTH Ben -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Change in logging behaviour between 8.1 and 8.2

one One problem I noticed is that if the statement has a carriage return in it, the script will only show up to the point of the carriage return, not really a massive issue for me, but worth noting also. Ben Webber. Tom Lane wrote: Alexander Stanier <[EMAIL PROTECTED]> writes: We h

Re: [ADMIN] Change in logging behaviour between 8.1 and 8.2

feasible however to write a script to import the archived logfile into a new temporary database on a different server, then use SQL to search it and delete the db when finished. Thanks for the suggestion though. Ben. Alvaro Herrera wrote: Ben Webber wrote: Hi, I wrote a shell script to find the

Re: [ADMIN] Change in logging behaviour between 8.1 and 8.2

Arrrghhh, it was was actually 10 (not that it really makes any difference), should have actually waited for file to unzip before posting!!! Ben Webber wrote: Sorry, meant 2 gigs, not 10. An interesting suggestion, but the problem with storing the logfiles in a table for us would be that

Re: [ADMIN] Change in logging behaviour between 8.1 and 8.2

script to import the archived logfile into a new temporary database on a different server, then use SQL to search it and delete the db when finished. Thanks for the suggestion though. Ben. Alvaro Herrera wrote: Ben Webber wrote: Hi, I wrote a shell script to find the duration and the related

[ADMIN] postgresql 8.4

I'm planning to upgrade. Is there a updated release schedule for 8.4? Thanks. Ben Kim -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] postgresql 8.4

l.org/index.php/PostgreSQL_8.4_Development_Plan http://www.postgresonline.com/journal/index.php?/archives/56-PostgreSQL-8.4-goodies-in-store.html Both are about a year old articles and point to 3/1/2009 release. Regards, Ben Kim On Thu, 2 Apr 2009, Tom Lane wrote: Ben Kim writes: I'm planning to

[ADMIN] linux standard layout

BI may not be a good example.) In general I didn't have any problems yet with standard rpms and I can make the rpms work if there's a problem, but I may be missing something. Any advice or reference to a relevant article on this issue will be appreciated. Thanks. Ben Kim -- Sen

Re: [ADMIN] linux standard layout

Thanks all. I cannot change the decision on vmware or layout, but it's great to know that the rpm way is a valid one. I appreciate all inputs. Regards, Ben Kim On Mon, 8 Mar 2010, Scott Marlowe wrote: On Mon, Mar 8, 2010 at 10:31 PM, Ben Kim wrote: Dear list, I have abo

[ADMIN] compare two rows

write a generic script to iterate through the list of fields and compare each field values, or concatenate the fields to a string, but wondered what is out there. Also, is there a way around to use select row(...) = row(...)? Thanks. -- Ben Kim -- Sent via pgsql-admin mailing list (pgsql-admin

  1   2   >