Re: Postgresql ODBC driver not found

On Sun, Sep 26, 2021 at 12:10:39AM +0200, Pierre Couderc wrote: > > On 9/25/21 3:46 PM, Henning Follmann wrote: > > > > have you tried to use the odbc lib from unixodbc instead of > > libiodbc? > > > > I think you are right on many other points... > > But particularly on this one ! > > I did

Re: Postgresql ODBC driver not found

On 9/25/21 3:46 PM, Henning Follmann wrote: have you tried to use the odbc lib from unixodbc instead of libiodbc? I think you are right on many other points... But particularly on this one ! I did remove libodbc2-dev and install unixodbc-dev and now it is OK...!! Wow ! Thank you very mu

Re: Postgresql ODBC driver not found

On Sat, Sep 25, 2021 at 09:16:33AM +0200, Pierre Couderc wrote: > > On 9/24/21 5:31 PM, Henning Follmann wrote: > > > > and I see you do not do any error checking. > > This would be a first step to find out where it fails. > > > > I added some code... > > > > You hare fully right, I have corre

Re: Postgresql ODBC driver not found

On 9/24/21 5:31 PM, Henning Follmann wrote: and I see you do not do any error checking. This would be a first step to find out where it fails. I added some code... You hare fully right, I have corrected, but I have the same result and no more idea.. : nous@pcouderc:~/projets//build$

Re: Postgresql ODBC driver not found

On Thu, Sep 23, 2021 at 11:55:00PM +0200, Pierre Couderc wrote: > Thenk you, Henning, thank you Gregory . > > On 9/23/21 5:49 PM, Gregory Seidman wrote: > > On Thu, Sep 23, 2021 at 08:18:45AM -0400, Henning Follmann wrote: > > > > > I don't see where you ask for the PostgreSQL ODBC connection in

Re: Postgresql ODBC driver not found

Thenk you, Henning, thank you Gregory . On 9/23/21 5:49 PM, Gregory Seidman wrote: On Thu, Sep 23, 2021 at 08:18:45AM -0400, Henning Follmann wrote: I don't see where you ask for the PostgreSQL ODBC connection in particular. Maybe I'm the one missing something? You are right, I am not trying

Re: Postgresql ODBC driver not found

On Thu, Sep 23, 2021 at 08:18:45AM -0400, Henning Follmann wrote: > On Thu, Sep 23, 2021 at 08:44:42AM +0200, Pierre Couderc wrote: > > Thank you very much! > > > > See below : > > > > On 9/22/21 3:37 PM, Henning Follmann wrote: > > > On Wed, Sep 22, 2021 at 11:07:28AM +0200, Pierre Couderc wrote

Re: Postgresql ODBC driver not found

On Thu, Sep 23, 2021 at 08:44:42AM +0200, Pierre Couderc wrote: > Thank you very much! > > See below : > > On 9/22/21 3:37 PM, Henning Follmann wrote: > > On Wed, Sep 22, 2021 at 11:07:28AM +0200, Pierre Couderc wrote: > > > It is here I see it/them with: > > > > > > odbcinst -q -d > > > > > >

Re: Postgresql ODBC driver not found

Thank you very much! See below : On 9/22/21 3:37 PM, Henning Follmann wrote: On Wed, Sep 22, 2021 at 11:07:28AM +0200, Pierre Couderc wrote: It is here I see it/them with: odbcinst -q -d but not with :   SQLHENV env;   SQLCHAR driver[256];   SQLCHAR attr[256];   SQLSMALLINT driver_ret;

Re: Postgresql ODBC driver not found

On Wed, Sep 22, 2021 at 11:07:28AM +0200, Pierre Couderc wrote: > It is here I see it/them with: > > odbcinst -q -d > > but not with : > >   SQLHENV env; >   SQLCHAR driver[256]; >   SQLCHAR attr[256]; >   SQLSMALLINT driver_ret; >   SQLSMALLINT attr_ret; >   SQLUSMALLINT direction; >   SQLRETUR

Re: Postgresql logging problem

Solved: changing the ownership of the custom log in conf.d solved the problem. Regards Johann On Tue, 3 Dec 2019 at 17:14, Johann Spies wrote: > We have upgraded two servers by installing postgresql(pgpd) 12. Both > servers are running Debian Stable. > > On the problem server we have: > pg_lsc

Re: postgresql-12 - crash. Any hints.

