hello,
when i took the dump and tried to restore the dump in postgresql 7.3.4, the functions are not restored, so can anyone suggest me the solution of the above specified problem. The oids are restored but the functions are not restored?
Please help me.
Ntech
ntech
Last Activity: Mar 24 '08, 04:51 AM
Joined: Jul 27 '07
Location:
-
How to enable PITR on all POSTGRES server
Hello,
While Performing the Online Recovery By PITR, We had a Problem as we didnt Understand the proper Way of Enabling PITR on all POSTGRES Server .
again , when
psql -c "select pg_start_backup ('pgpool-recovery')" postgres
is executed, the following msg appeared.
=============== ====
WAL archive is not active
archive command must be defined before onlime backups can be... -
Address already in Use, postgres doesnot restart
hello,
i got a problem while restarting postgresql, i removed postmaste.pid and even the temporary sock file and while restarting postgres, i got the following error:
LOG: could not bind IPv6 socket: Address already in use
HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
LOG: could not bind IPv4 socket: Address already in use
HINT: Is another postmaster... -
Restoring the dump in a new database does not contain oids
Hello,
i am facing a problem. I am using postgresql database in Linux. After taking the dump of any postgresql database, when i restore the dump file into a new database, i dont get any oids. so can anyone help me in this issue? Does it happen due to version mismatch? how do i take the dump so that when i restore it, the oids are also available?
Thanks,
Ntech -
how to configure Pgpool-II to replicate postgres database in linux
Hello,
i have successfully installed Pgpool-II in linux but i need to know how to replicate databases using it. i dont understand the steps provided in different sites. so, can anyone help me to begin it from the beginning. what are the steps to be followed out to replicate postgres database using pgpool-II. its quite urgent.
Thanks,
ntech -
how to use two cacerts in java with tomcat server
hello,
i have a problem. i am using the tomcat server for java. my problem is that:
i want to use the same tomcat server with client authentication having two certificate authorities. i have been able to use with only one certificate authority.
now , i want to use two certificate authorities for two contexts of tomcat.
so, can anyone help me in this matter.
Thanks,
Ntech -
squid problem: after running it consume 99% of CPU
hello,
Before, i run the squid in my system, the CPU is almost idle but as soon a run the squid, the CPU consumes 99% of the system. so i don't understand the problem. i have even rotated the squid logs.
Can anyone help me in this matter?
Thanks,
NTECH -
Online replication of Postgresql databases
Hello everyone,
I am really in a great problem. I have been using dbmirror as the replication method for postgresql. But now the requirement is it has to be both way (i.e. from the primary server to the secodary and vice-versa). Dbmirror is one way and if we have to make it two way replication, we have to install in both the primary and secondary servers and its consumes much amount of memory.
I have even looked out with sloony... -
Configuring tomcat servers in a single linux operating is very easy. what u need to do is: u install the tomcat server 1 and server 2 as u did for installing the server 1, but while starting the server 1 and server 2, u should notice their ports.
By default, the port is 8080 so if u run server 1 at that port, for server 2 , u have to change the server port from server.xml (i.e. tomcat/conf/server.xml). u can change it to whatever u desire.... -
Real time backup of applications in Linux
hello,
I really need a help on the topic: Real time backup of applications in Linux.
The condition is that, there are two servers, server1 and server2, and we have to backup the changes made on server1 to the server 2 but it has to be on realtime.
Previously, i used Rsync but its doesnot happen on real time. Can anyone help me on this matter.
Thanks,
Sagar -
ntech started a topic current transaction is aborted. queries ignored until end of the transaction blockin PostgreSQLcurrent transaction is aborted. queries ignored until end of the transaction block
hi,
This is the error that we are getting on postgresql. The error is as follows:
current transaction is aborted. queries ignored until end of the transaction block.
What might be the real cause of the problem and how do we rectify it?
Any suggestions will be appreciable.
Thanks,
Sagar. -
Partitioning database in Postgres
Dear all,
I have some problems regarding postgresql. I have installed Postgresql server 7.2.4 and since the database size is growing day by day, I want to partition the database. I have gone under some documents but still get it. So, can anyone help me how to partition database in postgresql by example and which version it supports?
Thanks,
Sagar -
Too many clients already
When connecting to postgresql datbase server, it says to many clients already. So what is the solution of this problem? and how can we view the client connections.
Thanks,
Ntech
No activity results to display
Leave a comment: