Ubuntu Servers :: How To Clear Postgresql Database Cache

Jan 16, 2010

I just wanna clear database(postgresql) cache so how to do that..and also adempiere cache...

View 1 Replies


ADVERTISEMENT

Ubuntu Servers :: Using SSD As Cache For Database Operations

Mar 28, 2011

Had 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 Related

Ubuntu :: Add Database To PostgreSQL Daemon

Feb 24, 2011

While 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 Related

Ubuntu :: How To Clear OpenJDK Cache

Jul 23, 2010

I'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?

View 1 Replies View Related

Ubuntu Multimedia :: How To Clear Video Cache

Aug 22, 2010

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.

View 6 Replies View Related

Ubuntu :: How To Clear The System Cache Memory

Feb 15, 2011

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.

View 3 Replies View Related

General :: Sharing Postgresql Database

Oct 1, 2010

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?

View 1 Replies View Related

Security :: Securing My Postgresql Database ?

Jan 5, 2010

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.

View 12 Replies View Related

Server :: Cannot Create Database In PostgreSQL

Dec 26, 2010

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"

View 1 Replies View Related

Debian Configuration :: Clear DNS Cache ?

Jan 18, 2011

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.

View 8 Replies View Related

Fedora :: F12 - How To Clear ABRT Cache

Apr 12, 2010

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 Related

OpenSUSE :: How Clear Apache Cache ?

Sep 1, 2010

I'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

View 9 Replies View Related

OpenSUSE :: How To Clear Cache - Files Are Adding Up

Jun 23, 2010

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

View 5 Replies View Related

General :: Clear Bad Shortcuts From Gnome-do Cache?

Feb 11, 2010

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

View 3 Replies View Related

Hardware :: How To Clear Swap Usage (Cache)

Aug 21, 2010

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.

View 2 Replies View Related

Server :: Clear /var/cache/apt/archives On My Dedicated ?

Feb 4, 2010

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?

View 12 Replies View Related

General :: Shell Script To Back Up A Postgresql Database?

Jun 4, 2010

I need a shell script to back up and restore a postgresql database.

View 1 Replies View Related

Server :: Can't Insert A Record In A Table On Postgresql Database?

Sep 2, 2010

my 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 Related

Programming :: Right The Shell Script Which Talk To Postgresql Database?

Jul 22, 2010

i 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 Related

General :: Filesystems - Totally Clear The Filesytem's Cache?

Aug 4, 2011

In 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 Related

Debian :: Can't Clear Cache/install Packages In Musix 2.0?

Jan 10, 2010

My 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 Related

Server :: Squid Automatic/scheduled Cache Clear?

Nov 9, 2009

is there any way to scheduled cache clear auomatically instead of manual in squid.

View 1 Replies View Related

Ubuntu :: Synaptic Stops Responding When Trying To Clear Cache Of Deb Install Packages?

Nov 30, 2010

My synaptic stops responding when I try to clear cache of old deb install packages

View 3 Replies View Related

Fedora :: Yum Clear Cache And RPM Update - Internal System Error

Aug 3, 2009

I 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]

View 1 Replies View Related

Server :: Unable To Connect To Remote PostgreSQL Database With Java.derby

Aug 26, 2010

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]....

View 1 Replies View Related

Applications :: Overwrite File Contents And Clear Firefox Cache + All The Normal Functions Of A System Cleaner

Oct 22, 2010

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 Related

General :: PostgreSql Error "database Disk Image Is Malformed" After Db Dump

Dec 9, 2010

i 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 Related

Server :: Clear Cache Memory ( RHEL 5.1 ) As It Consumes Almost 100% Physical Memory?

Jan 11, 2010

let me know how to clear cache memory ( RHEL 5.1 ) as it consumes almost 100% physical memory.

View 3 Replies View Related

SUSE / Novell :: Clear Apache Cache Without Restarting Apache Server?

Feb 4, 2010

Any one have an idea How to clear apache cache without restarting apache server.

View 5 Replies View Related

Ubuntu Servers :: Postgresql-8.4 Won't Boot At Startup On 9.10?

Apr 1, 2010

I 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.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved