Dear all,
I've got an old 7.2.4 DB which I hoped to upgrade to 7.4.1.
The old syntax used for creating tables had lines like
..
id integer DEFAULT '',
which translates to this error:
pg_restore: [archiver (db)] could not execute query: ERROR: invalid
input syntax for integer: ""
I found out th
On Thu, 12 Feb 2004, Steve Crawford wrote:
> I spoke with some 3Ware reps at a trade show and they recommended
> adding the following to /etc/sysctl.conf:
> vm.max-readahead = 256
> vm.min-readahead = 128
>
> These settings take effect at boot. To change on a running system:
> echo 256 > /proc/sys
> I've got an old 7.2.4 DB which I hoped to upgrade to 7.4.1.
> The old syntax used for creating tables had lines like
> ..
> id integer DEFAULT '',
>
> which translates to this error:
>
> pg_restore: [archiver (db)] could not execute query: ERROR: invalid
> input syntax for integer: ""
>
> I foun
Hi!
I would like to create database. There are two server. But I want to
create ONE database between two server.Of course,I install
two PostgreSQL in both server. But created database is to be one.
Does anyone know how to create one database beyond two server?
Regards,
Hiro
--
Hello. this is my "first" time using pgsql, and I seem to be running to
a bit of a corner here :-)
I've understood how to add a superuser/database-user/user but I have no
user to begin with.
~# createuser superuser
Shall the new user be allowed to create databases? (y/n) y
Shall the new user be
I don't know of any complete list, but I'm sure that there are some clues in
the changelogs.
In the meantime... I'd like to throw in one "gotcha" that set me back some time
when I recently upgraded from 7.2 to 7.4 : You could never use aggregates in
where clauses before. That's what HAVING is fo
kaolin fire wrote:
try user 'pgsql' :) that's the default initially created superuser, no
password (it would be good to give it one).
-kaolin fire
-http://erif.org/code/fallingup/ for a 'spin' on tetris
That was a quick response :-)
using a clean pg_hba.conf file (no user lines added), this is
Pedro Almeida wrote:
> So I need someway to add a user so I can add others.
There should be a predefined user named "postgres".
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Pedro Almeida írta:
| kaolin fire wrote:
|
|> try user 'pgsql' :) that's the default initially created superuser, no
|> password (it would be good to give it one).
|>
|> -kaolin fire
|> -http://erif.org/code/fallingup/ for a 'spin' on tetris
|>
|>
| Tha
That was it - user 'postgres', owner of postmaster, has got what it takes.
Thank you for solving my problem and giving me some extra tips to work on.
I will now continue lurking on the ML and watching closely your
discussions. Good bye then :-)
---(end of broadcast)---
I am trying to get PostgreSQL 7.4.1 to make with Mac OS 10.3 I run
configure which complains about readline. I'm not sure how Apple
compiled bash which is the new default shell but I can't find the
library or headers either. I have installed Xcode and found a few
notes online about postgres 7
Kevin,
The /sw directory is created by fink (http://fink.sourceforge.net/)
which you may want to install. It's a debian-ish packaging system
designed for bringing open-source programs to Mac OS X. I believe
PostgreSQL is available as a fink package as well, but it may not be
recent. Readlin
What's the purpose of doing this? Failover? Spread out CPU processing?
Why would you want to do this?
> On Mon, 2004-02-16 at 11:17, Hiro wrote:
> > Hi!
> >
> >
> > I would like to create database. There are two server. But I want to
> > create ONE database between two server.Of course,I
Hi,
I'm trying to restore two dumps, one from 7.1.3 and the other from a 6.5.3
series PgSQL server. These dumps were both made using standard 'pg_dump >
output' commands (specifying the host where needed on one of them). When I
run the database restore by doing execute-file in psql, piping th
14 matches
Mail list logo