...and on Fri, Jun 18, 2004 at 08:16:36PM -0300, Elielson Fontanezi used the keyboard:
> Hi folks!
>
> I would like to know if there is someway to
> interface mssqlserver with pgsql such that
> sqlserver can understand the pgsql encoding.
>
> Thanx a lot!
Hi Elielson,
I know of no pro
What version of postgres did you install? If it is 7.4.2 or later then
you must install the cygserver package and start that. ipc-daemon2 is
not being used anymore.
Mike
On Wed, 2004-06-16 at 08:00, Harry wrote:
> Hi all,
>I install cygwin in my windows2000 so as to install postgresql. When
...and on Sun, Jun 20, 2004 at 07:50:53PM -0700, Adam Smith used the keyboard:
> I have posted this and similar questions repeatedly and can't even raise
> a single response. I am being led to believe that this then 'Must be a
> stupid question' although people say that there is no stupid questio
On Sun, Jun 20, 2004 at 07:50:53PM -0700, Adam Smith wrote:
> I am attempting an install of 7.4.3 on FreeBSD O/S 4.9, apparently
> remnants of 7.3.x are scattered around on the disk from (a) previous
> ports installation, causing mutex_lock/unlock, libpq.so and other
> installation problems. I w
Do you know how it was originally installed? RPM or compiled source?
Are you also transferring data from 7.3 to 7.4?
Mike
>
> RPM can be
> On Sun, 2004-06-20 at 21:50, Adam Smith wrote:
> > I have posted this and similar questions repeatedly and can't even raise
> > a single response. I am be
I have posted this and similar questions repeatedly and can't even raise
a single response. I am being led to believe that this then 'Must be a
stupid question' although people say that there is no stupid question.
Is that another for political correctness
I am attempting an install of 7.4.3 on
Frederic,
since I had the need for something anywhere available I've written
a tiny Perl script which I put online:
http://www.infocopter.com/know-how/postgres-tool.htm
For more complex needs I recommend the following GUI tool:
http://www.pgadmin.org/
pgAdmin III is a powerful administration a
There is some information on www.varlena.com I think it may have been Scott
who wrote the article that I'm thinking about. There is other information
about, your best bet may be google.
Regards
Iain
- Original Message -
From: "C. Bensend" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent:
On Sun, 2004-06-20 at 11:27 -0400, Frederic Medery wrote:
> Hello,
>
> Do you know a good postgresql database schema generator ?
dia+tedia2sql
google for URLs
--
Marius Andreiana
Galuna - Solutii Linux in Romania
http://www.galuna.ro
---(end of broadcast)
Dear Janio ,
checking for a BSD-compatible install... /usr/bin/ginstall -c
checking whether build environment is sane... configure: error: newly
created file is older than distributed files!
Check your system clock
"Check your system clock" check this
Or your bison tarball is older than the alre
Dear Janio ,
checking for tar... /bin/tar
checking for strip... strip
checking whether it is possible to strip libraries... yes
checking for bison... bison -y
*** The installed version of Bison is too old. PostgreSQL needs
*** Bison version 1.875 or later.
Upgrade your Bison and make Packages
Ho
Hi,
I am trying install the postgresql-7.4.3 simple
installation. I did ./configure command at the postgresql directory source.
While the configuring proccess I receiving the follow message:
checking for tar... /bin/tarchecking for
strip... stripchecking whether it is possible to strip li
Hello,
Do you know a good postgresql database schema generator ?
Does not have to be free or open source.
Thanks !!!
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
On Fri, Jun 18, 2004 at 16:42:18 -0700,
Chris Fjell <[EMAIL PROTECTED]> wrote:
> Can a database system be restored just from the data under the
> installation directory?
Only if the postmaster has been shut down. For live backups you should
be using pg_dumpall.
---(end
Sandro Ribeiro - Claro RS - <[EMAIL PROTECTED]> writes:
> My server is working with pgsql 7.4.2 and Unix Solaris 8.
> [ this pg_hba.conf line doesn't work: ]
> hostall all 127.0.0.1 255.255.255.255 trust
We've seen some reports suggesting that Solaris has a problem wi
[EMAIL PROTECTED] (Reto) writes:
> I've run postmaster with the highest
> possible debug level but the SQL statements are not being logged yet
You need to turn on log_statement ...
regards, tom lane
---(end of broadcast)---
Sandro Ribeiro - Claro RS - <[EMAIL PROTECTED]> wrote:
>
>
> Hello!
>
> My server is working with pgsql 7.4.2 and Unix Solaris 8. Well, when a try a
> connection from my PC to the server, using pgAdminIII, I get the message
> above. This is my pg_hba.conf file:
>
> local all all
frank wrote:
> Dear Sir:
>
> After complied my postgresql-7.4.2 with the RH-linux9 operation
> system,
>
> there showed a problem on my configure.log as the file below with
> bold type word, .
> .
> .
> configure: failed program was:
> #ifndef __cplusplus
> choke me
> #endif
As long as PostgreSQ
Harry wrote:
> creating template1 database in
> /usr/local/postgresql7.4.1/data/base/1... DEBUG:
> invoking IpcMemoryCreate(size=1081344)
> FATAL: could not create shared memory segment: Function not
> implemented DETAIL: Failed system call was shmget(key=1,
> size=1081344, 03600). DEBUG: proc_
DEBUG5 is not enough to log SQL statements
--
I've set up a courier-imap POP server authenticating against a
PostgreSQL table through authdaemond/authpgsqlrc. I can verify
courier-imap sends its SELECT statement to make a login attempt but
the POP login fail
Hi,
We are trying to install PostgreSql-7.4.2 on HPUX 11.23i. after installation
initdb fails with the following error message.
dome % ./bin/initdb -D /xxx/postgresql-7.4.2/data
./bin/initdb[127]: 1588 Killed
./bin/initdb[131]: 1589 Killed
./bin/initdb[136]: 1590 Killed
The program
/xxx/post
Title: Missing or erroneus pg_hba.conf file
Hello!
My server is working with pgsql 7.4.2 and Unix Solaris 8. Well, when a try a connection from my PC to the server, using pgAdminIII, I get the message above. This is my pg_hba.conf file:
local all all
Hi,
I use PG 7.4 and adoDB library with PHP to develop. Recently I noticed
errors were being logged in my /var/log/messages for Postgresql
errors, however, my transactions were not bombing out as expected.
A simple example:
$sql = "SELECT my_pgsql_function($x,$y)";
$db->BeginTrans();
$rs=$db->E
Hi all,
I install cygwin in my windows2000 so as to install postgresql. When I
use the postgresql installed together with cygwin, I came into this problem:
First, I run
ipc-daemon2 &
Second, when I try to initialize the database by running the following
command,
initdb -D /usr/
Dear Sir:
After complied my postgresql-7.4.2 with
the RH-linux9 operation system,
there showed a problem on my
configure.log as the file below with bold type word,
.
.
.
configure: failed program was:#ifndef
__cplusplus choke me#endif.
.
.
configure: failed program was:#line 2642
"confi
BTW: Forgot to mention FreeBSD 4.9 O?S
Adam Smith wrote:
Installation of 7.4.2, even with just ./configure : gmake step ==>
_
gmake[4]: Leaving directory
`/usr/home/smith/Temp_holding/staging-area/postgresql/postgresql-7.4.2/src/backend/parser'
gcc
On Thu, 2004-06-17 at 09:57, C. Bensend wrote:
> > The problem here isn't pg_autovacuum, but too small of settings for
> > fsm. I've run multi-day tests where autovacuum kept the size of the
> > database pretty much the same with 200+ updates a second going on.
>
> Hi Scott,
>
>Could you exp
Hello,
I am using krb5 authorization and have a problem with the mangling of krb5
principal names. E.g. on authentication, the principals 'foo/[EMAIL PROTECTED]'
and 'foo/[EMAIL PROTECTED]' will be both rewritten to the local username 'foo',
which is completely unwanted and might be a security pro
Hi
folks!
I
would like to know if there is someway to
interface mssqlserver
with pgsql such that
sqlserver can understand
the pgsql encoding.
Thanx
a lot!
>\\\!/< 55 11 5080
9258
!_"""_! Elielson
Fontanezi
Attempting a FreeBSD install of 7.4.3, apparently remnants of 7.3.x are
scattered around on the disk from (a) previous ports installation,
causing mutex_lock/unlock, libpq.so and other installation problems. How
do I know what, & where all these fragments are located or how do I
uninstall all o
I am attempting an install of 7.4.3 on FreeBSD O/S 4.9, apparently
remnants of 7.3.x are scattered around on the disk from (a) previous
ports installation, causing mutex_lock/unlock, libpq.so and other
installation problems. I want to reconfigure and reinstall. How do I
know what, & where all t
Hi all,
When I try to run 'initdb' in a cygwin environment, I got this output:
$ /usr/local/postgresql7.4.1/bin/initdb -d -D
/usr/local/postgresql7.4.1/data
Running in debug mode.
initdb: internal variables:
PGDATA=/usr/local/postgresql7.4.1/data
datadir=/usr/local/postgresql7.4.1/share
Tom, David,
thanks for the hints. Following you, I have upgraded to 7.3.4 (the last
version for which an RPM by Red Hat is provided) and the problem seems
gone now.
Regards,
Jochen
On Fr, 2004-06-18 at 17:22, Tom Lane wrote:
> "David F. Skoll" <[EMAIL PROTECTED]> writes:
> > Hi, Jochen.
> >>
Hi,
we are running the CanIt mailscanner on some machine. (See
http://www.canit.ca .) This application is based on postgresql.
However, we frequently observe the following message in the log files:
PGRES\_FATAL_ERROR : ERROR: out of free buffers: time to abort!
Any hints what's going on? S
Can a database system be restored just from the data under the
installation directory?
I backed-up my database using "rsync /var/lib/pgsql "
Then I upgraded my rpms from 7.3.4 to 7.4. Then I tried to start the
server as usual and it complained about version conflict (of course).
I removed the 7
Installation of 7.4.2, even with just ./configure : gmake step ==>
_
gmake[4]: Leaving directory
`/usr/home/smith/Temp_holding/staging-area/postgresql/postgresql-7.4.2/src/backend/parser'
gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes
-Wmi
36 matches
Mail list logo
