Hi
I am new to postgresql. I have postgresql 9.2 installed on Red hat linux 6.4
I accidentally deleted data directory this morning
(/var/lib/postgresql/9.2/data)
I tried to start posgresql 9.2 service
service postgresql9.2 start
I got a amessage to initialize the db first.
so I ran service
See if there are processes running for user postgres that look
like database processes and kill them.
Then try again.
What exactly is the error message?
Yours,
Laurenz Albe
Hi
ps –edf shows no postgres processes:
-bash-4.1$ ps -edf | grep postgres
root 6412 6249 0 18:22
'
log_truncate_on_rotation=on
log_rotation_age = 1d
log_rotation_size = 0
I installed postges from an rpm file (pgdg-redhat92-9.2-7.noarch.rpm) using yum
install.
Thanks,
thara.
From: Albe Laurenz laurenz.a...@wien.gv.at
To: Thara Vadakkeveedu thar
: Thara Vadakkeveedu thar...@yahoo.com
To: Albe Laurenz laurenz.a...@wien.gv.at; pgsql-admin@postgresql.org
pgsql-admin@postgresql.org
Sent: Tuesday, September 24, 2013 9:47 AM
Subject: Re: [ADMIN] accidentally deleted data directory
Here are the settings in the postgresql.conf file:
I remember
Thank you!
I deleted data directory again and then ran initdb.
This time service started successfully.
TG
From: Albe Laurenz laurenz.a...@wien.gv.at
To: Thara Vadakkeveedu thar...@yahoo.com; pgsql-admin@postgresql.org
pgsql-admin@postgresql.org
Sent
Hi
I am trying to connect to the database on a linux server from pgadmin on my
windows desktop.
I see Error connecting to the server: Fatal: password authentication failed
for user postgres
I specified my linux server name for the host
port : 5432
Maintenance DB : postgres
username:postgres
the pgadmin client.
Thanks
TG
From: Thara Vadakkeveedu thar...@yahoo.com
To: Albe Laurenz laurenz.a...@wien.gv.at; pgsql-admin@postgresql.org
pgsql-admin@postgresql.org
Sent: Tuesday, September 24, 2013 8:37 PM
Subject: connecting to the database from pgadmin client
Hi
I wanted to take a backup of my database.
pg_dump throws a server mismatch version error
# cd backups
# su - postgres
-bash-4.1$ pg_dump mydb mydbfile
pg_dump: server version: 9.2.4; pg_dump version: 8.4.13
pg_dump: aborting because of server version mismatch
This is a fresh install of
minor version than the server
U must have same version to do the backup, so U need upgrade your
client (pg_dump 8.4.13) to at least 9.2.4
See U
El 25/09/2013 15:55, Thara Vadakkeveedu escribió:
Hi
I wanted to take a backup of my database.
pg_dump throws a server mismatch version error
Hi,
I found pg_dump under /usr/pgsql-9.2/bin/ and /usr/bin, but both of them show
version as 8.4.13.
# su - postgres
-bash-4.1$ cd /usr/pgsql-9.2/bin
-bash-4.1$ pg_dump --version
pg_dump (PostgreSQL) 8.4.13
-bash-4.1$ cd /usr/bin
-bash-4.1$ pg_dump --version
pg_dump (PostgreSQL) 8.4.13
How can
for the older version?
Thanks!
Thara.
From: Craig James cja...@emolecules.com
To: Thara Vadakkeveedu thar...@yahoo.com
Sent: Wednesday, September 25, 2013 5:32 PM
Subject: Re: [ADMIN] pd_dump server mismatch error
On Wed, Sep 25, 2013 at 2:15 PM, Thara
Hi
I have postgresql 9.2 installed on red hat linux 6.4 . I need to generate uuids
using the uuid_generate_v4() function.
select * from pg_available_extensions does not list this extension. The only
extension that is available is plpgsql.
I find uuid libraries, libuuid.so.1 and
: libossp-uuid.so.16()(64bit)
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
Where can I get this library from ?
Thanks.
From: Thara Vadakkeveedu thar...@yahoo.com
To: pgsql-admin@postgresql.org
13 matches
Mail list logo