[ADMIN] postgresql array with perl
Hi ! Hope this is the right list to ask. How do i access (including select /add/delete etc... ) a postgresql array from perl? getting it as a text and spliting is not very convinient. Thanks ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[ADMIN] How to Download Postgresql for Windows
Hi' I am asking very simple question, Now I want to using Postgresql for windows. How should i downlod that one. Please help me. bye sudheer Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs ---(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
[ADMIN] ssl with pem password
hi.I'm trying to use postgresql in mode ssl and I would to use a private key that uses a pem password. When I launch postgres with postgres user and my server.key and server.crt in my home ,in this mode: echo password | /usr/bin/postmaster -il -p '5432' -D '/home/data' I see this message: Enter PEM pass phrase but I would a thing more automatic without that password request. Is it possible? ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [ADMIN] ssl with pem password
"Luca Stancapiano" <[EMAIL PROTECTED]> writes: > hi.I'm trying to use postgresql in mode ssl and I would to use a > private key that uses a pem password. When I launch postgres with > postgres user and my server.key and server.crt in my home ,in this mode: > echo password | /usr/bin/postmaster -il -p '5432' -D '/home/data' > I see this message: > Enter PEM pass phrase > but I would a thing more automatic without that password request. Is it > possible? If you want the server to launch without a password, you have to alter the server key file to remove its password. See the documentation. The above is hardly a more-secure approach, since anyone who can look at the script (or happen to see the "echo" executing in ps) can find out the password. You might as well rely on file permissions to prevent people from getting at the password-less key file. regards, tom lane ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [ADMIN] How to Download Postgresql for Windows
http://www.postgresql.org/ftp/binary/v8.0.3/win32/ There you will find the win32 thing. Regards, Guido On 7/25/05, gudipudi sudheer <[EMAIL PROTECTED]> wrote: Hi'I am asking very simple question, Now I want to usingPostgresql for windows. How should i downlod that one. Please help me.byesudheerStart your day with Yahoo! - make it your home pagehttp://www.yahoo.com/r/hs ---(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-- "Adopting the position that you are smarter than an automaticoptimization algorithm is generally a good way to achieve lessperformance, not more" - Tom Lane.
Re: [ADMIN] ssl with pem password
> "Luca Stancapiano" <[EMAIL PROTECTED]> writes: >> hi.I'm trying to use postgresql in mode ssl and I would to use a >> private key that uses a pem password. When I launch postgres with >> postgres user and my server.key and server.crt in my home ,in this mode: > >> echo password | /usr/bin/postmaster -il -p '5432' -D '/home/data' > >> I see this message: > >> Enter PEM pass phrase > >> but I would a thing more automatic without that password request. Is it >> possible? > > If you want the server to launch without a password, you have to alter > the server key file to remove its password. See the documentation. > > The above is hardly a more-secure approach, since anyone who can look at > the script (or happen to see the "echo" executing in ps) can find out > the password. You might as well rely on file permissions to prevent > people from getting at the password-less key file. > > regards, tom lane > > ---(end of broadcast)--- > TIP 5: don't forget to increase your free space map settings > sorry but I would really to use the key with password because I use a gpg system that hide the real passwordIt's possible with postgres to use a thing like this? echo crypted_password | /usr/bin/postmaster -il -p '5432' -D '/home/data' ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [ADMIN] Server side development
Hi I had just posted a query about adding a new data type to postgres. This is a follow-up on that. I checked the include directtory under my source but did not find postgres.h and fmgr.h. These are needed for the input and output functions. Anybody have any ideas. Thank you Moginraj ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[ADMIN] server side extension
Hi I was trying to built a new base data type into postgres. i am using 7.4.8 on debian. There is already an eg in src/tutorial which gives code for intenal and external functions of a new type called complex. I tried to create a shared library for the file complex.c using "cc -fpic -c complex.c" and "cc -shared -o complex.so complex.c". That gave me a lot of errors like the header files "fmgr.h" and "postgres.h" did not exist. I did a "make" anyway. After that I went into postgres and tried to create the functions corresponding to the new type. It says the file complex.so could not be found. So the shared library seems to have not been created. When I installed postgres-7.4.8 there was some error when I gave "make install-all-headers", so I just did "make install". I think the header files required for server side development are not there due to that. I think they are still there in the include dir. How do I use those header files when I make a shared library and compile. If anybody has created datatypes and defined them please share your experience. Thank you Moginraj ---(end of broadcast)--- TIP 6: explain analyze is your friend
[ADMIN] Size of Large objects
Hello, I'm new in postgres. I searched the archives, but I don't find an answer. So can anybody tell me the explicit size, which a clob or a blob can have in postgres 8.0? Thank you, Bianca -- 5 GB Mailbox, 50 FreeSMS http://www.gmx.net/de/go/promail +++ GMX - die erste Adresse f�r Mail, Message, More +++ ---(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
