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.
View 2 Replies
ADVERTISEMENT
Dec 26, 2010
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.
View 6 Replies
View Related
Jun 22, 2011
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?
View 1 Replies
View Related
Jul 21, 2011
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.
View 12 Replies
View Related
Jun 23, 2011
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.
View 4 Replies
View Related
Jan 16, 2011
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.
View 4 Replies
View Related
Jul 25, 2010
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.
View 1 Replies
View Related
Mar 16, 2010
how to setup multiple instance of postgre server on the same machine.
View 4 Replies
View Related
Feb 10, 2010
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
[Code]...
View 4 Replies
View Related
Jul 21, 2010
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.
View 15 Replies
View Related
Jun 9, 2010
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?
View 2 Replies
View Related
Feb 24, 2010
I installed postgres successfully but, when I press tab key, it does not autofill the available options.
View 1 Replies
View Related
Jan 31, 2011
Ok 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
View Related
Mar 24, 2011
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.
View 2 Replies
View Related
May 13, 2010
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
View 2 Replies
View Related
Jun 22, 2010
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?
View 3 Replies
View Related
Dec 11, 2010
It just goes to a file I have no idea where?
View 2 Replies
View Related
Dec 22, 2010
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?
View 8 Replies
View Related
Jun 20, 2011
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?
View 2 Replies
View Related
Jan 28, 2010
Whenever i restart postgres in my server, Selinux is not letting it log anything. In /var/log/messages, it says.
Quote: Jan 28 14:15:43 dataserver kernel: audit(1264709743.263:38): avc: denied { append } for pid=5986 comm="postmaster" name="pgsql.log" dev=sda8 ino=3932166 scontext=root:system_r: postgresql_t tcontext=root: object_r:var_log_t tclass=file
Jan 28 14:15:43 dataserver kernel: audit(1264709743.263:39): avc: denied { append } for pid=5986 comm="postmaster" name="pgsql.log" dev=sda8 ino=3932166 scontext=root:system_r: postgresql_t tcontext=root: object_r:var_log_t tclass=file
I cannot disable SeLinux in this server.
View 1 Replies
View Related
Mar 16, 2011
following is the error [root@webserver Desktop]# rpm -ivh swl-apache-2.2.17.2-1.i386.rpm
error: Failed dependencies:
libpq.so.4 is needed by swl-apache-2.2.17.2-1.i386
[root@webserver Desktop]# rpm -ivh postgresql-libs-8.1.23-1PGDG.rhel5.x86_64.rpm
warning: postgresql-libs-8.1.23-1PGDG.rhel5.x86_64.rpm: Header V3 DSA
[code].....
View 1 Replies
View Related
Mar 17, 2009
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.
View 1 Replies
View Related
Oct 16, 2010
Anyone out there tried to compile postgres with ossp-uuid . It works 100% fine without it , need it for Openbravo ERP
Slackware 13.1 64
postgresql-8.4.4
"checking for uuid_export in -lossp-uuid... no
checking for uuid_export in -luuid... no
[Code].....
View 6 Replies
View Related
Jan 27, 2010
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?
View 1 Replies
View Related
Mar 17, 2010
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.
View 3 Replies
View Related
Mar 19, 2010
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.
View 5 Replies
View Related
Jul 5, 2010
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.
View 2 Replies
View Related
Oct 9, 2010
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)
[Code]...
View 4 Replies
View Related
Oct 26, 2010
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.
How can I run the unlisted applications?
View 2 Replies
View Related
Nov 23, 2010
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?
View 1 Replies
View Related
