Ubuntu :: Pgadmin On 10.10 - Support For Postgres 9?
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
ADVERTISEMENT
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
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
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
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
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
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
Mar 29, 2011
I made a system in CentOS5.5. I used Tomcat6 and PostgreSQL. But I couldn't enter my system. There are some error. And I don't understand what kind of error this.
JDBCExceptionReporter.logExceptions(100) | SQL Error: 0, SQLState: null
JDBCExceptionReporter.logExceptions(101) | Cannot create PoolableConnectionFactory (FATAL: Ident authentication failed for user "postgres")
"postgres" is username.
Is anybody knows anything about this error message.
View 4 Replies
View Related
Sep 10, 2010
I'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?
View 2 Replies
View Related
Apr 14, 2010
I have a HP laptop which can support 1600x900. But after I install ubuntu 9.10 on it, it can only support up to 1280x700. My laptop has a Nvidia graphics card. And i am using GNOME as my desktop environment.
View 1 Replies
View Related
May 26, 2011
I'm trying to install a copy of Postgres using the .bin(I want pg Admin III as well which is why I'm not using apt-get). It's sitting in downloads so I did the following:
$ cd /home/ryan/Downloads
$ sudo chmod +x postgresql-9.0.4-1-linux.bin
$ ./postgresql-9.0.4-1-linux.bin
but I keep getting: -bash: ./postgresql-9.0.4-1-linux.bin: No such file or directory I did -ls and the file is there and I can't figure out how to get this installed.
View 9 Replies
View Related
Jul 10, 2011
I'm trying to find out when QME2572 (Qlogic) card became support by the kernel. We have a RHEL 5.1 system that is moving to new hardware, however the kernel at this release doesn't support the new hardware, due to the Qlogic card change. I tired the Redhat KB and Bugzilla. Is there a Kernel change list etc I can search. Never really played around with the kernel too much so I'm just after some pointers for looking up this information. Offically its not supported until Redhat 5.3, I'm trying trying to research kernel info so I can tell the customer they have to upgrade.
View 3 Replies
View Related
Aug 25, 2010
I'm looking to dual-boot Windows 7 and Debian 6 upon its release on my sister's laptop. I want to share a partition between the two of them so that /home points to this directory and the Windows equivalent also points to it (C:Users).
Anyway, I've heard good and bad things about the NTFSMount driver (I think it's NTFS-3G now) and the NTFSprogs project and so I am not so certain what I should believe. I do know that NTFS has relatively high overhead, though I do not recall the source of this assertion, so I am considering the use of EXFAT. An open source EXFAT project is hosted on Google Code at [url] and it utilizes the kernel module FUSE.
I'm quite certain that I've got everything covered on the Windows side -- that is, I know that both NTFS and EXFAT will be suitable filesystems for my required usage.
My issue is that I'm curious which will have superior performance and stability in Debian. I planned on building the package from source and mounting the device in my FSTAB but I have also found a PPA for Ubuntu on Launchpad at [url] that I could borrow the debian/rules from and make a .deb package from.
What do you guys think? Should I go at it with the EXFAT or NTFS partitioning? Is NTFS-3G actually fairly supported at this point? Or perhaps should I consider some alternate method?
I have also considered that the only files she will be sharing are those of music, videos, and pictures so it could be better to just link /home/xxxx/Pictures (Music and Videos, too) to the new partition instead of all of /home.
View 7 Replies
View Related
May 11, 2011
I would like to know if it is possibile to have support for wi-fi midi support in linux.
View 1 Replies
View Related
Sep 1, 2009
I need a textbrowser with Javascript Support. I have compiled the elinks stable 0.11x and the unstable 0.12x version mit JavaScript Support (js moz dev). Both browsers can be started and showed websites normaly. But no javascript, even simple tests like [URL] failed. I started elink with ./elink and typed then the url.
View 4 Replies
View Related
Sep 26, 2010
Does anyone know? I have 9.04 as originally installed on my Dell netbook. It works great and I hate to change it although I realize I will have to one day. I do not see anything on the Ubuntu site as to an end of life date - it could be next month.
View 4 Replies
View Related
Jan 30, 2010
I am wondering if Ubuntu support ATA TRIM for SSD out of the box?
View 1 Replies
View Related
Mar 7, 2010
I am trying to find a good text based email client for an older machine, which will not run the GUI correctly due to min. hardware; however, I want to be able to use it with Text based email clients.Can anyone recommend a good text based email client that supports TLS/SSL for securied connections for IMAP, or even POP3?Does MUTT support SSL/TLS?
View 2 Replies
View Related
Apr 30, 2010
I need USB support in Virtual Box for some windows programs that do not run in Ubuntu. I forgot about the OSE version not supporting USB. Has anyone loaded virtual box on 10.04 and if so, which version should I download for my simple 386 machine. Will 9.10 version work?
View 8 Replies
View Related
Jun 10, 2010
I noticed lately the main chat client inserted in the new versions of Ubuntu is Empathy, rather nice, and I saw some very nice integrations in gnome-shell. Only one problem with it, no Off-The-Record (OTR) support, and no interest in implementing it. I am not sure how many of you out there are using it (OTR), but I basically love it, and I feel more safe when I use it. I like Empathy very much, but I do not understand the lack of interested of the developers for implementing such a great feature.
I have made this article, because I just want to do my part, as others did in filing bug reports, and making complaints to introduce this great feature to Empathy. If you want this feature in Empathy there are some places where you can make your voice heard: [URL]...
I know it says there they started to work on it in 2009, but after that no sign of development, basically for me it was just something to calm people down, and make them stop asking for this feature.I did not like the forced removal of pidgin, and the "you can use it, but we are not support it" excuse, but I learned to live with it, and adapt. I admit I am unable to code an otr plugin for Empathy or I would,
View 2 Replies
View Related