[ADMIN] Drop Schema from Postgres

2012-01-05 Thread Tripura
Hi, I am trying to execute a few postgres commands from a bash file I am trying to drop a schema by writing the following line DROP SCHEMA "xxx" IF EXISTS I have two issues here - 1> I am not sure how to specify the db from which the schema should be deleted 2> I am getting the following error

Re: [ADMIN] unix domain sockets on Windows.

2012-01-05 Thread Jeff Rule
Peter Thanks for the definitive yes/no answer on the windows platform issue. What was confusing was that the online manual does make references to the listen_addresses having a relationship to unix-domain sockets. 9.1 (18.3. Connections and Authentication) listen_addresses

Re: [ADMIN] system is swapping (not actively), why?

2012-01-05 Thread MirrorX
thx a lot for your advice. it's true that even under load, i havent seen any so or si...so probably it's best to let the OS handle the situation. in the meantime if anyone has any idea why the OS would do such a thing, pls share it with us. thx -- View this message in context: http://postgre

Re: [ADMIN] system is swapping (not actively), why?

2012-01-05 Thread Scott Marlowe
On Thu, Jan 5, 2012 at 7:27 AM, MirrorX wrote: > thx a lot for your advice. it's true that even under load, i havent seen any > so or si...so probably it's best to let the OS handle the situation. > > in the meantime if anyone has any idea why the OS would do such a thing, pls > share it with us.

Re: [ADMIN] Drop Schema from Postgres

2012-01-05 Thread Kevin Grittner
Tripura wrote: > I am trying to drop a schema by writing the following line > > DROP SCHEMA "xxx" IF EXISTS The syntax requires: DROP SCHEMA IF EXISTS "xxx"; > I have two issues here - > 1> I am not sure how to specify the db from which the schema > should be deleted You connect to a

Re: [ADMIN] Drop Schema from Postgres

2012-01-05 Thread Walter Hurry
On Thu, 05 Jan 2012 10:22:59 -0600, Kevin Grittner wrote: > Tripura wrote: > >> I am trying to drop a schema by writing the following line >> >> DROP SCHEMA "xxx" IF EXISTS > > The syntax requires: >DROP SCHEMA IF EXISTS "xxx"; > >> I have two issues here - >> 1> I am not sure how to s

[ADMIN] Postgres 9.1 client authentication for local, no password required?

2012-01-05 Thread Wujek Srujek
Hi. I am using Postgres 9.1 on Ubuntu 11.10 64bit. I have a question about client authentication. After installing the server, and setting the postgres password to encrypted 'postgres', I made sure I can log in like that. Then, I edited the /etc/postgres/9.1/main/pg_hba.conf file to contain just th

Re: [ADMIN] Postgres 9.1 client authentication for local, no password required?

2012-01-05 Thread Guillaume Lelarge
On Thu, 2012-01-05 at 20:56 +0100, Wujek Srujek wrote: > Hi. I am using Postgres 9.1 on Ubuntu 11.10 64bit. I have a question about > client authentication. > After installing the server, and setting the postgres password to encrypted > 'postgres', I made sure I can log in like that. Then, I edited

Re: [ADMIN] Postgres 9.1 client authentication for local, no password required?

2012-01-05 Thread Wujek Srujek
Hi. Yes, there is such a file, and yes, it is the 'special' thing I was looking for. Thanks you very much for the tip, I did some reading about it. Who created this feature for me? Could it be the ubuntu installation process? wujek On Thu, Jan 5, 2012 at 9:51 PM, Guillaume Lelarge wrote: > On Th

Re: [ADMIN] Postgres 9.1 client authentication for local, no password required?

2012-01-05 Thread Guillaume Lelarge
On Thu, 2012-01-05 at 22:00 +0100, Wujek Srujek wrote: > Hi. Yes, there is such a file, and yes, it is the 'special' thing I was > looking for. Thanks you very much for the tip, I did some reading about it. > Who created this feature for me? Could it be the ubuntu installation > process? > No, I

Re: [ADMIN] Postgres 9.1 client authentication for local, no password required?

2012-01-05 Thread Wujek Srujek
Yes, pgAdmin is pretty much the only thing I use after initially installing and setting the password for the 'postgres' user. When does it do it? How did I trigger that? wujek On Thu, Jan 5, 2012 at 10:18 PM, Guillaume Lelarge wrote: > On Thu, 2012-01-05 at 22:00 +0100, Wujek Srujek wrote: > > H

Re: [ADMIN] Postgres 9.1 client authentication for local, no password required?

2012-01-05 Thread Wujek Srujek
Ok, I got it - it adds a new entry when I create a new server connection, set it to remember the password, and log in succesfully. It creates the file for the first time it wants to add an entry, if the file is not there yet. Thank you for the good tip in the right direction. wujek On Thu, Jan 5

Re: [ADMIN] Postgres 9.1 client authentication for local, no password required?

2012-01-05 Thread Guillaume Lelarge
On Thu, 2012-01-05 at 22:23 +0100, Wujek Srujek wrote: > Yes, pgAdmin is pretty much the only thing I use after initially installing > and setting the password for the 'postgres' user. > When does it do it? How did I trigger that? > It does that when you tell it to record your password (checkbox

[ADMIN] Reg: Insert bytea values in to table

2012-01-05 Thread Hariraman Jayaraj
Hi, Postgres Version - 8.3 OS - Suse Linux 11 Enterprise Edition I have a requirement to store pdf files in db. I am suggested to use bytea data type to achieve this. I am having an table *ledger* with columns * id bigint, pdffile bytea *I want to store the pdf files in the pdffile column. Kin