Hi Tom,
> Did you remember to start the cygipc daemon?
Yes I did. It was not that. There is something broken with cygipc or the
way I used it. ;-)
I did a complete uninstall and a re-install (using the user id 'postgres')
and I am able to create databases!
Thanks!
Now I have one more hurdle
Thanks Tom!
There seems to be something wrong with the cygipc package! I keep getting
this shmget() failure. I am pretty sure that there is enough memory on my
system. The best part is sometimes after reinstalling everything, it
sometimes works.
This is the failure message I get.
[EMAIL PROTECTED] writes:
> There seems to be something wrong with the cygipc package! I keep getting
> this shmget() failure. I am pretty sure that there is enough memory on my
> system. The best part is sometimes after reinstalling everything, it
> sometimes works.
Did you remember to start the
Title: PostgreSQL on Red Hat 8
I'm just about to install a new machine to run PostgreSQL, was going to run RedHat 8, Is anyone aware of any problems?
,
Mike Weaver
Software Developer
5, 42 Ladner Street
O'Connor, WA, 6163
All correspondence:
PO Box Y3502
East St Georges Terrace
Perth WA
Check your pg_hba.conf to make sure your allowing connections from
localhost. Also you may need to modify postgresql.conf to allow tcp/ip
socket connections as well.
Robert Treat
On Fri, 2003-01-31 at 09:42, Huub wrote:
> Hi,
>
> I had to reinstall PostgreSQL 7.3 on my RH 8.0 server. Since I ad
On Mon, 2003-02-03 at 10:39, Nigel Bishop wrote:
> Could someone please advise:
>
> I'm new to Postgres (13 years Oracle DBA experience) and I'm trying to
> understand the nature of Postgres backup/restores.
>
> An example:
>
> If I take a backup (via pg_dump) at 8pm on Wednesday and then on
Gary Stainburn <[EMAIL PROTECTED]> writes:
> How does Postgresql handle this? I would hope that it would notice the loss
> of the IP connection and close the link gracefully, and not just leave the
> connectino dangling.
The backend runs the connection with TCP_KEEPALIVE set. The kernel
should
[EMAIL PROTECTED] writes:
> ipc-daemon &
> initdb -D /usr/local/pgsql/data -U 1730 -W
> psql -U 1730 template1
If this is PG 7.3.*, there are some recently-identified problems with
using all-numeric usernames. Use a name instead of a number.
regards, tom lane
---
Title: Message
Could
someone please advise:
I'm new to
Postgres (13 years Oracle DBA experience) and I'm trying to understand the
nature of Postgres backup/restores.
An example:
If I take a
backup (via pg_dump) at 8pm on Wednesday and then on Thursday at 10am I have
some form of media
On Monday 03 February 2003 2:39 pm, you wrote:
> > Anyone know if postgres has a connections limit by default? I see a
> > connections limit in my conf file but it is commented out..Just curious
> > what the default limit is, if any.
>
> 32, compile with --with-maxbackends=N, where N is your max.
Hi,
I am new to PostgreSQL. I am running PostgreSQL on top of Cygwin on Windows
NT.
I am able to initialize the database cluster and create template1. I log in
and even create a 'test' table.
But querying it results in the error.
ERROR: pg_class_aclcheck: invalid user id 1730
Someone please hel
"Gaetano Mendola" <[EMAIL PROTECTED]> writes:
> gettimeofday({1044264831, 559402}, NULL) = 0
> setitimer(ITIMER_REAL, {it_interval={0, 0}, it_value={1, 0}},
> {it_interval={0, 0}, it_value={0, 0}}) = 0
> semop(21037068, 0xbfffed00, 1) = -1 EINTR (Interrupted system call)
> --- SIGALRM (Ala
Alexey Dashevsky <[EMAIL PROTECTED]> writes:
> From time to time I receive the message:
> "LWLockAcquire - can't wait without a proc structure.
This is fixed as of 7.2.3, IIRC.
regards, tom lane
---(end of broadcast)---
TIP
Hi folks,
This was posted to one of the redhat lists and it got me thinking.
I would imagine that there is some sort of limit otherwise stale connections
could be left hanging around forever. However, PHP supports persistant
connections where it can go days without anyone accessing a page.
On Mon, 2003-02-03 at 04:55, Aris wendy wrote:
> > You can use symbolic links, if your operating system allows them.
...
> > 4. Move the relevant directories from $PGDATA/base to the desired
> > locations on the other disks -- their parent directories should have the
> > same ownership and permissi
<[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
> are u sure VACUUM FULL is hanging?
>
> run in verbose mode...
>
> VACUUM FULL VERBOSE ANALYZE
I don't see nothing going on
> and you are really desperate get the pid of the
> backend who is doing the vacuum an
On Sun, 2 Feb 2003, Len Conrad wrote:
>
> > > Reading between the lines of the error message, it looks to me like
> > > meiway.com's mail server is programmed to take the MAIL FROM address,
> > > connect back to the sending server
>
> Wrong, but it's a fully understandable error when firing from
Hi all,
I'm running postgresql 7.2.1(linux kernel 2.4.20).
RAID5 4 x 20G, 2G RAM, two Xeon.
/proc/sysctl.conf
kernel.shmall = 67108864
kernel.shmmax = 67108864
/opt/pgsql/data/postgresql.conf
shared_buffers = 4096
max_lock_per_transaction = 128
effective_c
18 matches
Mail list logo
