General :: Centos Search For Postgres Database?
Jan 31, 2011Ok so I need to Search for a postgres database File on a CentOs System. Is their a command i can run in the terminal to search for postgres files?
View 2 Replies
ADVERTISEMENT
Server :: Restoring A Postgres Database?
Jun 9, 2010We have a disaster recovery solution for our database where a dump file is generated daily at 1:00 AM. We have tested importing the file, along with running another sql file that generates the appropriate database user accounts, into a database on a third-party server.
One question that came up was the following: Suppose the database crashes in the middle of the day, prior to that there were transactions that were entered into the database between the time the dump file was generated, and the crash occurred. We can restore the dump file to either the main or backup server. How can the transactions that were made between the time of the dump file and the crash be restored as well?
Server :: Upgrading Bacula Database For Postgres?
Mar 24, 2011While backing up/restoring bacula clients. We were getting an error regarding database tables' version. The error message is given below.. "Found 10 needs 12".
After Googling, what we found is, we have to update the postgres database for bacula. So now we are in process to update the database via the update_bacula-tables script. We are not sure, if it will solve the problem or not. We have just upgraded bacula 2.4.4 to 5.0.1. Postgres version is upgraded from 8.3 to 8.4. It is Debian 6.0 squeeze.
Server :: A Database Based Search Command?
Jun 10, 2010I was not in touch with linux for couple of years now. So I forgot a command I used to use. I recently installed Fedora 12 and I can not remember what was that command.Here is what it used to do: I remember that I used to run a special search command on server that used to find a file very fast because it was kind a database based command. To enable it for first time after linux installation, I used to build an index of computer's files and then I could use its command [don't remember if it was "find" or "search"].
So my question if anybody know what I am talking about and what is name of these two commands. How can I build the index first.
CentOS 5 Server :: Login As Postgres User And Enter Commands?
Sep 10, 2010I've had a server setup working perfectly for the last 2 years. Today we installed a newer version of postgresql and recompiled apache/php.
Postgresql will not start now.
"service postgresql start" = /var/lib/pgsql/data is missing. Use "service postgresql initdb" to initialize the cluster first. To initdb we need to be as user postgres.
"su - postgres" = "no file or directory"
In /etc/passwd = postgres:x:26:26:PostgreSQL Server:/var/lib/pgsql:/bin/bash
how i can login as postgres user and enter these commands?
Fedora :: Yum Search / Info - Database Disk Image Malformed
Aug 25, 2010Any time I've tried to run 'yum search' or 'yum info' I end up getting a error "database disk image is malformed"
Code:
$ yum info postgresql
Loaded plugins: presto, refresh-packagekit
Error: database disk image is malformed
I am, however, able to update and install software without this error occuring.
I've tried the 'yum clean all", "yum clean metadata", "yum clean datacache", and rebuilding with "yum makecache", but still this problem crops up. As I understand it, the error message comes from something possibly not having been updated properly in one of the sqlite databases that yum stores information in. I probably could fix it if I knew which sqlite db that 'yum search' and 'yum info' hit.
Fedora :: Reliable Search Engine For Searching Particular Content On The Files In The Storage Database?
Feb 15, 2010I'm looking for a simple and reliable search engine for searching particular content on the files in the storage database. The output will display files' name and their path. Google search found following site:- "List of search engines";[URL]..There are many of them. I have no idea how to make my selection. Could you please shed me some light. Furthermore can a simple shell command do the same job?
View 4 Replies View RelatedGeneral :: User Postgres Does Not Exist?
Jul 21, 2010i have installed postgresql to my fedora10-distribution. when i would to access to this database by using the command #su postgres as is mentioned at [URL]..3/install/wiff/createcontext to install freedom , an error message is shown to tell me that user postgres does not exist. what is the likely problem.
View 15 Replies View RelatedGeneral :: Add Additional Search Domains To The Resolv.conf Created By Dhclient In CentOS?
Feb 19, 2010When my CentOS virtual machine boots it uses DHCP to get an IP address. It also overwrites resolv.conf with the DNS settings provided by the DHCP server. The DHCP server doesn't supply any search domains so I would like to get dhclient to put in a list of search domains when it writes it. How can I configure dhclient to do this?
View 3 Replies View RelatedGeneral :: Monitor Database IO And Available Database Threads?
Mar 7, 2011am using zabbix open source solution for systems monitoring. I am facing a problem and discussed it on zabbix forum. my post was as "My zabbix server is behaving abnormally, approximately daily from 9 to 12, the server stop accumulating logs. I observed that the server report is RUNNING but it did not accumulate log values and also the machine have no extra load. Its shown in the graph image attached.t the following reply,"database performance?are you monitoring database IO and available database threads? "So any one have any idea that how can I do this as I am using MySQL as backend database on RHEL 3.
View 1 Replies View RelatedCentOS 5 :: Force Centos To Search For Software Updates Immediately?
Feb 6, 2011In general CentOS search automatically after startup for available software updates.Then after some (~20-30) minutes an icon appears in the toolbar which the user can click and install the updates.How can I manually speed up/trigger IMMEDIATELY the search for updates (without waiting for the built-in search)?
View 3 Replies View RelatedGeneral :: Application Running As User Foo Log Onto Database As (database) User Foobar?
Jan 5, 2011I am writing a simple application that will run as user foo (i.e. Ubuntu user foo).However, the application will connect to my database as (database user foobar). IIRC, database users have nothing to do with Linux system users - but I just need to clarify that.So can an app launched to run as user 'foo', connect to a database as user 'foobar'?
View 1 Replies View RelatedCentOS 5 :: User Database Cannot Be Read?
Mar 21, 2009This situation after a mains power failure took server down.Log oonto server with root, go to Admin > users and get this message:" The user database cannot be read. This problem is most likely caused by mismatch between /etx/password and /etc/shadow or /etc/group and /etc/gshadow. The program will exit now."
View 2 Replies View RelatedCentOS 5 Networking :: Set Up Nat IP Between Webserver And Database?
May 25, 2009I am looking for advice on a what I am sure is a very basic procedure but I have never had to set this up before and am not sure where to start.
I am running 2 CentOS5.3 boxes. I have one webserver connected to the internet and behind a firewall. I would like to set up the 2nd server (database) behind the webserver and completely inaccessible from the internet. Ideally so it can only be accessed by first ssh'ing onto the webserver and then ssh'ing from there onto the database. The webserver connecting locally to database.
From what I have seen it looks like I need to set this up using NAT but I have never done this and do not know what is involved. Can someone point me in the right direction and optimally outline the steps I need to take to hook this up? Do I need to worry about any specific hardware configuration as well?
CentOS 5 :: What Needs To Be Installed For A Working Webserver/database
Aug 9, 2009I have a dedicated server running Centos 5.2. I have a Wordpress MU site that's setup over apache 2, mysql 5, php5, and I use phpmyadmin as well. I'm able to read the database as my website appears perfectly fine, however, I can not write to it. What exactly do I need to install on my Centos sever to allow my site to interface with the database? I've used shared servers and VPS's with no problems but this just won't work. The support team seems clueless and I'm ready to ask them to reinstall my entire OS and everything else again.
View 2 Replies View RelatedCentOS 5 :: Can't Get A Backup Database Script To Work
Oct 21, 2009I am trying to get a script to run, that will backup all my databases. The script is called automysqlbackup.sh (chmod 744), I have filled in the blanks and placed this into /etc/cron.daily I have checked that crond is running. Nothing happens, the databases are not backed up. I am at a loss, can anyone tell me what i am doing wrong. The script is shown below:
[Code]...
CentOS 5 :: Create A Server For A Database That Has A .db File
Jan 25, 2010I need to create a server for a database that has a .db file that is over 800Gb. now my first disk is 50Gb and i do the standard
100m ext2 boot
2000m swap
* / ext3
now I have a second 1.2T that i want to be /opt is there a way to set up 4kib block size in ext3 in the os install? or should I do it after the install? Is this block size even big enough?
CentOS 5 :: Remotely Accessing Mysql Database?
Mar 10, 2011I have an application running on a centOS machine that needs to access a database on a CentOS server. I granted access to all users with a certain user name and password.i opened up port 3306 as well with the following command: /sbin/iptables -A INPUT -i eth0 -p tcp --destination-port 3306 -j ACCEPTbut whenever i try to connect from my machine i get an error:ERROR 2003 (HY000): Can't connect to MySQL server on '172.16.102.129' (113)I am using mysql version 5.0.77 on centOS 5.5.
View 1 Replies View RelatedSoftware :: Search In CENTOS That GNU Is Installed?
Jan 28, 2011How to search in CENTOS that GNU is installed?
View 3 Replies View RelatedCentOS 5 Server :: Can't Move The MYSQL Database Files
Nov 8, 2009I just installed mysql and need to move the databases to a new location.I say 'no problem' I shutdown mysql (service mysqld stop) I configure my.cnf to point to the new location, which in my case is: /mnt/data/mysql. I know not very original naming. I do the old chown -R mysql:mysql /mnt/datal/mysql AND I copy all the files over (cp -R /var/lib/mysql /mnt/cgsvol/mysql) chmod 777 /mnt/data/mysql I ensure the chown worked (ls -a -l) and the files are there from the old directory. I can't load the daemon again. I check the log (/var/log/mysqld.log) and it can't write any test file to that directory.
(log file exact data).
091107 23:22:21 mysqld started
091107 23:22:22 [Warning] option 'max_join_size': unsigned value 18446744073709$
091107 23:22:22 [Warning] option 'max_join_size': unsigned value 18446744073709$
[code]....
CentOS 5 :: Installing Atlassian JIRA And Configure Database Con
Aug 10, 2010I would like to install this software on linux server for purpose of system reporting. I have all the installation software and the system's specification is based on system need.
View 1 Replies View RelatedSoftware :: Desktop Search Tool For CentOS 5.6?
Jun 12, 2011I am looking for a tool to index the files on my PC to allow full text search. I use recoll on Ubuntu and it does a great job. As I described in a previous post there does not seem to be an rpm package available for recoll on CentOS and I have not been able to build from source.So I tried beagle. In a nutshell the old version of beagle available for CentOS 5.6 does not do a good job of indexing pdf files. The newest version, tried on Linux Mint, does not do much better. And the beagle web site seems to be gone so I am not sure if it is an active product.
I have done some searching and most of what I find appear to be tools for indexing a web server. That is a bit of an overkill for my needs. I simply want to be able to search old email archives, OpenOffice documents, text and pdf files stored and accessed locally on the PC?
CentOS 5 :: Phpmyadmin Unable To Create A New User In Mysql Database
May 13, 2010I have installed on a remote server phpmyadmin 3.3.1 and mysql 5.1.46 on a centos 5.4 OS.
Any newly created user with phamyadmin is unable to login both from mysql command line (from localhost) and phpmyadmin (localhost and remotely).
No prob when the user is created with mysql command line (from localhost). All of the users created with phpmyadmin, are not "visible" recognized from the show user command via the mysql command line. The setting I used when I create any user was the same as the ones with the mysql command line creation.
The error message I get when accessing from mysql command line (from localhost) is the following: "Access denied for user ... @localhost (using password: yes)"
CentOS 5 Networking :: DHCP: Option Domain-search (119) Not Supported?
Oct 14, 2009I have an issue with the DHCP clients in a lab environment I am building. The lab is in a dns subdomain but the clients should be able to resolve any machine in the lab subdomain or the parent by using just the hostname. According to everything I have read, the client resolver should do this automagically, trying first the naked hostname, then the FQDN, then walking up the tree of parent domains. But it doesn't.
So I thought I'd just have the dhcp server set the domain search list to include both the local and parent domain. But adding "option domain-search" to dhcpd.conf causes dhcpd to fail on start up. Does the current version of dhcpd in CentOS 5.3 really not support this option?
CentOS 5 :: Find Search Initiated At Boot That Takes Several Hours
Dec 18, 2009I noticed that every, say, 5 times I boot CentOS 5.4, a find search is initiated that takes several hours.
For example:
find . -name rd=rmdir -print
I'm not sure if it's related, but, I do have a "alias rd=rmdir" in my .aliases. Would changing it to "alias rd=/bin/rmdir" avoid this problem? I'm using zsh. Is this search necessary?
OpenSUSE :: Postgres Does Not Start After Upgrade To 11.2?
Feb 10, 2010I had postgresql 8.3 running on opensuse 11.0, recently upgraded to 11.2 (so postgres is now 8.4) and have problems starting it. I make, su, then as root run:
# /etc/init.d/postgresql start
Your databases are still using the format of PostgreSQL 8.3.
Therefore a backup of the old PostgreSQL server program will be used
until you have saved and removed your old database files
See also /usr/share/doc/packages/postgresql/README.SuSE.{de,en} .
Starting PostgreSQLsu: incorrect password
[Code]...
Ubuntu :: What Is The Default Postgres Password?
Jun 23, 2011I just installed postgresql 8.4 package on my Ubuntu 10.10 desktop. Seems to have worked fine. But what is the password for logging into the databases created by user 'postgres'?
sudo su postgres
and then
createdb
or
psql mydb
fine and it never asks me for a password. But if I want to use pgadmin3, I want to enter passwd for postgres, etc.
Software :: Autofill - Tab Key - Not Working In Postgres ?
Feb 24, 2010I installed postgres successfully but, when I press tab key, it does not autofill the available options.
View 1 Replies View RelatedUbuntu :: Pgadmin On 10.10 - Support For Postgres 9?
Jan 16, 2011I am in the process of looking to migrate my PC from Windows 7 to Ubuntu 10.10 as I like it and i find it a little quicker than Windows. One of the major failings I find at the moment is software app support. I am setting up some PostgreSQL 9.0 servers (to do streaming replication) and using pgadmin to do the management.
Under Windows this app works great, but under Ubuntu it seems the standard package only supports up to 8.4, and looks like support has been dropped for pgadmin on Ubuntu. What I can't understand is the open source movement isn't supporting itself - or is it that because 10.10 is not on LTS, they are waiting for the next version to update the package - anyone know? If its not supported then back to Windows I go, because I know the latest version works fine.
Fedora Installation :: Apt-get Search Wget Saying Invalid Operation Search?
Apr 5, 2011i guess this is an installation issue as i am newish to Linux and got a F14 laptop from a used/refurb store... Anyway it seem i have difficulty with getting GTK running or maybe it is WGET...?
i did manage to install apt-get and was able to run synaptics ... but now whenever i try to run synaptics it flashes the interface and crashes. i tried apt-get search wget and it says invalid operation search. i tried apt cache wget and get a crash box in the upper right corner... i tried apt-get gtk+extra-2.1.2-4.fc14 and it says invalid operation gtk...
All of which is frustrating my attempts to get the GTK interface to J working. Their script uses WGET which i also cannot get.
