I want to install two postgreql 8.3.5 instances on same servers. already one instalce is running on default port and i need it to be installed on another port.. How ever i achived installing the second instance.. but the problem is if i create a new user using createuser in the newly installed postgresql it creates in the old directroy
And if i give the full path of the newly installed postgres it gives the below error.. ( new postgres runs on socket 5434
Code:
netstat -an |grep -i 5434
127.0.0.1.5434 *.* 0 0 49152 0 LISTEN
ffffffff988ed588 stream-ord fffffe82cfb1ac40 0000000 /tmp/.s.PGSQL.5434
/me/apps/em/database/bin$ /me/apps/em/database/bin/createuser fish
Shall the new role be a superuser? (y/n) y
createuser: could not connect to database postgres: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
Any idea what am doing wrong?
Last edited by Scott; 11-27-2012 at 05:01 AM..
Reason: Please use code tags
Hi Scott, thanks for the fast reply.. it worked!!! can you als0 help me to create a database ( in new postgres installation)user and password for that db... I am very new to database.. thanks in advance..
I would recommend installing phpPgAdmin on one of the servers (assuming all the servers are on the same network) and using that to create your databases. It's very nice!
As for creating a database manually, there is no shortage of documentation out there. Just Google for it.
Hi
I have a small bash script which I want to run on an Amazon EC2 Ubuntu instance for setting up a postgreSQL database:
#!/bin/bash
USERNAME='postgres'
start=$SECONDS
TMP_DIR=/local/test/4g4d
PORT=23456
rm -rf $TMP_DIR/db
mkdir -p $TMP_DIR/
echo "creating database..."... (3 Replies)
I am managing a linux cluster which has been build on Platform Cluster Manager PCM 1.2.1) from IBM Platform Computing. Unfortunately somebody deteled data files of postgresql from /var/lib directory. I somehow managed to start the postmaster service again, but all the administrative commands of... (2 Replies)
Hi guys.
I was was designing a simple database in postgresql. I wrote a perl function in postgresql and execute it. suddenly i saw that it is running in an infinite loop. After i stopped executing of the query, i saw that CPU is in 90%+ load. I looked at process list and there it was. postgresql... (1 Reply)
Hi guys.
I have some questions about SQL functions in postgresql:
1. Can a SQL function call another SQL function?
2. How about recursive calls?
3. Consider we have function that has a varchar argument.
CREATE FUNCTION func(varchar) RETURN void AS $$
some SQL queries.
... (0 Replies)
Hi,
I am writing a Java Swing application and want to add Embedded SQL to it. The application should interact with a PostgreSQL database running on my local machine. The compiler complains that it cannot find the org.postgresql package included in the code. I'm guessing the problem is that... (0 Replies)
11-27-2012