On Di, Nov 05, 2019 at 10:42:28 +0100, Kamil Jońca wrote: I migrate databases, and during last few days I have had 2 server crashes. I have similiar signal 11 crashes after the upgrade (pg_upgradecluster). Maybe you should keep your hands from version 12. Shade and sweet water! Steph

Re: postgresql-12 - crash. Any hints.

deloptes writes: > Kamil Jońca wrote: > [...] > > also perhaps consider contacting application maintenance I did. Issued bug at postgres. > > why do you write here? Isn't there a postgres mailing list? To warn someone before premature upgrading :-P KJ -- http://wolnelektury.pl/wesprzyj/ter

Re: postgresql-12 - crash. Any hints.

Kamil Jońca wrote: > Today was another crash. > Another piece of a puzzle: There is (unlogged) table with 70M+ > rows. After crash this table is empty (but table itself exists.) read documentation fine tune postgres be happy also perhaps consider contacting application maintenance why do you wr

Re: postgresql-12 - crash. Any hints.

kjo...@poczta.onet.pl (Kamil Jońca) writes: > It is home PC box with debian sid. > Recently my postgres was upgraded from version 11 to 12. > I migrate databases, and during last few days I have had 2 server > crashes. > Crashes were during different statements. And after crash these > statements

Re: Postgresql and DRBD

I've had good experiences running RedHat Cluster Services (corosync, pacemaker) for the GFS2 filesystem and databases on top of it. It performed and recovered well. However that was not with Postgresql. Most of my database work is with Oracle and mysql, but I have found Postgres separately to be ex

Re: Postgresql and DRBD

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, Apr 17, 2018 at 09:01:45AM +0300, Veli Cakmak wrote: > Hello dear liste, > > I have really important database and it should not lost any data. Is it > safe Postgresql, DRBD, Pacemaker, Corosyn structure. ? PostgreSQL has its own replication m

Re: postgresql doesn't start at boot

On Wed, Aug 06, 2014 at 05:19:14PM +0100, Glyn Astill wrote: > > From: B > >To: debian-user@lists.debian.org Sent: Wednesday, 6 August 2014, > >15:58 Subject: postgresql doesn't start at boot > > > > > >sid amd64 > > > >Hi mailing-listers, > > > >since the upgrade from 9.3 to

Re: postgresql doesn't start at boot

> From: B >To: debian-user@lists.debian.org >Sent: Wednesday, 6 August 2014, 15:58 >Subject: postgresql doesn't start at boot > > >sid >amd64 > > >Hi mailing-listers, > >since the upgrade from 9.3 to 9.4, postgresql doesn't automatically start >at boot anymore. >I added a sym

Re: postgresql doesn't start at boot

