[ADMIN] psql and lo_import
Hi, is there any way to use lo_import() in psql? Thanx Ralf -- Fraunhofer IPK Automatisierung und Robotik Dipl.-Inf. Ralf Berger Pascalstr. 8-9 10587 Berlin Tel.: ++49-(0)30 390 06 129 Mobile: ++49-(0)175 52 50 118 Fax.: ++49-(0)30 391 10 37 Web : http://www.ar.ipk.fhg.de Web : http://www.e-industrial-services.de --- In anything at all, perfection is finally attained not when there is no longer anything to add, but when there is no longer anything to take away. Antoine de Saint Exupery ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[ADMIN] Operator *=
Hello I know that exists a script file in postgres (I think) that have all of these operators. But what is the name of the file ? Is it in the package of postgresql by defualt ? If not, can someone send me that file ? Thanks Luis Sousa ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[ADMIN] Is there other benchmark tool than pgbench or xpgbench.
Hi, I'm benchmarking PostgreSQL for performance tunning. But it seems that the pgbench and xpgbench are good benchmark tools but so simple. Where can I get other benchmark tools the pgbench or xpgbench. Thx. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[ADMIN] REFRENTIAL INTEGRITY CHECKING
Hi, How do we avoid referential integrity (FOREIGN KEY) checking till commit. My pgsql server is checking it as soon as I am issueing an INSERT command. Pls help. Thanks in advance. Sudheer http://www.monsterindia.com - The Best Jobs. For the Best Minds. ---(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] psql and lo_import
"berger, ralf" <[EMAIL PROTECTED]> writes: > is there any way to use lo_import() in psql? See \lo_import regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[ADMIN] Error Installing
Hi, I get this error when using the "make" command in cygwin. I know it's the GNU make command because I checked it using "make --version". Here is the error: gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations command.o common.o hel p.o input.o stringutils.o mainloop.o copy.o startup.o prompt.o variables.o large _obj.o print.o describe.o tab-complete.o -L../../../src/interfaces/libpq -lpq -L /usr/local/lib -g -lz -lcrypt -lreadline -lcygipc -o psql tab-complete.o(.text+0x2a36):tab-complete.c: undefined reference to `filename_co mpletion_function' collect2: ld returned 1 exit status make[3]: *** [psql] Error 1 make[3]: Leaving directory `/usr/local/bin/pgsql/src/bin/psql' make[2]: *** [all] Error 2 make[2]: Leaving directory `/usr/local/bin/pgsql/src/bin' make[1]: *** [all] Error 2 make[1]: Leaving directory `/usr/local/bin/pgsql/src' make: *** [all] Error 2 Any help would be appreciated. Thanks, Matt PS, I'm on Windows 2000 and the binaries didn't seem to work. If I'm doing something wrong, let me know how to do it right. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[ADMIN] Re: how to get all system views and connections
guard wrote: > > thanks > > -- what was the reply? can you please send it to newsgroup? kostis. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[ADMIN] Large objects
Hi friends, How to create large objects in pl/pgsql .There are example for 'libpq'. But I did not find any example for creating and using large objects with pl/pgsql. Thanks chava -- Srinivasa R Chava (Chava) <[EMAIL PROTECTED]> Application Developer Corporate Intra/Internet Systems WORLDCOM - http://www.worldcom.com/ - NASDAQ:WCOM 500 Clinton Center Drive (Corporate Headquarters) Clinton, Mississippi (MS) USA 39056 (601)460-3122 / vnet4603122 / (800)844-1009 / FAX(601)460-8257 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [ADMIN] REFRENTIAL INTEGRITY CHECKING
--- Sudheer Palaparambil <[EMAIL PROTECTED]> wrote: > Hi, > >How do we avoid referential integrity (FOREIGN > KEY) checking till commit. My pgsql server > is checking it as soon as I am issueing an INSERT > command. Pls help. When you define the constraint, set it as INITIALLY DEFERRED (or if you only sometimes want it to defer, set it as DEFERRABLE and use SET CONSTRAINTS to change the mode) However, there are some problems with the deferred ri right now if you modify the same key more than once in a transaction -- I'm hoping to get a chance to fix that for 7.2. For now, you have to be careful. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
AW: [ADMIN] psql and lo_import
Hi,
> -Ursprüngliche Nachricht-
> Von: Tom Lane [mailto:[EMAIL PROTECTED]]
> Gesendet: Montag, 16. Juli 2001 19:38
> An: berger, ralf
> Cc: [EMAIL PROTECTED]
> Betreff: Re: [ADMIN] psql and lo_import
>
>
> "berger, ralf" <[EMAIL PROTECTED]> writes:
> > is there any way to use lo_import() in psql?
>
> See \lo_import
>
Sorry this don't work for me!
Because if I type \lo_import() in an insert statement:
INSERT INTO test VALUES ( \lo_import('/home/torsten/bild1.gif') );
I got a list of database owners and the following output:
psql:lo_import.sql:1: \l: extra argument
'o_import('/home/torsten/bild1.gif')' ignored
psql:lo_import.sql:1: ERROR: parser: parse error at or near ")"
Any hint how to use this?
Thanx
Ralf
P.S.
My PostgreSQL is 7.0.3 on a Linux box, if this matter.
--
Fraunhofer IPK
Automatisierung und Robotik
Dipl.-Inf. Ralf Berger
Pascalstr. 8-9
10587 Berlin
Tel.: ++49-(0)30 390 06 129
Mobile: ++49-(0)175 52 50 118
Fax.: ++49-(0)30 391 10 37
Web : http://www.ar.ipk.fhg.de
Web : http://www.e-industrial-services.de
---
In anything at all, perfection is finally attained not when
there is no longer anything to add, but when there is
no longer anything to take away.
Antoine de Saint Exupery
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[ADMIN] Vacuum
Hi fellow Postgressers I have a relatively small database. The data itself is about 1.5GB. After I did some index value changes over the weekend, I decided that it's time to do a vacuum - the db had grown to 10 GB in size - which was just unrealistic. at 7:13 this otherwise fine morning, I started the vacuum and was hoping for a run time of maybe 2 hours - max. Well, it is 2:20 PM now and it's still ticking. It has created so far 1411 files in $PGDATA/pg_xlog (which, since last night resides on a different drive from the database). Each of the file is 16 MB in size and if this continues for another 3 hours (or so) I'm running out of disk space. If I would have done a dump all data drop db create new db restore schema (create tables/indexes/sequences) load all data I would have been done in about 2 hours. Can somebody explain to me what this vacuum is doing with all these files? I suppose, this transaction logging stuff needs some serious looking into/re-writing. Is there a way to switch this stuff off all together? Best regards, Chris
[ADMIN] connect failure from psql`
Hi, We are trying to connect the postgresql datbase from out webserver , using psql . In oracle , we use the syntax at sqlplus prompt like this sqlplus> username/password@hostname. How to do it in postgresql like this with psql utility. Thanks chava ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [ADMIN] REFRENTIAL INTEGRITY CHECKING
On 16 Jul 2001, Sudheer Palaparambil wrote: > Hi, > >How do we avoid referential integrity (FOREIGN KEY) checking till commit. My >pgsql server > is checking it as soon as I am issueing an INSERT command. Pls help. > >Thanks in advance. SET CONSTRAINTS TO DEFERRED This will do the job only if your fk was not defined as INITIALLY IMMEDIATE NOT DEFERRABLE cheers, thalis > > Sudheer > > > http://www.monsterindia.com - The Best Jobs. For the Best Minds. > > > > > ---(end of broadcast)--- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) > ---(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] REFRENTIAL INTEGRITY CHECKING
On Mon, 16 Jul 2001, Thalis A. Kalfigopoulos wrote: > On 16 Jul 2001, Sudheer Palaparambil wrote: > > > Hi, > > > >How do we avoid referential integrity (FOREIGN KEY) checking till commit. My >pgsql server > > is checking it as soon as I am issueing an INSERT command. Pls help. > > > >Thanks in advance. > > SET CONSTRAINTS TO DEFERRED Sorry, it's actually: SET CONSTRAINTS TO DEFERRED IF you don't want to give a specific constraint name, just give ALL. cheers, thalis > > This will do the job only if your fk was not defined as INITIALLY IMMEDIATE NOT >DEFERRABLE > > cheers, > thalis > > > > > Sudheer > > > > > > http://www.monsterindia.com - The Best Jobs. For the Best Minds. > > > > > > > > > > ---(end of broadcast)--- > > TIP 2: you can get off all lists at once with the unregister command > > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) > > > > > ---(end of broadcast)--- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) > ---(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
[ADMIN] how to connect remote database
Hai, How to connect the database from remote client ,using psql In oracle we use the command like the following one at sqlplus prompt. Sqlplus> username/password@hostname How to do it in postgresql I tried like this psql dabasename username@hostname It is not working. Can anybody has an idea? Thanks chava -- Srinivasa R Chava (Chava) <[EMAIL PROTECTED]> Application Developer Corporate Intra/Internet Systems WORLDCOM - http://www.worldcom.com/ - NASDAQ:WCOM 500 Clinton Center Drive (Corporate Headquarters) Clinton, Mississippi (MS) USA 39056 (601)460-3122 / vnet4603122 / (800)844-1009 / FAX(601)460-8257 ---(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] psql and lo_import
berger, ralf writes: > is there any way to use lo_import() in psql? \lo_import filename [comment] -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: AW: [ADMIN] psql and lo_import
"berger, ralf" <[EMAIL PROTECTED]> writes: > Any hint how to use this? Get a more recent release... regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [ADMIN] Error Installing
"Matt" <[EMAIL PROTECTED]> writes: > tab-complete.o(.text+0x2a36):tab-complete.c: undefined reference to > `filename_completion_function' Looks like a compatibility problem with libreadline. Which PG version is this, and which version of libreadline do you have? IIRC, libreadline 4.0 is not compatible with prior releases, and you need PG 7.1.2 to work with it. regards, tom lane ---(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] how to connect remote database
On Mon, 16 Jul 2001, Srinivasa R Chava wrote: > Hai, > How to connect the database from remote client ,using psql > In oracle we use the command like the following one at sqlplus > prompt. > Sqlplus> username/password@hostname > > How to do it in postgresql > I tried like this > psql dabasename username@hostname > > It is not working. Do psql --help for the options. There's a -h option. The server must be accepting network coonnections (postmaster must have been started with -i) cheers, thalis > > Can anybody has an idea? > Thanks > chava > -- > > Srinivasa R Chava (Chava) <[EMAIL PROTECTED]> > Application Developer > Corporate Intra/Internet Systems > WORLDCOM - http://www.worldcom.com/ - NASDAQ:WCOM > 500 Clinton Center Drive (Corporate Headquarters) > Clinton, Mississippi (MS) USA 39056 > (601)460-3122 / vnet4603122 / (800)844-1009 / FAX(601)460-8257 > > ---(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
Re: [ADMIN] how to connect remote database
Srinivasa R Chava writes: > psql dabasename username@hostname > > It is not working. psql --help man psql lynx /usr/local/pgsql/doc/html/index.html -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: AW: [ADMIN] psql and lo_import
berger, ralf writes:
> Because if I type \lo_import() in an insert statement:
>
> INSERT INTO test VALUES ( \lo_import('/home/torsten/bild1.gif') );
>
> I got a list of database owners and the following output:
>
> psql:lo_import.sql:1: \l: extra argument
> 'o_import('/home/torsten/bild1.gif')' ignored
> psql:lo_import.sql:1: ERROR: parser: parse error at or near ")"
\lo_import /home/torsten/bild1.gif
INSERT INTO test VALUES ( :LASTOID );
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
Re: [ADMIN] Vacuum
"Chris Ruprecht" <[EMAIL PROTECTED]> writes: > Can somebody explain to me what this vacuum is doing with all these > files? Just wasting space, I'm afraid. You may want to apply the patch at http://www.ca.postgresql.org/mhonarc/pgsql-patches/2001-06/msg00061.html However, if the database consists of several small tables and not one huge one, I'm not sure why VACUUM's WAL log might grow so long. The log should be truncatable after each table is vacuumed, even without the patch. regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [ADMIN] how to connect remote database
psql -h -U e.g. To connect to database customers on server gravy from server xxx : psql customers -h gravy -U mypassword -- rba hth Srinivasa R Chava wrote: > Hai, > How to connect the database from remote client ,using psql > In oracle we use the command like the following one at sqlplus > prompt. > Sqlplus> username/password@hostname > > How to do it in postgresql > I tried like this > psql dabasename username@hostname > > It is not working. > > Can anybody has an idea? > Thanks > chava > -- > > Srinivasa R Chava (Chava) <[EMAIL PROTECTED]> > Application Developer > Corporate Intra/Internet Systems > WORLDCOM - http://www.worldcom.com/ - NASDAQ:WCOM > 500 Clinton Center Drive (Corporate Headquarters) > Clinton, Mississippi (MS) USA 39056 > (601)460-3122 / vnet4603122 / (800)844-1009 / FAX(601)460-8257 > > ---(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 begin:vcard n:Abaya;Rommel x-mozilla-html:FALSE org:Ramcar Food Group;IT adr:;; version:2.1 email;internet:[EMAIL PROTECTED] title:IT Supervisor x-mozilla-cpt:;0 fn:Rommel Abaya end:vcard ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
