Hi all,
I have a Postgresql 9.2 instance running on a CentOS6.3 box.Yesterday i
setup a hot standby by using pgbasebackup. Today i got the below alert
from standby box :
[1] (from line 412,723)
2013-04-24 23:07:18 UTC [13445]: [6-1] user= db= host= PANIC:
_bt_restore_page: cannot add item to pag
Issue the below command :-
select * from pg_stat_activity
& check the results.
Reinhard Asmus wrote:
I install a new database and want to check which connections will be
used.
How can i see which application from which host is connecting the
database?
Any help is appreciated.
--
S
Dear all,
Today by mistake I issued a drop table statement in Postgresql database.
Now is it possible to get that data back through WAL.
My PostgresPLus Version : 8.4
OS : Linux ( CentOs )
My postgresql.conf parameters are :
# WRITE AHEAD LOG
#---
ough backup.sql (21GB)file
May be there is chance because we work very rarely on that system.
Now i have the backup file bt I want that 3-4 tables.
Thanks
Vibhor Kumar wrote:
On Jul 25, 2011, at 12:08 PM, Adarsh Sharma wrote:
I restore globedatabase from a .sql file on yesterday morning.I
in the E:/data directory & Binary log is also enabled.
Please let me know if it is possible. It's urgent.
Thanks & Regards
Adarsh Sharma
Iñigo Martinez Lasala wrote:
Hi everybody.
We have a postgres 8.4.5-2 database under Debian Lenny 64bit.
This database has been working without any problem, but this afternoon
server has got out of space due to a log dump.
Log file gets full with this entry until it reaches several gigabyte
U can also start Postgres with skip-grant-tables option and thenafter
change the password
fore.g;
bin/psql -Upostgres --skip-grant-tables
Tim wrote:
Hi Rick,
Firstly there are likely to be an OS postgres user and a DB postgres user.
How you reset the OS user depends on if you are using windo
UAGE 'plpgsql';
ERROR: syntax error at or near "SOI"
LINE 4: ...ue,news_date from user_news where field_name in ('SOI','RelL...
^
Please help as I stuck with this issue.
Thanks & Regards
Adarsh Sharma