Maybe the link was created in a wrong directory 2014-08-06 17:34 GMT+02:00 Michael Biebl : > > > On 6. August 2014 17:17:22 MESZ, B wrote: >>On Wed, 6 Aug 2014 17:07:56 +0200 >>emmanuel segura wrote: >> >>> Have you try systemctl enable postgresql.service ? >> >>Done (and quite different

Re: postgresql doesn't start at boot

On 6. August 2014 17:17:22 MESZ, B wrote: >On Wed, 6 Aug 2014 17:07:56 +0200 >emmanuel segura wrote: > >> Have you try systemctl enable postgresql.service ? > >Done (and quite different from a symlink:( Funny, because all systemctl enable does is create a symlink > >As I'm working, I'll t

Re: postgresql doesn't start at boot

On Wed, 6 Aug 2014 17:07:56 +0200 emmanuel segura wrote: > Have you try systemctl enable postgresql.service ? Done (and quite different from a symlink:( As I'm working, I'll test it tonight; thanks. -- is gogaz an anti jew nick? NO -- To UNSUBSCRIBE, email to debian-user-requ...@lists.de

Re: postgresql doesn't start at boot

Have you try systemctl enable postgresql.service ? 2014-08-06 16:58 GMT+02:00 B : > sid > amd64 > > > Hi mailing-listers, > > since the upgrade from 9.3 to 9.4, postgresql doesn't automatically start > at boot anymore. > I added a symlink to /lib/systemd/system/postgresql.serv

Re: Postgresql setup on Debian system

2013/12/11 Gary Roach > On 12/10/2013 11:13 PM, Raffaele Morelli wrote: > > BTW you are not clear: what are you trying to achieve? > > Not too surprising that I wasn't clear. I feel like I'm floundering > around. I am trying to build a data archiving system that will have > multiple levels of u

Re: Postgresql setup on Debian system

On 12/10/2013 11:13 PM, Raffaele Morelli wrote: 2013/12/11 Gary Roach > I just switched from using PHP and Mysql to Python / Django and Postgresql. I am having trouble with the setup of Postgresql permissions. I am locked out of some parts of the sys

Re: Postgresql setup on Debian system

On Tue, Dec 10, 2013 at 06:25:16PM -0800, Gary Roach wrote: > automatically (I think). I found the Debian README confusing, > especially in regards to setting up a special shell that I don't > think I need. Are you referring to the postgres user? -- "If you're not careful, the newspapers will h

Re: Postgresql setup on Debian system

2013/12/11 Gary Roach > I just switched from using PHP and Mysql to Python / Django and > Postgresql. I am having trouble with the setup of Postgresql permissions. I > am locked out of some parts of the system and am unsure when to use > postgres login vs user login. Most of the Postgresql instru

Re: Postgresql-8.1 Removal Problems (SOLVED, sort of)

I got rid of it! Here is what I did: 1. Removed the symlinks in /etc/rc#.d 2. Placed strategic exit 0 in update-rc.d and invoke=rc.d scripts 3. Created fake /var/run/postgresql/8.1-main.pid" and /usr/share/postgresql/8.1/tsearch_data files since it returned errors about them missing. 4. Finally

Re: Postgresql-8.1 Removal Problems

On Wednesday 29 February 2012 20:02:01 debian-user-digest- requ...@lists.debian.org wrote: > >> >> How did you remove it? apt-get, aptitude, dpkg, synaptic... > >> > > >> > > >> > > >> > apt-get / dpkg -r/ dpkg -P > >> > I do not use aptitude > >> > >> > >> > >> And what's the full output for tha

Re: Postgresql-8.1 Removal Problems

On Wed, 29 Feb 2012 17:54:10 +0200, David Baron wrote: >> >> How did you remove it? apt-get, aptitude, dpkg, synaptic... >> > >> > apt-get / dpkg -r/ dpkg -P >> > I do not use aptitude >> >> And what's the full output for that commands? > ~$ sudo dpkg -P postgresql-8.1 > (Reading database ... 54

Re: Postgresql-8.1 Removal Problems

On Wednesday 29 February 2012 16:50:26 debian-user-digest- requ...@lists.debian.org wrote: > >> > Package apparently obselete, dependencies no longer installable. > >> > However, I cannot remove it. > >> > >> > >> > >> How did you remove it? apt-get, aptitude, dpkg, synaptic... > > > > apt-get /

Re: Postgresql-8.1 Removal Problems

On Wed, 29 Feb 2012 10:16:08 +0200, David Baron wrote: > On Tuesday 28 February 2012 21:03:15 debian-user-digest- > requ...@lists.debian.org wrote: >> > Package apparently obselete, dependencies no longer installable. >> > However, I cannot remove it. >> >> How did you remove it? apt-get, aptitud

Re: Postgresql-8.1 Removal Problems

On Wednesday 29 February 2012 14:01:03 debian-user-digest- requ...@lists.debian.org wrote: > > It is still there. > > > > Manually stopping the daemon does not produce any error or output and the > > removal error remains. > > > > > > Maybe 'deborphan' could help; no harm in trying. apt and

Re: Postgresql-8.1 Removal Problems

On 29/02/12 08:16, David Baron wrote: It is still there. Manually stopping the daemon does not produce any error or output and the removal error remains. Maybe 'deborphan' could help; no harm in trying. -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of

Re: Postgresql-8.1 Removal Problems

On Tuesday 28 February 2012 21:03:15 debian-user-digest- requ...@lists.debian.org wrote: > > Package apparently obselete, dependencies no longer installable. > > However, I cannot remove it. > > How did you remove it? apt-get, aptitude, dpkg, synaptic... apt-get / dpkg -r/ dpkg -P I do not use ap

Re: Postgresql-8.1 Removal Problems

On 28/02/12 18:28, Camaleón wrote: Get error: update-rc.d: warning: postgresql-8.1 stop runlevel arguments (0 1 6) do not match LSB Default-Stop values (S 0 1 6) How do I get rid of it. (...) Despite the above error which I've also seen when you stop/restart/remove may of the init scrip

Re: Postgresql-8.1 Removal Problems

On Tue, 28 Feb 2012 18:08:11 +0200, David Baron wrote: > Package apparently obselete, dependencies no longer installable. > However, I cannot remove it. How did you remove it? apt-get, aptitude, dpkg, synaptic... > Get error: update-rc.d: warning: postgresql-8.1 stop runlevel arguments > (0 1 6

Re: Postgresql-8.1 Removal Problems

On Tuesday 28 February 2012 19:36:17 debian-user-digest- requ...@lists.debian.org wrote: > > Package apparently obselete, dependencies no longer installable. However, > > I cannot remove it. Get error: update-rc.d: warning: postgresql-8.1 stop > > runlevel arguments (0 1 6) do not match LSB Default

Re: Postgresql-8.1 Removal Problems

On 02/28/2012 11:08 AM, David Baron wrote: Package apparently obselete, dependencies no longer installable. However, I cannot remove it. Get error: update-rc.d: warning: postgresql-8.1 stop runlevel arguments (0 1 6) do not match LSB Default-Stop values (S 0 1 6) How do I get rid of it. (It no

Re: PostgreSQL+ZFS

On Saturday 01 January 2011 20:30:31 Stan Hoeppner wrote: > Boyd Stephen Smith Jr. put forth on 1/1/2011 2:16 PM: > > Is your problem with RAID5 or the SSDs? > > RAID 5 > > > Sudden disk failure can occur with SSDs, just like with magnetic media. > > If > > This is not true. This is true. Whi

Re: PostgreSQL+ZFS

Atif CEYLAN put forth on 1/1/2011 3:58 PM: > On 01/01/2011 06:24 PM, Stan Hoeppner wrote: >> How much data? Total GB? > ~300 GB >> Are you currently short of space? > no, don't need more space. Perfect. :) >> Are you currently short of IOPS capacity? > yes Got it. >> How many concurrent t

Re: PostgreSQL+ZFS

Boyd Stephen Smith Jr. put forth on 1/1/2011 2:16 PM: > Is your problem with RAID5 or the SSDs? RAID 5 > Sudden disk failure can occur with SSDs, just like with magnetic media. If This is not true. The failure modes and rates for SSDs are the same as other solid state components, such as syst

Re: PostgreSQL+ZFS

On 01/01/2011 06:24 PM, Stan Hoeppner wrote: Atif CEYLAN put forth on 12/31/2010 4:58 PM: Hi all, I have a large postgresql database system and I want to migrate to a new and fast storage system (10 Gbp/s FC network). But 150x3 ssd disk on my db server and I want to use ext4 file system (rai

Re: PostgreSQL+ZFS

In <4d1f5543.3010...@hardwarefreak.com>, Stan Hoeppner wrote: >Atif CEYLAN put forth on 12/31/2010 4:58 PM: >> I have a large postgresql database system and I want to migrate to a new >> and fast storage system (10 Gbp/s FC network). But 150x3 ssd disk on my >> db server and I want to use ext4 file

Re: PostgreSQL+ZFS

Atif CEYLAN put forth on 12/31/2010 4:58 PM: > Hi all, > I have a large postgresql database system and I want to migrate to a new > and fast storage system (10 Gbp/s FC network). But 150x3 ssd disk on my > db server and I want to use ext4 file system (raid5) at the ssd disks as > xlog storage or us

Re: Postgresql wont restart. Can I clear shared memmory segments without rebooting?

On 10-01-06 08:09:00, Stan Hoeppner wrote: ... > ... The big question though is why this is happening in the first > place. Your top output showed 750MB+ in the cache on a system with > 1GB ram. That's 3/4 of your system memory occupied by cached disk > file pages, which is quite normal for Linu

Re: Postgresql wont restart. Can I clear shared memmory segments without rebooting?

Mitchell Laks put forth on 1/6/2010 1:27 AM: > On 02:39 Tue 05 Jan , Stan Hoeppner wrote: >> Try these: >> >> To free pagecache: >> >> # echo 1 > /proc/sys/vm/drop_caches >> >> To free dentries and inodes: >> >> # echo 2 > /proc/sys/vm/drop_caches >> >> To free pagecache, dentries and inodes: >

Re: Postgresql wont restart. Can I clear shared memmory segments without rebooting?

Kun Niu: > > Before you execute "echo 3 > /proc/sys/vm/drop_caches", you'd better run > "sync" first.:D Why? Do you want to suggest dropping the caches throws away the write cache, too, without flushing to disk first? I would be very surprised to hear that! J. -- I have been manipulated and pe

Re: Postgresql wont restart. Can I clear shared memmory segments without rebooting?

On 15:30 Wed 06 Jan , Kun Niu wrote: > Before you execute "echo 3 > /proc/sys/vm/drop_caches", you'd better > run "sync" first.:D Thank you, a good point. I was mostly interested as a matter of knowledge, as I did not go into linux to become a 'cargo culter' and reboot without knowing what i

Re: Postgresql wont restart. Can I clear shared memmory segments without rebooting?

On 09:36 Tue 05 Jan , Boyd Stephen Smith Jr. wrote: > > These commands should help: > ipcmk (1) - create various ipc resources > ipcrm (1) - remove a message queue, semaphore set or shared memory id > ipcs (1) - provide information on ipc facilities > > They are from the util-lin

Re: Postgresql wont restart. Can I clear shared memmory segments without rebooting?

Before you execute "echo 3 > /proc/sys/vm/drop_caches", you'd better run "sync" first.:D Mitchell Laks write: On 02:39 Tue 05 Jan , Stan Hoeppner wrote: Try these: To free pagecache: # echo 1 > /proc/sys/vm/drop_caches To free dentries and inodes: # echo 2 > /proc/sys/vm/drop_cache

Re: Postgresql wont restart. Can I clear shared memmory segments without rebooting?

On 02:39 Tue 05 Jan , Stan Hoeppner wrote: > Try these: > > To free pagecache: > > # echo 1 > /proc/sys/vm/drop_caches > > To free dentries and inodes: > > # echo 2 > /proc/sys/vm/drop_caches > > To free pagecache, dentries and inodes: > > echo 3 > /proc/sys/vm/drop_caches this was very

Re: Postgresql wont restart. Can I clear shared memmory segments without rebooting?

In <20100105073412.ga5...@earthlink.net>, Mitchell Laks wrote: >I have a remote server running debian etch, >that has only 1G of ram, (that i cannot easily add ram to), that runs >a large postgresql 7.4 database and it occasionally runs out of enough > shared memory. The database is static and I no

Re: Postgresql wont restart. Can I clear shared memmory segments without rebooting?

Mitchell Laks put forth on 1/5/2010 1:34 AM: > While I can continue to do this, but it goes against the grain. Is there > some system command to free the > shared memory so that postgresql will start again without rebooting? Try these: To free pagecache: # echo 1 > /proc/sys/vm/drop_caches

Re: postgresql installation error

Allan Wind wrote: On 2009-12-16T20:36:15, Clark Martin wrote: I recently upgraded from lenny to squeeze on a 2GHz AMD based HP computer. It mostly went well but during the upgrade process and any time I run dpkg, aptitude or synaptic it gripes about postgresql. http://bugs.debian.org/cgi-bin/

Re: postgresql installation error

On 2009-12-16T20:36:15, Clark Martin wrote: > I recently upgraded from lenny to squeeze on a 2GHz AMD based HP > computer. It mostly went well but during the upgrade process and > any time I run dpkg, aptitude or synaptic it gripes about > postgresql. http://bugs.debian.org/cgi-bin/bugreport.cgi?

Re: postgresql & sid

On Sun, Apr 12, 2009 at 07:08:03PM +0200, Florian Kulzer wrote: > On Fri, Apr 10, 2009 at 00:58:05 +0430, Mohsen Pahlevanzadeh wrote: > > When i use debian:/home/mohsen# /etc/init.d/postgresql-8.3 start > > debian:/home/mohsen# > > > > I didn't see any output. > Did you check the documentation in

Re: postgresql & sid

On Fri, Apr 10, 2009 at 00:58:05 +0430, Mohsen Pahlevanzadeh wrote: > Dear all, > When i use dpkg -l "postgresql*" i see following output: [ snip: the relevant packages seem to be installed ] > When i use debian:/home/mohsen# /etc/init.d/postgresql-8.3 start > debian:/home/mohsen# > > I didn't

Re: Postgresql 8.3 Question

--- On Tue, 2/17/09, Alex Samad wrote: > From: Alex Samad > Subject: Re: Postgresql 8.3 Question > To: debian-user@lists.debian.org > Date: Tuesday, February 17, 2009, 12:20 PM > On Tue, Feb 17, 2009 at 02:55:57AM -0800, Dancing Fingers > wrote: > > Hi guys, > &

Re: Postgresql 8.3 Question

On Tue, Feb 17, 2009 at 02:55:57AM -0800, Dancing Fingers wrote: > Hi guys, > I'm used to Postgresql 7.4 but when Debian 5 came out I had to try > it. Everything was okay except the ATI driver killed my tvtime but I > can live with that (dual monitors are more important). The part I > can't live

re: postgresql postrm script needs work

I forgot to mention tiger had also been installed on this system. When tiger got removed earlier today, all the sudden a whole bunch of postgresql packages were removed with it. Apparently there was some kind of dependencies issues with stuff in the tiger packages. I am puzzled by this since

Re: postgresql postrm script needs work

Jude DaShiell wrote: > Having failed to install postgresql on sid for reasons already discussed > on this list, I ran updatedb then did locate postgresql | less to see [snip] I doubt postgresql maintainers read this. File a bug. -- Eugene V. Lyubimkin aka JackYF, JID: jackyf.devel(maildog)gmail.c

Re: postgresql setup

On Fri, Jan 30, 2009 at 10:02:01AM -0200, Eduardo M KALINOWSKI wrote: > Jude DaShiell wrote: > > Okay, I figured all of it out. postgresql is uninstallable because > > postgresql-common requires postgresql79 and that's uninstallable. > > I'm probably feeding a troll right now (and I know I shoul

Re: postgresql setup

Jude DaShiell wrote: > Okay, I figured all of it out. postgresql is uninstallable because > postgresql-common requires postgresql79 and that's uninstallable. I'm probably feeding a troll right now (and I know I shouldn't), but neither the etch nor the lenny/sid versions of 'postgresql' depend on

re: postgresql setup

Okay, I figured all of it out. postgresql is uninstallable because postgresql-common requires postgresql79 and that's uninstallable. That sets up a situation almost similar to what I encountered when I tried installing emacs and gnus but at least gnus is already in the current version of emac

Re: postgresql setup

On Thu, Jan 29, 2009 at 04:19:40PM -0500, Jude DaShiell wrote: > I found out a little more just now. Having failed to find the debian > packager's installation instructions for postgresql I removed the > packages from this system. Later I figured to install everything and > take another look.

Re: re: postgresql setup

On Wed, 28 Jan 2009 23:40:12 +0100, Jude DaShiell wrote: > This gets stranger by the second. I managed to get postgresql going as > user postgres with postgresql -h 127.0.0.1 & . Then I was able to > run createuser dashielljt successfully and createdb too. So I exited > the postgres identity an

re: postgresql setup

This gets stranger by the second. I managed to get postgresql going as user postgres with postgresql -h 127.0.0.1 & . Then I was able to run createuser dashielljt successfully and createdb too. So I exited the postgres identity and dropped back to dashielljt and tried psql -h 127.0.0.1 and p

re: postgresql setup

It makes no difference if you've done su - postgres before running createuser, the same error message appears. I checked that to make sure. I do have a firewall up and running on this machine and port 5432 is not open to the world if that helps any. -- To UNSUBSCRIBE, email to debian-user-r

re: postgresql setup

On Sun, 2009-01-25 at 06:04 -0500, Jude DaShiell wrote: > Script started on Sun 25 Jan 2009 05:56:42 AM EST > verizon:~# createuser dashielljt > Shall the new role be a superuser? (y/n) y > createuser: could not connect to database postgres: could not connect to > server: No such file or director

re: postgresql setup

I installed version 8.3.5 with tasksel. When I ran initdb, it ran in debug mode but ran successfully so far as I can tell. I was then able to run postgres -D /usr/local/postgresql/data and the message that came back said postgres was ready to accept connections. I exited that and the databas

Re: postgresql setup question

On 01/24/2009 06:37 AM, Jude DaShiell wrote: I managed to make the postgresql cluster with initdb but can't do Are you *sure* that PostgreSQL is clusterable? anything with createuser because postgresql by default is trying to use a unix socket at address 5432. I'm running on amd hardware and

Re: postgresql 7.4 and 8.1 on the same system

On Sun, Apr 13, 2008 at 05:22:27PM +0200, Paul Csanyi wrote: > Hello! > > I have installed on Debian Etch both postgresql 7.4 and 8.1. > > When I log in to the postgresql database with su postgres, > how can I know, which one is used? > > Say, I want to log in to the postgresql 7.4, then which >

Re: Postgresql very slow to start on with LDAP

On Tue, Jan 29, 2008 at 03:01:27AM -0500, Oren Laadan wrote: > Hi, > > After switching to LDAP authentication on our system, I noticed that > PostgreSQL start-up (and shut-down) time because ridiculously high. > (The PostgreSQL server isn't used as the back-end for LDAP; the LDAP > servers sits els

Re: postgresql 7.4 won't start after sarge -> etch upgrade

On 09:49 Sun 14 Oct , Pál Csányi wrote: > > > How should I rectify the problem? > > I would reinstall postgresq-7.4 : > aptitude reinstall postgresql-7.4 Thank you Pál, I had already tried that: apt-get install --reinstall postgresql-7.4 and it did not help :( Any other ideas? what is re

Re: postgresql 7.4 won't start after sarge -> etch upgrade

2007/10/14, Mitchell Laks <[EMAIL PROTECTED]>: > I just upgraded an old Sarge server to Etch. > > After the upgrade, I notice that the postgresq-7.4 server is not working. > How should I rectify the problem? I would reinstall postgresq-7.4 : aptitude reinstall postgresql-7.4 -- Regards, Paul C

Re: postgresql help

Hi, 2007/9/15, Chris Bannister <[EMAIL PROTECTED]>: > On Mon, Sep 10, 2007 at 08:36:59PM -0400, Tom Allison wrote: > > But somewhere I screwed up my postgresql-8.2 database installation. > > I meant to set up the data directory on the RAID disk array > > Unfortunately I deleted the /var/lib/postgr

Re: postgresql help

On Mon, Sep 10, 2007 at 08:36:59PM -0400, Tom Allison wrote: > I'm at a road block... > > I was reinstalling my hard drives to put in a RAID1 array. > The RAID/LVM stuff works 100%. > > But somewhere I screwed up my postgresql-8.2 database installation. > I meant to set up the data directory on the

Re: postgresql help

On 9/12/07, Jude DaShiell <[EMAIL PROTECTED]> wrote: > When you do an uninstall with purge, your original packages are still in > /var/cache/apt/archives. I had a situation with timidity that was similar > though I had lost one of timidity's configuration files and reinstalling > using packages al

Re: postgresql help

When you do an uninstall with purge, your original packages are still in /var/cache/apt/archives. I had a situation with timidity that was similar though I had lost one of timidity's configuration files and reinstalling using packages already on the hard drive did not repair the situation. I

Re: postgresql help

On 2007-09-10T20:36:59-0400, Tom Allison wrote: > But somewhere I screwed up my postgresql-8.2 database installation. > I meant to set up the data directory on the RAID disk array > Unfortunately I deleted the /var/lib/postgresql/ directory and can't > or don't know what to do to fix it. Do you

Re: postgresql upgrade from sarge to etch

On Tue, Jul 10, 2007 at 11:49:33PM -0400, Tony Heal wrote: > > Yes the file was there. This was in fact a complete running systems with no > problems. Postgresql was running with 2 > small databases and 2 users. > Then I am not sure. Perhaps a misbehaving preinst or postinst script? Regards,

RE: postgresql upgrade from sarge to etch

TECTED] > Sent: Tuesday, July 10, 2007 6:40 PM > To: debian-user@lists.debian.org > Subject: Re: postgresql upgrade from sarge to etch > > On Tue, Jul 10, 2007 at 05:41:35PM -0400, Tony Heal wrote: > > I am trying to upgrade from sarge to etch and having issues with > >

Re: postgresql upgrade from sarge to etch

On Tue, Jul 10, 2007 at 05:41:35PM -0400, Tony Heal wrote: > I am trying to upgrade from sarge to etch and having issues with postgresql. > Here is the error on the screen, but I am > getting nothing in /var/log/dpkg.log or the syslog > > > > Setting up postgresql-client (7.5.22) ... > > Sett

Re: Postgresql very slow to start on Etch with LDAP

On Fri, May 25, 2007 at 12:00:03PM +0200, Stefano Salvi wrote: > I'm configuring a workstation in a network that manages users and groups > with openLDAP. > I created nearly 60 users in Postgresql. > Now the server takes nearly 2 minutes on startup (/etc/init.d/postgresql > start) and on stop. W

Re: postgresql problem? : etch

Hello *, Am 2007-04-25 14:05:13, schrieb Andrea S. Gozzi: > On Wed, 2007-04-25 at 16:46 +0530, Erle Pereira wrote: > > these are the two commands I had to use. > > > > as "postgres" user > > 1. /usr/lib/postgresql/7.4/bin/initdb -D /var/lib/postgresql/ > > > > as root: > > 2. su -c '/usr/lib/pos

Re: postgresql problem? : etch

On Wed, 2007-04-25 at 16:46 +0530, Erle Pereira wrote: > these are the two commands I had to use. > > as "postgres" user > 1. /usr/lib/postgresql/7.4/bin/initdb -D /var/lib/postgresql/ > > as root: > 2. su -c '/usr/lib/postgresql/7.4/bin/pg_ctl -D /var/lib/postgresql/ > -l /var/lib/postgresql/log

Re: postgresql upgrade

Am 2007-04-10 05:49:31, schrieb Tom Allison: > I have a "munged" database path that i put together so that my database > could run on a software raid array (linear, and don't tell me about how > "bad" this is). > > I never got it working 100% because I kept getting an error about invalid > pidf

Re: Postgresql on Debian

Am 2007-03-19 23:58:56, schrieb Iuri Sampaio: > Hi, > > Is there any script to uninstall postgresql-8.2.3 on debian? Why not asking ? I have created my own 8.2 Debian packages since I need "table partitioning" and have not a singel problem uninstalling it... Maybe aou should read the developers

Re: Postgresql on Debian

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Roberto � wrote: > On Tue, Mar 20, 2007 at 09:40:38AM +0100, Joe Hart wrote: >> I didn't know about stow or installwatch. I always use checkinstall. >> >> It seems I learn more about Debian every day :) so many choices... >> > Ahhh, choices :-) > >

Re: Postgresql on Debian

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Roberto � wrote: > On Tue, Mar 20, 2007 at 09:40:38AM +0100, Joe Hart wrote: >> I didn't know about stow or installwatch. I always use checkinstall. >> >> It seems I learn more about Debian every day :) so many choices... >> > Ahhh, choices :-) > >

Re: Postgresql on Debian

On Tue, Mar 20, 2007 at 09:40:38AM +0100, Joe Hart wrote: > > I didn't know about stow or installwatch. I always use checkinstall. > > It seems I learn more about Debian every day :) so many choices... > Ahhh, choices :-) The checkinstall package actually depends on installwatch and uses it a

Re: Postgresql on Debian

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Roberto � wrote: > On Mon, Mar 19, 2007 at 11:58:56PM -0300, Iuri Sampaio wrote: >> Is there any script to uninstall postgresql-8.2.3 on debian? >> >> In fact, >> >> how do I uninstall anything that I installed from source? Most of the >> programs don

Re: Postgresql on Debian

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 03/19/07 21:58, Iuri Sampaio wrote: > Hi, > > > > Is there any script to uninstall postgresql-8.2.3 on debian? How did you install it? > In fact, > > how do I uninstall anything that I installed from source? Most of the > programs don?t have

Re: Postgresql on Debian

On Mon, Mar 19, 2007 at 11:58:56PM -0300, Iuri Sampaio wrote: > > Is there any script to uninstall postgresql-8.2.3 on debian? > > In fact, > > how do I uninstall anything that I installed from source? Most of the > programs don?t have a UNINSTALL file or something like UMakefile to execute > a

Re: postgresql database file names

On Mon, Oct 30, 2006 at 12:34:36AM -0500, Tony Heal wrote: > For those who care. Here is how you determine the disk space used for each > postgresql db. > Neat. Thanks for the info. Regards, -Roberto -- Roberto C. Sanchez http://people.connexer.com/~roberto http://www.connexer.com -- To UN

RE: postgresql database file names

For those who care. Here is how you determine the disk space used for each postgresql db. #!/bin/bash # scan the list of databases and provide the disk space used in human readable form dbs=`psql template1 -tc "select datname from pg_database"|sed s/" "/""/g` for i in $dbs do oid=`psql template

Re: postgresql database file names

On Sun, Oct 29, 2006 at 12:18:54PM -0500, Tony Heal wrote: > OK, how do you determine the disk size of a database. I have a var partition > that is at 90% capacity and growing, and there are some databases I can > remove, but it would be easier if I knew which DB's were taking up what disk > space.

Re: postgresql database file names

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/29/06 11:18, Tony Heal wrote: > OK, how do you determine the disk size of a database. I have a var partition > that is at 90% capacity and growing, and there are some databases I can > remove, but it would be easier if I knew which DB's were taki

Re: postgresql database file names

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/29/06 14:07, Steve Kemp wrote: > On Sun, Oct 29, 2006 at 03:00:38PM -0500, Roberto C. Sanchez wrote: > >>> [EMAIL PROTECTED]:~# du --summarize --human-readable /var/lib/mysql/* > >> He is working with PostgreSQL. > > True, but I figured th

  1   2   3   4   >