Ubuntu Servers :: How To Clear Postgresql Database Cache
Jan 16, 2010I just wanna clear database(postgresql) cache so how to do that..and also adempiere cache...
View 1 RepliesI just wanna clear database(postgresql) cache so how to do that..and also adempiere cache...
View 1 RepliesHad anybody ever tried flashcache [URL] under ubuntu? My idea is to increase the throughput of a small server especially for database operations by using an SSD as cache.
View 3 Replies View RelatedWhile watching the text scroll by as I shut down I noticed that there is a PostgreSQL Daemon running somewhere. The question I have is, how do I add myself and my own database to this daemon or do I need to run one on my own user?
View 2 Replies View RelatedI've been advised to "clear the java cache", and to do so under Windows, one would open the java control panel. Of course, I'm using OpenJDK, and not Java's java.
Can anyone tell me how I would clear the java cache?
Ubuntu 10.4 64-bit.I am almost certainly using the wrong term here, but if I knew for sure what I was looking for I probably would have managed to google it.In a fit of minor insanity, I used ffmpeg to convert all my video files I've impulse downloaded over the last decade or so to mp4, mostly because Easytag will happily tag them an assist in reorganizing them, but of course some videos didn't convert, either properly or at all due to issues with the original file.
But - every 108 -123 (Going by the filecount in my trash when it happens; I've wondered if the actual number is 127 or 128 but haven't gotten that definitive yet.) videos or so, totem dies, and so does every other video player I can use, VLC, mplayer, et al. For awhile I rebooted, then I figured out just logging out/in cleared the error, but I've yet to narrow down what exactly is causing it.Since it crosses all players I can only assume that there is some kind of cache that is getting filled up that is cleared when you logout, but after doing some digging it's nothing cleared by anything I've found like bitbleach.
Ubuntu 10.10
How do I clear the System cache memory.
For the past few days , I am facing problem in opening websites (firefox & Chrome).
I have to restart the laptop and then access the web sites.
Am using mandriva 2008 i developed one simple application using cross platform = Qt3 Database = PostgreSQL
I want to share my database over peer to peer network.
server ip = 192.168.1.5
client ip = 192.168.1.6
Now how to share data over those ip?
I run Slackware 13.0 and I have an apache server 2.2.13 with a postgresql 8.4.1 database attached to it via php 5.3.0. Both the apache server and the postgresql database are on the same machine.
I have the apache server port 80 exposed to the WAN. It is not a fqdm, it's just a simple IP address. On my index page, a user can login with a user/password that encrypts to md5 via postgresql and takes them into the database.
Here is the vulnerability. Can't a hacker just scan port 80 and find my ip address running apache. Go to my index page, see that I accept user/password for authentication into my postgresql database. Then they could setup a script to simply inject html GET requests of random users and passwords and use those values on the php page(the one where the action link is pointing to in the form tag) that contains user login/password in php to login to my postgresql database. There's nothing stopping that. It would be a simple dictionary attack.
I checked out postgresql documentation and it suggested using ldap, kerberos, or md5 and not trust. I'm using md5 already. I currently use fail2ban for proftpd and sshd and it works great. After 6 failed user/pass attempts on either of these services, the IP gets banned via iptables for 24 hours. I love it. I was wondering if I could use that. Of course postgresql port is not exposed to the WAN which is a good thing. I know that when I put in a wrong user/pass from my index page, I get sent to a default postgresql pg_connect warning page. Perhaps I can increase the verbosity of postgresql's logger, find the phrase that it spits out when there's been a bad login and create a filter using that.
I understand that the way it is currently setup, my server is pretty secure, but where there's a will there's a way. I just feel that my postgresql database is unprotected even tho the postgresql port is not exposed to the WAN. They could just bruteforce from the apache server.
i installed Fedora 14 on my machine,then i installed postgresql in it i started it and configured it after seeing link [URL] i am able to do su - postgres but when i am trying to create database in it am getting error,It is asking for password then i am giving my root password
createdb company
Password:
createdb: could not connect to database postgres: FATAL: password authentication failed for user "postgres"
A friend has a website. the site has been moved to another server. I am inside of a private network.
Problem: when trying to reach his website, my browser keeps connecting to the old server which is on another continent
Windows machines have no problem with this. They connect to the new server without issues.
NOW what is hard to understand: even the PING utility is pinging the old server.
I tried these and none works:
- computer restart
- Clear private data in Iceweasel (has ntg to do with PING, but tried...)
- installed nscd and restarted the service
- modified /etc/resolv.conf to point to another nameserver than modified it back
At the same computer, if I reboot and load Windows, the browser has no problem connecting to the new server.
I can't find how to clear ABRT cache (other than to forcibly 'rm -rf /var/cache/abrt/'). How does one clear out the pile (which has grown to 1.2 GB here)?
View 3 Replies View RelatedI'm getting a weird situation where even though I updated an image in a folder for a website in apache, it's still showing the old image. And yes, I checked it in multiple browsers and on diff. computers. (Apache is in a virtualbox OS)
Here's what I've done:
1. Checked it in firefox on the host, cleared cache, reloaded
2. Restarted apache
3. Checked it in konqueror for first time, still showing old version
4. Checked it in the actual file folder and it's correct there
5. Checked it for first time on virtual machine's OS in its firefox, and it shows the wrong/old image
I just noticed that my hard drive is filling up with unnecessary files. what is the command to clean it up?
I've had to do this in Mandriva a while ago on my other pc. I'm running opensuse 11.2 KDE 64 bit
I am using ubuntu and gnome-do and have in my gnome-do some bad shortcuts ( they even have a grey X icon ) that i cant figure out how to delete from the list. I thought gnome do has some cache but its been a while and they are still there :(
how to clear them from the list ?
Update: I deleted the ~/local/share/gnome-do folder and still no success
How to reduce the cached swap from the server?
[root@CMS-UAT ~]# free -m
total used free shared buffers cached
Mem: 7985 4146 3839 0 3 2300
-/+ buffers/cache: 1842 6143
Swap: 12479 4721 7758
[root@CMS-UAT ~]#
My server is showing swap usage of 4.7 GB.
I have a dedicated server and I am having email issues etc (seemingly) because the /var directory is 97% full
I would like to know if it is safe to clear it and how to clear it (assuming it will not disrupt/kill server services to do so).
I have a 'Matrix' control panel so i can view the storage etc but it does not have an way of clearing the /Var directory.
I have Putty Access to root but do not know much about command line access.
I found a few threads but the information is not clear to me as there seems to be an assumption of (basic?) knowledge I don't yet have.
My linux support guru that usually does this kind of thing for me is away and not contactable and my server is grinding to a halt and unable to store/send email.
I have only a very basic understanding of command line but really need to get this sorted ASAP.
Is it possible and SAFE to delete files via FTP from the /var/cache/apt/archives?
I need a shell script to back up and restore a postgresql database.
View 1 Replies View Relatedmy database (PostgreSQL) has ever funtioned OK, but today don't let me insert a new row in a table and the record itsn't duplicated. I did a vacuum full and reindex the database and the problem continue. I don't know what the fuck is happening
View 2 Replies View Relatedi want to right the on linux box which have postgresql and i what some data from the different table and put it in .csv file.
View 2 Replies View RelatedIn a performance test, I want to bypass the influence of cache of linux system (including page cache/inode cache and so on). I have tried O_DIRECT flag, but it's turned out that direct I/O is still "enjoy" the effect of some cache.Is there a thorough way to close the effect of system cache?
View 2 Replies View RelatedMy cache is full, and I've tried doing "apt-get clean" to no avail. I also can't find any apt.conf file in my system.Here is a screenshot of the error message that pops up when I open Synaptic Package Manager:PS: I'm pretty new to Linux, especially Debian; most of my Unix-like OS experience is with Mac OS X. My Musix installation is in a VMWare machine.
View 1 Replies View Relatedis there any way to scheduled cache clear auomatically instead of manual in squid.
View 1 Replies View RelatedMy synaptic stops responding when I try to clear cache of old deb install packages
View 3 Replies View RelatedI just installed F9 and updated to F11 (fedora 11) and I updated the system because I couldn't get the media player working and then I installed all these packages for two days. I have tried yum clear cache and the rpm update. Here are some of the ones I tried:
rm -f /var/lib/rpm/__db*
yum update PackageKit
; yum clean all;
And this is the error:
Error Type: <type 'exceptions.TypeError'>
Error Value: 'NoneType' object is unsubscriptable
File : /usr/share/PackageKit/helpers/yum/yumBackend.py, line 2280, in <module>
main()
File : /usr/share/PackageKit/helpers/yum/yumBackend.py, line 2277, in main
backend.dispatcher(sys.argv[1:])
File : /usr/lib/python2.5/site-packages/packagekit/backend.py, line 600, in dispatcher
self.dispatch_command(args[0], args[1:])
File : /usr/lib/python2.5/site-packages/packagekit/backend.py, line 508, in dispatch_command self.get_updates(filters)
File : /usr/share/PackageKit/helpers/yum/yumBackend.py, line 1743, in get_updates self._check_init()
File : /usr/share/PackageKit/helpers/yum/yumBackend.py, line 1965, in _check_init self.yumbase.repos.doSetup()
File : /usr/lib/python2.5/site-packages/yum/repos.py, line 71, in doSetup self.ayum.plugins.run('postreposetup&apos
File : /usr/lib/python2.5/site-packages/yum/plugins.py, line 178, in run func(conduitcls(self, self.base, conf, **kwargs))
File : /usr/lib/yum-plugins/rpm-warm-cache.py, line 32, in postreposetup_hook
cmd = commands[0]
Trying to get OpenbavoPOS to connect to my remote Postgresql database, but so far i've only been able to connect to the local postgres installation. I _am_ able to access the remote databases with psql. I've read literally dozens of pages, and am pulling my hair out. I'm trying jdbc:derby.//192.168.15.10:5432/bravo I get back java.sql.SQLException no suitable driver found for jdbc:derby.//192.168.15.10:5432/bravo If I use jdbc:derby./root/bravo - all is OK, using a local database created in /root I have jdk installed on the client; does it need to be on the server also?
Server = CentOS 5.4 PostgreSQL version 8.1.21
Client = CentOS 4.8 PostgreSQL version 8.1.4
[code]....
since arch has started using python3, bleachbit is broken, so i am looking for a system cleaner to replace it. i need something that will overwrite file contents and clear firefox cache + the all the normal functions of a system cleaner.
View 8 Replies View Relatedi created a db_dump from PostgreSql-8.2 and trying to dump it into PostgreSql-8.4 new install. 2 of the 3 databases are fine, except for minor issues, but the 3rd database is giving me the following error message when i start a service calling on it, assist: "database disk image is malformed"
View 1 Replies View Relatedlet me know how to clear cache memory ( RHEL 5.1 ) as it consumes almost 100% physical memory.
View 3 Replies View RelatedAny one have an idea How to clear apache cache without restarting apache server.
View 5 Replies View RelatedI have just moved to rackspacecloud and created a Ubuntu 9.10 server. Moved everything over all fine (7-10 wordpress sites). Now I have a couple rails apps that need to move over and run on postgresql 8.4.
I installed postgresql via sudo apt-get as per usual. Usually at this point the postgresql server starts up and I can forget about it. But no luck. I booted it by running /etc/init.d/postgresql-8.4 start. When I run that command it boots fine, I can connect via psql no trouble.
I rebooted the machine to see what happened. After boot, apache and mysql started just fine, wp sites came up nicely no trouble. postgresql wouldn't start up.
I have tried installing from source, I have tried using different /etc/init.d/postgresql-8.4 scripts. I have no idea what to do.
I have downgraded to upstart to 0.6.3-10. I have apt-get updated, upgraded. I have Googled. I have pushed and pulled.
Usually with any linux issue in the past I have been able to find a solution on the net or work it out myself. This one stumps me to no end.
The other irritating part is that while I wait to work out this issue I am still paying for my old server running my Rails apps.