Re: [ADMIN] Performance Question

2005-03-20 Thread Weiping
No, I mean JDBC version, not JDK version. go to jdbc.postgresql.org and download newest version of JDBC to have a try. regards laser ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining colum

Re: [ADMIN] Performance Question

2005-03-20 Thread weiping
what' your JDBC version? if it's pretty old, then upgrade to newest one is a bet. Don't know if it could solve the problem, but old version of JDBC did have some problem in transaction handling, we've experienced such problem not so long before. regards laser ---(end of broa

Re: [ADMIN] large dumps won't restore

2004-10-20 Thread Weiping
Christian Fowler wrote: db=# \encoding UNICODE the last four columns in the table are: full_name_nd | character varying(200) | mod_date | timestamp without time zone | pc_char | character varying(4)| dim_char | character varying(16) | [EMAIL PROTECTED] root]#

Re: [ADMIN] large dumps won't restore

2004-10-20 Thread Weiping
Christian Fowler wrote: I'm running a large database ( data dir is ~9gigs ) on Fedora Core 2 with 7.4.5-PGDG rpm's When using the -Fc dump method + pg_restore, I get: -bash-2.05b$ pg_restore -Fc -d foo -L backup.list /tmp/02\:43-postgresql_database-foo-backup pg_restore: ERROR: invalid input sy

Re: [ADMIN] postgresql port change

2004-10-15 Thread Weiping
Edgars wrote: Hello, an someone tell me where in freeradius config/source files i can change subj.? http://www.postgresql.org/docs/7.4/static/runtime-config.html#RUNTIME-CONFIG-CONNECTION see 'port' setting. ---(end of broadcast)--- TIP 9: the plann

Re: [ADMIN] checking currval

2003-06-18 Thread Weiping He
select last_value from your_sequence; Jodi Kanter wrote: I cannot view the currval because it is not set in the session yet. Is there a way to set it without having to increment the value? Thanks Jodi ---(end of broadcast)--- TIP 7: don't forge

Re: [ADMIN] problem with dumpall

2002-01-09 Thread Weiping He
> Hi ! > I have small problem > amount size all databases ~5Gb > I make dumpall >dumpfile > when size dumpfile = 1024 dumpall print error and exit ! > Linux Slackware7.2 ext2 2.4.17 gcc2.95 ^^^ I think ext2 can't support file larger then 2G, and your DB may be

Re: [ADMIN] psql error: file to large!

2001-07-27 Thread Weiping He
Roy Souther wrote: > This is a follow up to my previous post "Upgrade problems" > I compiled from source and have the same problem. > > -- My original post. -- > I have a large database. I had PG 7.0. I did the data dump and got a 2.5 GB > file.