Re: [GENERAL] I am unable to install PostgreSql

2015-08-14 Thread Shashank
Hi Melvin Thanks for responding. I am using postgresql-9.4.4-3 version to install. However I am getting the same issue with postgresql-9.3.9-3 version as well. Kindly suggest, what needs to be done. Regards Shashank From

Re: [Pgbouncer-general] [GENERAL] Again, problem with pgbouncer

2012-10-05 Thread Shashank Tripathi
On Sat, Oct 6, 2012 at 10:07 AM, Adrian Klaver wrote: > On 10/05/2012 07:00 PM, Phoenix Kiula wrote: >> >> On Sat, Oct 6, 2012 at 12:01 AM, Wolf Schwurack wrote: >> >>> >>> You need to have a pgbouner directory in /var/log and have the owner >>> pgbouncer. This is easy to test try creating a

Re: [GENERAL] Help - corruption issue?

2011-04-25 Thread Shashank Tripathi
This process took me a day and a half but I now have files with copy dumps for last 11 years. On the fresh server, instead of 'copy from' with 11 files I cocatenated the files into one. Then in a transaction, I imported this file into the new database, which has: Begin Truncate table

[GENERAL] Error in starting Postgresql...

2008-11-05 Thread Shashank Mujumdar
After installing dspace when I tried to connect it to the postgresql server it gave the following error. psql -U postgres -h localhost ( command used ) the error was psql: could not connect to server: Connection refused (0X274D/10061) Is the server running on host "localhost" and

[GENERAL] Error in installation...

2008-11-02 Thread Shashank Mujumdar
Hi.. I've this problem in installation...I installed the postgresql-8.3 version without the service...Then to initialize I gave the command initdb -D path\ in the command prompt...It showed some notifications and it finally said to start the database server I needed to enter the command C:\Progra

Re: [GENERAL] How to know the password for the user 'postgres'

2008-10-27 Thread Shashank Sahni
..I am a newbie so I don't have much idea about it.. I would greatly appreciate your help... Thankyou.. Shashank Sahni..

Re: [GENERAL] How to know the password for the user 'postgres'

2008-10-27 Thread Shashank Sahni
createuser: could not connect to database postgres: FATAL: password > authentication failed for user "postgres" > > Odd I would have expected it to say something about identd > authentication failing. > > Have you tried: > > sudo su - postgres > createuser -d -A -P dpsace > > ? > Oh... I am so

[GENERAL] How to know the password for the user 'postgres'

2008-10-27 Thread Shashank Sahni
Hello people, I was trying to install dspace on my computer and it required postgresql as a prerequisite. Since I am using Ubuntu so i just downloaded and installed it using synaptic package manager. For the installation of dspace i was supposed to exeucte the following comman

Re: Checking for string data that makes sense Re: [GENERAL] postgresql vs mysql

2007-02-22 Thread Shashank Tripathi
I would do a CHECK (trim(a) <> '') TRIM() would add some processing time, so I'd include it only if there was a chance of spaces getting added. From a puritanical point of view, it is definitely a good idea. To the original poster, this syntax should work in MySQL as well: create table myt

Re: Checking for string data that makes sense Re: [GENERAL] postgresql vs mysql

2007-02-22 Thread Shashank Tripathi
On 22/02/07, Shashank Tripathi <[EMAIL PROTECTED]> wrote: > I would do a CHECK (trim(a) <> '') TRIM() would add some processing time, so I'd include it only if there was a chance of spaces getting added. From a puritanical point of view, it is definitely a good

Re: [GENERAL] More grist for the PostgreSQL vs MySQL mill

2007-01-21 Thread Shashank Tripathi
select something from othertable; select * from table where table_id in (?, ?, ?, ?, ?, ?, ?, ...) This is what MySQL's CEO Martin said in an interview on Slashdot. If we can manage two queries as above through, say, a PHP application, with each executing in 0.004 seconds, then an optimized sub

Re: [GENERAL] More grist for the PostgreSQL vs MySQL mill

2007-01-21 Thread Shashank
> It seems MySQL just dropped the ball on > the free version of their product, and it Not sure what you mean. I can download their latest versions without any trouble. > Additionally, they feel that Oracle is such a threat that they have dumped > BDB (I believe this move was after Oracle acquire

Re: [GENERAL] More grist for the PostgreSQL vs MySQL mill

2007-01-20 Thread Shashank Tripathi
It's a valid discussion here (although better on -advocacy), because it helps me have the right facts to present to clients about whether they should stay with a legacy database in MySQL vs upgrading to a modern PostgreSQL. For all its flaws, MySQL is catching on quick and has a very active com