On Saturday 29 Jul 2017 10:59:39 Mick wrote:
> It seems this is one of these things I keep forgetting how to perform
> correctly, despite taking notes and reading the documentation. I thought I
> had upgraded postgresql from 9.5.7 to 9.6.3-r1 a couple of weeks ago.
>
> Today depcl
Longer answer (as promised)
On Saturday, May 21, 2016 04:56:18 PM waltd...@waltdnes.org wrote:
> On Sat, May 21, 2016 at 08:55:39AM +0200, J. Roeleveld wrote
> > Did you run
> > emerge --config dev-db/postgresql:9.5
>
> Yes.
>
> > succesfully?
>
>
It seems this is one of these things I keep forgetting how to perform
correctly, despite taking notes and reading the documentation. I thought I
had upgraded postgresql from 9.5.7 to 9.6.3-r1 a couple of weeks ago.
Today depclean asked me to remove 9.5.7 and after a moment's hesitation I
I want to install PostgreSQL but I'm wondering which package to use.
The obvious choice (dev-db/postgresql) installs 8.2.7 but
dev-db/postgresql-server installs 8.3.5. (I see they even use the same
tarball.) Is postgresql-server is the proper way going forward?
What about virtual/postg
On 29/07/2017 11:59, Mick wrote:
> It seems this is one of these things I keep forgetting how to perform
> correctly, despite taking notes and reading the documentation. I thought I
> had upgraded postgresql from 9.5.7 to 9.6.3-r1 a couple of weeks ago.
>
> Today depclean ask
:05 +, Neil Bothwick wrote:
> >>>> On Wed, 8 Feb 2017 22:52:51 +0100, Bertram Scharpf wrote:
> >>>>
> >>>>> Every time I try to do an upgrade, it wants to pull
> >>>>> in the former PostgreSQL into an own slot:
> >>>>
On Sat, May 21, 2016 at 08:55:39AM +0200, J. Roeleveld wrote
> Longer answer:
>
> On Friday, May 20, 2016 10:36:41 PM waltd...@waltdnes.org wrote:
> > Yes, I did RTFM at https://wiki.gentoo.org/wiki/PostgreSQL/QuickStart
> > and that's part of my problem. I fi
On Sunday 21 December 2008 23:45:33 Hilco Wijbenga wrote:
> I want to install PostgreSQL but I'm wondering which package to use.
> The obvious choice (dev-db/postgresql) installs 8.2.7 but
> dev-db/postgresql-server installs 8.3.5. (I see they even use the same
> tarball.) Is pos
Hello!
I try to install postgresql and according to the gentoo howto after the emerge
I execute the followning command and get this error:
# emerge --config =postgresql-8.0.12
Configuring pkg...
* Creating the data directory ...
* Initializing the database ...
QA Notice: USE Flag
Hi there,
For the longest time I've had PostgreSQL server installed on one of my
systems. I update world every month or two and today `emerge -upv
world` shows this blocker:
...
[ebuild U ] app-admin/sudo-1.7.2_p1 [1.7.1-r1] USE="offensive pam -
ldap (-selinux) -skey"
On 10/03/2009 01:59 PM, Stroller wrote:
Hi there,
For the longest time I've had PostgreSQL server installed on one of my
systems. I update world every month or two and today `emerge -upv world`
shows this blocker:
...
('ebuild', '/', 'dev-db/postgresql-base-
On May 21, 2016 10:56:18 PM GMT+02:00, waltd...@waltdnes.org wrote:
>On Sat, May 21, 2016 at 08:55:39AM +0200, J. Roeleveld wrote
>> Longer answer:
>>
>> On Friday, May 20, 2016 10:36:41 PM waltd...@waltdnes.org wrote:
>> > Yes, I did RTFM at
>https://wiki.gent
After upgrade when I try to start postgresql I get error:
/etc/init.d/postgresql-9.1 start
* Starting PostgreSQL ...
* start-stop-daemon: did not create a valid pid in
`/var/lib/postgresql/9.1/data/postmaster.pid'
* Check the log for a possible explanation of the above error.
* /va
I tried to activate PostgreSQL native replication, but after emerging
postgresql and pgperl i found out that the following files (which are needed
to get the job done) were missing:
/usr/bin/DBMirror.pl
/usr/lib/postgresql/pending.so
/usr/share/postgresql/contrib/AddTrigger.sql
/usr/share
After upgrade when I try to start postgresql-9.1 I get an error:
* Starting PostgreSQL ...
* start-stop-daemon: did not create a valid pid in
`/var/lib/postgresql/9.1/data/postmaster.pid'
* Check the log for a possible explanation of the above error.
* /var/lib/postgresql/9.1
Hi to all,
I'm setting up a new server for developing database-based applications.
So, I emerged PostgreSQL, but the problem comes when I try to
configure Postgre, this is what I get:
-
# emerge postgresql --config
Configurin
On 4 Oct 2009, at 08:40, Justin wrote:
Stroller wrote:
Hi there,
!!! The following installed packages are masked:
- dev-db/postgresql-8.1.11 (masked by: package.mask)
/usr/portage/profiles/package.mask:
# Patrick Lauer (03 Oct 2009)
# Mask unsupported and obsolete postgres packages
# Use
On Monday, September 15, 2014 08:48:16 AM Joseph wrote:
> After upgrade when I try to start postgresql-9.1 I get an error:
>
> * Starting PostgreSQL ...
> * start-stop-daemon: did not create a valid pid in
> `/var/lib/postgresql/9.1/data/postmaster.pid' * Check the
On 10/27/06, Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
> The source directory should point to...well...the package sources.
> That is, wherever you extracted the sources to. Pointing them to
> /usr/lib/postgresql is only valid if you extracted the sources there.
> If you
On Nov 13, 2011 12:35 PM, "Michael George" wrote:
>
> I am trying to upgrade my postgresql server from 9.0 to 9.1. I've
> installed 9.1.1 and used eselect to make it the slot to run for the
> system.
>
> When I run:
> pg_upgrade -v --check -d /var/lib
Longer answer:
On Friday, May 20, 2016 10:36:41 PM waltd...@waltdnes.org wrote:
> Yes, I did RTFM at https://wiki.gentoo.org/wiki/PostgreSQL/QuickStart
> and that's part of my problem. I figured it would be a simple
> search and replace "9.3" ==> "9.5" in
In linux.gentoo.user, you wrote:
> On 12/05/11 13:37, Gregory Shearman wrote:
>>In linux.gentoo.user, Joseph wrote:
>>> I'm upgrading form posgresql 9.0 to 9.1, it seem to the upgrade went OK but
>>> when try to transfer the data
>>> base:
>>> pg_
On 09/15/14 08:48, Joseph wrote:
After upgrade when I try to start postgresql-9.1 I get an error:
* Starting PostgreSQL ...
* start-stop-daemon: did not create a valid pid in
`/var/lib/postgresql/9.1/data/postmaster.pid'
* Check the log for a possible explanation of the above error.
*
On 29 July 2017 at 11:12, Alan McKinnon wrote:
> On 29/07/2017 11:59, Mick wrote:
> > It seems this is one of these things I keep forgetting how to perform
> > correctly, despite taking notes and reading the documentation. I
> thought I
> > had upgraded postgresql
Yes, I did RTFM at https://wiki.gentoo.org/wiki/PostgreSQL/QuickStart
and that's part of my problem. I figured it would be a simple
search and replace "9.3" ==> "9.5" in the wiki, but...
1) The wiki recommends...
PG_INITDB_OPTS="--locale=en_US.UTF-8"
.
On Monday 22 December 2008 00:07:01 Graham Murray wrote:
> Alan McKinnon writes:
> > postgresql-server is not something new, it's a new way of packaging an
> > existing product. It's like the monolithic/split KDE ebuilds, the new
> > split postgresql packages make
I am trying to upgrade my postgresql server from 9.0 to 9.1. I've
installed 9.1.1 and used eselect to make it the slot to run for the
system.
When I run:
pg_upgrade -v --check -d /var/lib/postgresql/9.0/data -D \
/var/lib/postgresql/9.1/data -b /usr/lib64/postgresql-9.0/bin -B \
/usr/
On 06/09/14 22:08, Joseph wrote:
After upgrade when I try to start postgresql I get error:
/etc/init.d/postgresql-9.1 start
* Starting PostgreSQL ...
* start-stop-daemon: did not create a valid pid in
`/var/lib/postgresql/9.1/data/postmaster.pid'
* Check the log for a possible explanati
On Mon, April 23, 2012 3:21 pm, nap...@squareownz.org wrote:
> I'm unsure if I should be posting this to the -hardened mailing list as
> I'm using the hardened profile but all of a sudden I'm getting a rather
> strange error when trying to start postgres.
>
> # /e
Hello,
I'm using Courier-IMAP, Courier-Auth, Postfix+SASL and storing users in
a PostgreSQL database. My database is on another machine so I don't
think I should have to install dev-db/postgresql but I must for some
reason.
I can see that the packages need postgresql
lithium ~ #
ust
>>>
>>> anything else is commented out. I restarted the server but I still can
>>> connect to postgresql from another computer via Firefox.
>>
>>Joseph,
>>
>>Let me put it in really simple terms:
>>1) Firefox is NOT a database client, it can N
Stroller wrote:
>
> On 4 Oct 2009, at 08:40, Justin wrote:
>> Stroller wrote:
>>> Hi there,
>>
>>> !!! The following installed packages are masked:
>>> - dev-db/postgresql-8.1.11 (masked by: package.mask)
>>> /usr/portage/profiles/packa
Alan McKinnon writes:
> postgresql-server is not something new, it's a new way of packaging an
> existing product. It's like the monolithic/split KDE ebuilds, the new split
> postgresql packages make the dev's life easier, and make it possible for you
> to make more
Stroller wrote:
> Hi there,
> !!! The following installed packages are masked:
> - dev-db/postgresql-8.1.11 (masked by: package.mask)
> /usr/portage/profiles/package.mask:
> # Patrick Lauer (03 Oct 2009)
> # Mask unsupported and obsolete postgres packages
> # Use postgresql-
I'm unsure if I should be posting this to the -hardened mailing list as
I'm using the hardened profile but all of a sudden I'm getting a rather
strange error when trying to start postgres.
# /etc/init.d/postgresql-9.1 start
* Caching servi
will be), since
libpq (<=8.0.8) is still buggy/incomplete (missing pg_config), so
some packages may still need postgresql for building (not runtime).
I supplied fixed ebuild to the -dev, but they told me they don't
see what I'm fixing ;-o
Well, this issue is actually fixed in 8.0.9
On May 21, 2016 4:36:41 AM GMT+02:00, waltd...@waltdnes.org wrote:
> Yes, I did RTFM at https://wiki.gentoo.org/wiki/PostgreSQL/QuickStart
>and that's part of my problem. I figured it would be a simple
>search and replace "9.3" ==> "9.5" in the w
> Ah, yes, portage will remove postgresql sources after building. So
> you'll need to re-create the sources. Probably the easiest thing to
> do is:
>
> # ebuild /usr/portage/dev-db/postgresql/postgresql-.ebuild unpack
>
> Then set the source directory to
> /var/
On Tue, 2007-10-16 at 11:53 -0300, Rafael Barrera Oro wrote:
> I unmerged postgresql 8.0.3 in order to emerge 8.2.x, now when i try
> to do anything i get the following message:
>
> psql: FATAL: database files are incompatible with server
> DETAIL: The data directory was
e /dev \
--exclude /proc \
--exclude /tmp \
--exclude /var/tmp \
--exclude /var/cache/squid/ \
--exclude /var/lib/mysql/ \
--exclude /var/lib/postgresql/data/base/ \
--exclude /var/lib/postgresql/data/global/ \
--exclude /var/lib/postgresql/data/pg_clog/ \
--exclude /var/lib/postgresq
hi,
my system is gentoo amd64, postgresql 8.2.14. the postgresql service
can start without any error; but when i try to stop it, it reports
failure. the process of postgresql are actually terminated. if i try
to stop the service again, i got
"start-stop-daemon: fopen `/var/lib/postgresql
On 04/23/12 09:21, nap...@squareownz.org wrote:
> I'm unsure if I should be posting this to the -hardened mailing list as
> I'm using the hardened profile but all of a sudden I'm getting a rather
> strange error when trying to start postgres.
>
> # /etc/init.d/pos
On Sun, Nov 13, 2011 at 12:31:58AM -0500, Michael George wrote:
> I am trying to upgrade my postgresql server from 9.0 to 9.1. I've
> installed 9.1.1 and used eselect to make it the slot to run for the
> system.
>
> When I run:
> pg_upgrade -v --check -d /var/lib/postgres
On 04/23/13 20:10, J. Roeleveld wrote:
[snip]
I'm using SQL-Ledger (firefox) to access the postgresql.
Brief history:
I had a problem in the past when I upgraded to posgresql-9.1, all of a
sudden I could not access the sql-ledger.
The solution was to add "postgres group" to a
Hi,
I have a running PostrgeSLQ 9.6 installed:
# equery l postgresql
* Searching for postgresql ...
[I--] [??] dev-db/postgresql-9.6.0:9.6
Every time I try to do an upgrade, it wants to pull
in the former PostgreSQL into an own slot:
# emerge -avuDN @world
...
Calculating
On Monday, June 09, 2014 10:12:25 PM Joseph wrote:
> On 06/09/14 22:08, Joseph wrote:
> >After upgrade when I try to start postgresql I get error:
> >
> >/etc/init.d/postgresql-9.1 start
> >
> > * Starting PostgreSQL ...
> > * start-stop-daemon: did
On 06/10/14 14:54, J. Roeleveld wrote:
On Monday, June 09, 2014 10:12:25 PM Joseph wrote:
On 06/09/14 22:08, Joseph wrote:
>After upgrade when I try to start postgresql I get error:
>
>/etc/init.d/postgresql-9.1 start
>
> * Starting PostgreSQL ...
> * start-stop-daemon: did
Am 30.03.2010 15:31, schrieb Xi Shen:
> hi,
>
> my system is gentoo amd64, postgresql 8.2.14. the postgresql service
> can start without any error; but when i try to stop it, it reports
> failure. the process of postgresql are actually terminated. if i try
> to stop the se
On 12/05/11 21:56, Gregory Shearman wrote:
hmmm...
Which directory are you running the command from? I ran mine from
/var/lib/postgresql which has the properties:
drwxr-xr-x 4 postgres root
I don't recall using the command "pg_upgrade91", but I see that it is a
symlink to /usr
On 04/25/13 18:57, J. Roeleveld wrote:
So pg_hba.conf only controls direct connections to postgreSQL.
Correct.
Since "apache" group is in postgres user; apache was given permission to
access the database in this case py-passing the setting in pg_hba.conf
Wrong, Postgresql does
On Wednesday 08 Feb 2017 22:52:51 Bertram Scharpf wrote:
> Hi,
>
> I have a running PostrgeSLQ 9.6 installed:
>
> # equery l postgresql
> * Searching for postgresql ...
> [I--] [??] dev-db/postgresql-9.6.0:9.6
>
> Every time I try to do an upgrade, it wa
t PG9.
Here's were I have looked for PG9 information:
/usr/share/doc/postgresql-9.0
/usr/portage/dev-db/postgresql-base/
postgresql-base-9.0.3.ebuild
Here I find this:
elog "If you need a global psqlrc-file, you can place it in:"
elog " '${ROOT}/etc/postgre
ost
>>>>> "127.0.0.1" access only.
>>>>> But to my surprise I can access my database from other machine on
>my
>>>>> network and even from another sub-network that I'm connected to
>via VPN
>>>>>
>>>>> How
On Mon, Apr 23, 2012 at 9:21 AM, wrote:
> I'm unsure if I should be posting this to the -hardened mailing list as
> I'm using the hardened profile but all of a sudden I'm getting a rather
> strange error when trying to start postgres.
>
> # /etc/init.d/postgresql-
> > strange error when trying to start postgres.
> >
> > # /etc/init.d/postgresql-9.1 start
> > * Caching service dependencies ... [
> > ok ]
> > * The following file(s) are not readable by 'postgres':
&
On 4 Oct 2009, at 16:13, Justin wrote:
I'm running x86 (NOT ~x86), and all versions of postgresql-server
are marked with a ~.
You are right but the problem should be solved 'cause it isunmasked
again.
I couldn't imagine a dev masking something where there is no stable
alternati
at 11:53 -0300, Rafael Barrera Oro wrote:
> > I unmerged postgresql 8.0.3 in order to emerge 8.2.x, now when i try
> > to do anything i get the following message:
> >
> > psql: FATAL: database files are incompatible with server
> > DETAIL: The data directory was initia
On Tue, 30 Mar 2010 21:31:50 +0800
Xi Shen wrote:
> hi,
>
> my system is gentoo amd64, postgresql 8.2.14. the postgresql service
> can start without any error; but when i try to stop it, it reports
> failure. the process of postgresql are actually terminated. if i try
> t
I'm upgrading form posgresql 9.0 to 9.1, it seem to the upgrade went OK but when try to transfer the data
base:
pg_upgrade91 -v --old-datadir=/var/lib/postgresql/9.0/data/ --new-datadir=/var/lib/postgresql/9.1/data
--old-bindir=/usr/lib/postgresql-9.0/bin/ --new-bindir=/usr/lib/postgresq
On Sunday 24 December 2006 19:37, Enrico Weigelt <[EMAIL PROTECTED]> wrote
about 'Re: [gentoo-user] Wrong dependencies to postgresql':
First of all, thanks for responding, I was afraid we had lost another savvy
bugzilla user to the lack of (or discontent with) response from
In linux.gentoo.user, you wrote:
> On 12/05/11 21:56, Gregory Shearman wrote:
>>hmmm...
>>
>>Which directory are you running the command from? I ran mine from
>>/var/lib/postgresql which has the properties:
>>
>>drwxr-xr-x 4 postgres root
>>
>>I d
Am Samstag 03 Oktober 2009 22:59:15 schrieb Stroller:
> For the longest time I've had PostgreSQL server installed on one of my
> systems. I update world every month or two and today `emerge -upv
> world` shows this blocker:
Postgresql packages have been split. They are now na
On Mon, Dec 22, 2008 at 02:01:59AM +0200, Alan McKinnon wrote:
> What's the rationale behind that? I can see why someone might want two or
> more
> versions of php, python, perl or mysql.
>
> But postgresql? I can't imagine why it would be useful to the majorit
On Monday 22 December 2008 03:01:07 fe...@crowfix.com wrote:
> On Mon, Dec 22, 2008 at 02:01:59AM +0200, Alan McKinnon wrote:
> > What's the rationale behind that? I can see why someone might want two or
> > more versions of php, python, perl or mysql.
> >
> > But
On 04/25/13 09:10, J. Roeleveld wrote:
On Thu, April 25, 2013 07:48, Joseph wrote:
I just tried as you suggested, the only active line in: pg_hba.conf
local all all trust
anything else is commented out. I restarted the server but I still can
connect to postgresql from another
How this authentication/access work?
Normally that should be sufficient.
On which machine does the client-software run?
--
Joost Roeleveld
postgresql server runs on my machine but all other machines on the network
including the one on remote location that I'm connected to via VPN can
con
ing a rather
> > strange error when trying to start postgres.
> >
> > # /etc/init.d/postgresql-9.1 start
> > * Caching service dependencies ... [
> > ok ]
> > * The following file(s) are not readable by 'postgres':
&
On Thu, April 25, 2013 20:26, Joseph wrote:
> On 04/25/13 18:57, J. Roeleveld wrote:
>>> So pg_hba.conf only controls direct connections to postgreSQL.
>>
>>Correct.
>>
>>> Since "apache" group is in postgres user; apache was given permission
>&
Joost knows far more about databases than I do, so I mostly commented on
the workflow part.
On 2016-05-20 22:36, waltd...@waltdnes.org wrote:
Yes, I did RTFM at https://wiki.gentoo.org/wiki/PostgreSQL/QuickStart
and that's part of my problem. I figured it would be a simple
searc
On Tuesday 30 March 2010 15:31:50 Xi Shen wrote:
> hi,
>
> my system is gentoo amd64, postgresql 8.2.14. the postgresql service
> can start without any error; but when i try to stop it, it reports
> failure. the process of postgresql are actually terminated. if i try
> to stop
Stroller wrote:
>
> On 4 Oct 2009, at 15:54, Justin wrote:
>>> ...
>>> Did you read the part of my message where I said that:
>>>
>>>>> I'm running x86 (NOT ~x86), and all versions of postgresql-server
>>>>> are marked with
On Wed, April 24, 2013 00:16, Joseph wrote:
> On 04/23/13 20:10, J. Roeleveld wrote:
>>I am guessing Apache is running on the same machine as your Postgresql
>> server?
>>
>>In this case. The connection will always originate from localhost and
>> Postgresql i
Found it.
The clue was the libpq.so.4, which as Dirk said, was from an older
postgresql build. I wondered why my postgres kept reporting version 4
rather than the 5 I had installed, and searched the build logs. It
seems that the library information is reported by pg_config, and that
my /usr/bin
I unmerged postgresql 8.0.3 in order to emerge 8.2.x, now when i try to do
anything i get the following message:
psql: FATAL: database files are incompatible with server
DETAIL: The data directory was initialized by PostgreSQL version 8.2, which
is not compatible with this version 8.0.13.
i
hi people.
I have compile PostgreSQL satisfactorily, my doubt is when starting, it
appears the next message
highwaystar ~ # /etc/init.d/postgresql start
* Starting PostgreSQL ...
su: Authentication service cannot retrieve authentication info.
(Ignored
Javier Uribe wrote:
> hi people.
>
> I have compile PostgreSQL satisfactorily, my doubt is when starting, it
> appears the next message
>
> highwaystar ~ # /etc/init.d/postgresql start
> * Starting PostgreSQL ...
> su: Authentication service cannot retrieve authent
once it is released) and
postfixadmin for maintaining the database.
First question - I can run both mysql and postgresql at the same time,
right? I haven't found anything saying I can't, and mysql doesn't seem
to 'block' installing postgresql, so I'm guessing I can.
Hi folks,
since jakub (as always) closes all my bugs, I'll report the issue
to this list before completely giving up and never ever waste a
single second on reporting bugs ...
Lots of packages have an wrong/unnecessary dependency to
postgresql. Three cases:
a) probably traditio
>>>>> "HJ" == Helmut Jarausch writes:
HJ> Hi,
HJ> qfile doesn't find the corresponding packages all the time, e.g.
HJ> qfile /usr/bin/pq_config showed nothing, but re-installing
HJ> dev-db/postgresql-base
HJ> changed that file.
The package owners
On 4 Oct 2009, at 15:54, Justin wrote:
...
Did you read the part of my message where I said that:
I'm running x86 (NOT ~x86), and all versions of postgresql-server
are marked with a ~.
You are right but the problem should be solved 'cause it isunmasked
again.
I couldn'
On 12/05/11 13:37, Gregory Shearman wrote:
In linux.gentoo.user, Joseph wrote:
I'm upgrading form posgresql 9.0 to 9.1, it seem to the upgrade went OK but
when try to transfer the data
base:
pg_upgrade91 -v --old-datadir=/var/lib/postgresql/9.0/data/
--new-datadir=/var/lib/postgresql/9.1
On Saturday 23 December 2006 16:54, Enrico Weigelt <[EMAIL PROTECTED]> wrote
about '[gentoo-user] Wrong dependencies to postgresql':
> since jakub (as always) closes all my bugs,
Jakub is pretty bugzilla savvy, are you sure you bugs weren't closed for
valid reasons? S
i'm getting the following compile error when emerging
postgresql-base-9.0_beta2-r1:
checking thread safety of required library functions... no
configure: error: thread test program failed
This platform is not thread-safe. Check the file 'config.log' or compile
and run src/test/thr
Am Sonntag 04 Oktober 2009 07:34:24 schrieb Dirk Heinrichs:
> Am Samstag 03 Oktober 2009 22:59:15 schrieb Stroller:
> > For the longest time I've had PostgreSQL server installed on one of my
> > systems. I update world every month or two and today `emerge -upv
> >
Am Dienstag, 9. Oktober 2007 schrieb ext Rafael Barrera Oro:
> Hello, i'd like to ask you people if anyone has succeded in installing a
> postgresql version greater than 8.0.13 because i tried (unmasking by
> adding ~x86 to ACCEPT_KEYWORDS) and ran into a lot of problems. I don
On Wed, 2007-10-10 at 08:07 +0200, Dirk Heinrichs wrote:
> Am Dienstag, 9. Oktober 2007 schrieb ext Rafael Barrera Oro:
> > Hello, i'd like to ask you people if anyone has succeded in installing a
> > postgresql version greater than 8.0.13 because i tried (unmasking b
On Thu, April 25, 2013 07:48, Joseph wrote:
> I just tried as you suggested, the only active line in: pg_hba.conf
> local all all trust
>
> anything else is commented out. I restarted the server but I still can
> connect to postgresql from another computer via F
n't do anything. I'm totally at a loss here.
>>
>> Postgres should have a home directory - /var/lib/postgresql
>>
>> If you run su - postgres, this is the directory you should be in.
>>
> Ah okay, I've changed it back to this then. I do indeed ent
Hello,
I recently ran across this script: py-mysql2pgsql [1]
and this discussion on it's origin [2]. I'm keenly interested
in the recommendations of others for migrating mysql databases
to postgresql and any comments on this aforementioned script
or other methodologies
TIA,
; Postgres should have a home directory - /var/lib/postgresql
>
> If you run su - postgres, this is the directory you should be in.
>
Ah okay, I've changed it back to this then. I do indeed enter there now.
I've emerged it without threads or pam as I suspected it may have been
eithe
In linux.gentoo.user, Joseph wrote:
> I'm upgrading form posgresql 9.0 to 9.1, it seem to the upgrade went OK but
> when try to transfer the data
> base:
> pg_upgrade91 -v --old-datadir=/var/lib/postgresql/9.0/data/
> --new-datadir=/var/lib/postgresql/9.1/data
>
eased) and
postfixadmin for maintaining the database.
First question - I can run both mysql and postgresql at the same time,
right? I haven't found anything saying I can't, and mysql doesn't seem
to 'block' installing postgresql, so I'm guessing I can.
Second ques
On 2005-10-08 19:51:16 -0500 (Sat, Oct), Gabriel M. Beddingfield wrote:
> Javier Uribe wrote:
>
> > hi people.
> >
> > I have compile PostgreSQL satisfactorily, my doubt is when starting, it
> > appears the next message
> >
> > highwaystar ~ # /e
user) contains:
> Database process exited unexpectedly during initial connection!
> executable: "/usr/bin/pg_ctl"
> arguments: ("-w", "-t10", "start",
> "-D/home/poke/.local/share/akonadi/db_data")
> stdout: "waiting for server
On Fri, 2005-10-28 at 14:36 -0500, kashani wrote:
> [EMAIL PROTECTED] wrote:
> >> So if PostgreSQL server is on another machine why must I install it
> > locally for postfix/cyrus-sasl to use it? Wasn't there talk awhile ago
> > about some libpq package that should b
On 04/24/13 07:11, J. Roeleveld wrote:
On Wed, April 24, 2013 00:16, Joseph wrote:
On 04/23/13 20:10, J. Roeleveld wrote:
I am guessing Apache is running on the same machine as your Postgresql
server?
In this case. The connection will always originate from localhost and
Postgresql is
works sort of by accident. If you don't specify a username on the
command-line, psql will try to log you in to postgresql using your
system username -- "michael", for you. When you ran psql as root, it
tried to log you into postgresql as the "root" postgresql user, and he
doe
I re-emerged Aide today and saw the note about Aide making incorrect
assumptions and to run a couple of commands in PostgreSQL to correct
the database. Since I'd not had PostgreSQL installed previously, I
hadn't realized that Aide could use it as a backend, so I started
looking for info
Dirk Heinrichs wrote:
>
> It does. And if you have such things like home on NFS you need to use a real
> RDBMS anyway. Since you already have postgresql installed, just use it.
>
> Bye...
>
> Dirk
Thanks for the info. Just what, and how, does it use postgresql
Am 03.03.2011 04:55, schrieb Walter Dnes:
> Am I supposed to "emerge postgresql-server"? Any Gentoo-specific
> gotcha's that anyone's aware of? This will be on pure 64-bit
> (no-multi-lib) Intel i3 with 8 gigs of ram.
>
Yes, if you want to run a postgresq
1 - 100 of 629 matches
Mail list logo