Ubuntu :: Postgres Installed But Cannot Find Reference
Mar 24, 2010
Just bought a new accounting program BasicBooks - on the install instructions (Gibberish to me) I apparently must have Postgres installed, which apparently comes with most distros. I can't find a reference to Postgres - there should be an entry in 'System Settings --> Server Settings --> Services from the main system menu', which I cannot find. Nor can I find it in the Ubuntu software centre. I did find pgAdmin III but have no idea how this works either.
I keep getting this error trying to connect to newly installed postgres server on Amazon EC2 running Ubuntu Maverick Meerkat.... Could not connect to server: Operation timed out Is the server running on host "....ap-southeast-1.compute.amazonaws.com" and accepting TCP/IP connections on port 5432?
I've updated config files, as follows... pg_hba.conf added host all all 124.168.242.0/24 trust where 124.168.242.0 is the IP range of my ISP postgresql.conf listen_addresses = '*' port = 5432 I am attempting to connect with pgAdmin 3 client. I don't think the problem is the client.
I am trying to learn about macros in libreoffice. In order to see the methods and properties of the different objects, people in the openoffice forums recommend using the MRI library.
I can not find any reference to the MRI extension in fedora. Does anyone know how to find it, or what to use instead?
Recently upgraded to 8GB RAM. BIOS shows 8GB, lshw shows 8GB (2 x4GB), Applications > System Tools > System Monitor > System shows 3.7GB. After 2 days of forum hunting I cannot find a way to check whether the machine is using all 8GB and, if not, how to make it do so. I have found a few postings about using the "bigmem" build but these seem to be for the 32-bit builds as well as a few postings saying that the amd64 build uses bigmem/highmem by default. I can't find any reference to CONFIG_HIGHMEM in /boot/config-2.6.32-5-amd64 and I don't have a menu.lst in /boot/grub to change to a "bigmem" type build.
I 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.
I 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.
I am very much interested in Postgres db. I have installed the DBI and DBD drivers. Created the Tables. Can any one help me ..how to access POSTGRES through a PERL program.
I 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
i 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.
We 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?
While 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.
We are going through the motions of testing the backup and restore configurations of our postgres database. One idea was testing the viability of the dump file. Does anyone know of a way of testing the dump file to determine if there is any corruption in it
I need to make some configuration changes to an ftp server running on Ubuntu server 10.04. I don't know which ftp server program is installed, so I don't know where to look for the config files. I know that some server is installed because I can connect to it
How can I determine which ftp server is installed?
Toshiba Satellite laptop, Ubuntu 10.04lts I installed qcad earlier today, using Software Center. Qcad didn't show up anywhere in the Applications dropdown menu. When I was running 9.04, it showed up in the Graphics sub-menu, but it's nowhere. Rebooted, nothing. It shows up as installed in the Synaptic Package Manager, but I went ahead and removed and installed it again, rebooting between each operation. (sigh) Still nothing. Now, I'm sure it's in here, but I can't find it. So, I have three questions: 1. How do I start it (or any program) using command line? 2. How do I find it using my Gnome gui, and put it in the applications menu and 3. Generally, is there a guide that will explain what I'm looking at when I open my File System directory?
I have installed SAFECOPY & TESTDISK using Synaptic manager. after installation I can't find the applications in the menu, I am trying to use them. where to find these applications?
I do not want to use cron.I want it to be instantaneous. I am working on a web server where the hosts turned-on safe mode and turned off a-lot of the functions for PHP (including exec) in order to secure their servers. Outside of that, I do have access to chroot and can pretty much do anything on the server. I want to use ImageMagick to create dynamic images based on form data.
I was trying to find a work-around with PHP where I can still use ImageMagick (a shell-based imagining program) by causing SQL to execute a shell script after the form data is saved to a table. Is there anyway it could cause a flag to automatically run a shell script when someone adds a new row to a certain table. It has to be instantaneous, more or less, so that the user isn't sitting there waiting for a minute for cron to catch any changes to the database.
I would like to find out from cmdline (!) if a certain software is already installed.In redhat based Linuxes I could enter something likerpm -qa|grep -i mysoftwarebut this does not work in Ubuntu.How can I find this out with apt?What, if the installation was done by a perl script .pl rather than with apt.How can I find out in this case?
I installed glipper 1.0-1.1 on my Ubuntu 9.10, and cannot find a way to execute it. I don't see it in the Applications menu, glipper command from the command line doesn't work.
I'm playing with my hard drive partitions and trying out different O/S versions so I want Grub2 to be aware of them on its boot menu. Currently I'm using the maintainer's version of Grub2 that came with karmic. Do I have to do a re-install of Grub2 or is there a makefile I can use? Specific commands that I would need be nice.
getting this message when trying to install XP."Setup did not find any HD installed in your computer." I have Ubuntu installed on another partition so it makes no sense that XP doesn't recognize my HD.
I have just installed the package monodevelop on Ubuntu 10.4 and wanted to try it out.I'm a long-time .NET developer using Visual Studio 2005/2008 on Windows so I'm familiar with the concepts.I created a new Gtk# project in MonoDevelop, but the empty project already won't compile because almost all referenced assemblies are missing. Here's the build error messages:
Warning: Die Referenz 'gtk-sharp, Version=2.12.0.0, Culture=neutral, PublicKeyToken=35e10195dab3c99f' ist ungltig fr das Ziel-Framework des Projekts. (test1) Warning: Die Referenz 'gdk-sharp, Version=2.12.0.0, Culture=neutral, PublicKeyToken=35e10195dab3c99f' ist ungltig fr das Ziel-Framework des Projekts. (test1) Warning: Die Referenz 'glib-sharp, Version=2.12.0.0, Culture=neutral, PublicKeyToken=35e10195dab3c99f' ist ungltig fr das Ziel-Framework des Projekts. (test1)
I have installed several applications on my Powerbook running lucid, but when I click the "applications" menu, many of them do not appear on the list. They show in the software install/remove application.
I am a beginner Ubuntu 9.10 user. I downloaded and installed the latest version of the sun VirtualBox. My problem is I cannot find where it is installed and that's why I could not run it. Generally, when I install a program the shortcut appears in the menu "Applications->ClassOfInstalledFile". But Virtual Box did not appear. How to find the icon, or simply how to run this application and have a shortcut of it on the "Applications" menu?
