I am doing it right
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
Thomas F. O'Connell wrote:
Do you already have a postgres user on the system? And do you mean
that initdb is not creating a postgres user in the database?
Presumably, if run as the user that will own the server process
On Wed, 2005-07-13 at 10:24 -0700, TJ O'Donnell wrote:
> >
> > It sounds like you need to link gnova.so against the other shared
> > objects so the runtime linker can find them. For examples, see the
> > Makefiles used by contributed modules like dblink, xml2, and a few
> > others that link a
All,
I have postgreSQL 8.0 on winXP. This morning at 7:59am, the db system could
not start.
I looked at the pg_log. Started from yesterday 1:30pm, all log files have
this line:
database system was not properly shut down; automatic recovery in progress
Then, I restarted the PC several times, I di
Hi,
Having an issue with 10.4.2 at the moment when i initialize the
database no user is being created.
I have setup Postgresql 8.0.3 on 10.3 without any issue, has anyone come
accross this problem before?
---(end of broadcast)---
TIP 1: if po
Paul Tillotson <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Hardly likely, considering it's estimating only 296 rows in the subquery
>> output. My bet is that you've chosen a datatype whose comparisons are
>> not hashable (like char(n)). What is the datatype of parentid in these
>> tables, an
On Wed, Jul 20, 2005 at 08:11:46PM -0400, Paul Tillotson wrote:
> Tom Lane wrote:
> >Hardly likely, considering it's estimating only 296 rows in the subquery
> >output. My bet is that you've chosen a datatype whose comparisons are
> >not hashable (like char(n)). What is the datatype of parentid i
Tom Lane wrote:
Paul Tillotson <[EMAIL PROTECTED]> writes:
For the following query, postgres is running the IN subquery over and
over again (once for each row scanned in the parent table.)
I would have expected it to run the whole query once and create a hash
which would then be probed onc
Paul Tillotson <[EMAIL PROTECTED]> writes:
> For the following query, postgres is running the IN subquery over and
> over again (once for each row scanned in the parent table.)
> I would have expected it to run the whole query once and create a hash
> which would then be probed once for every row
For the following query, postgres is running the IN subquery over and
over again (once for each row scanned in the parent table.)
I would have expected it to run the whole query once and create a hash
which would then be probed once for every row scanned in the parent
table. I assumed that i
On Wednesday July 20 2005 1:19 pm, Ed L. wrote:
> On Wednesday July 20 2005 1:13 pm, Ed L. wrote:
> > I have a 7.4.6 db running on itanium hpux 11.23. It appears
> > a vacuum ran out of disk space:
> > 2005-07-20 13:47:43 [6161] ERROR: DBI::do failed for SQL
> > [VACUUM VERBOSE] to database cli
On Mon, Jul 18, 2005 at 09:21:31AM -0700, Akash Garg wrote:
>
> I looked in the data directory of postgres -- where else should I look for it?
Did you look everywhere beneath the data directory, or just in the
data directory itself? Released versions of PostgreSQL typically
dump core in $PGDATA/b
On Wednesday July 20 2005 1:13 pm, Ed L. wrote:
> I have a 7.4.6 db running on itanium hpux 11.23. It appears a
> vacuum ran out of disk space,
Oh, and of course, we created extra diskspace before
restarting...
Ed
>
> 2005-07-20 13:47:43 [6161] ERROR: DBI::do failed for SQL
> [VACUUM VERBOS
I have a 7.4.6 db running on itanium hpux 11.23. It appears a
vacuum ran out of disk space,
2005-07-20 13:47:43 [6161] ERROR: DBI::do failed for SQL
[VACUUM VERBOSE] to database clincomm: DBI error: PANIC:
could not write to file
"/users/postgresql-7.4.6/data/pg_xlog/xlogtemp.6178": No
Dan Armbrust wrote:
I'm trying to load some data into PostgreSQL 8.0.3, and I got the
error message "index row size 2904 exceeds btree maximum, 2713".
After a bunch of searching, I believe that I am getting this error
because a value that I am indexing is longer than ~ 1/3 of the block
size
On Wed, Jul 20, 2005 at 03:00:42PM -0300, Alejandro D. Burne wrote:
> Hi, I'll be trying to write a my first trigger which fire when an user
> makes an insert into a table; this insert records in others tables.
> But when I try to insert a record in trigger's table generate an error:
> - Syntax e
Hi, I'll be trying to write a my first trigger which fire when an user
makes an insert into a table; this insert records in others tables.
But when I try to insert a record in trigger's table generate an error:
- Syntax error near "into" in char 9. -
This is the trigger.
CREATE OR REPLACE FUNC
On Wed, Jul 20, 2005 at 16:49:26 +0200,
"Rose, Juergen" <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I'am a bit puzzled. I have a view and some delete rules defined on it. Now my
> problem is, only one gets executed (the first one) and the other ones seem
> not to be executed at all. I use a subse
What indexes are defined on both tables? Are there any triggers or
rules?
On Wed, Jul 20, 2005 at 09:50:54AM -0500, Dan Armbrust wrote:
> I have one particular insert query that is running orders of magnitude
> slower than other insert queries, and I cannot understand why.
> For example, Inserts
On Wed, Jul 20, 2005 at 02:44:19PM +1000, Ezequiel Tolnay wrote:
> Hi everyone! I'd like to post a few features I'd like to see in coming
> releases. Does anyone know about a wishlist newsgroup or web page, or
> whoat is the proper way to propose such requests?
http://www.postgresql.org/develope
That's a really good point about the create table, you can actually just
rename everything in you create table statements before you actually do
any data
import, then as long as the fields are in the same physical order(does
not matter if the names are different) you can output data from the
so
On Tue, Jul 19, 2005 at 11:51:55 -0400,
Amir Tahvildaran <[EMAIL PROTECTED]> wrote:
> Is it possible to add a custom datestyle?
>
> I am migrating from sybase to postgres and the datetime/timestamp
> formats are different, some of the existing code depends on that
> format. I thought the easi
well, you could always write a little function that would loop through
every object and then rename to lower case and replace all spaces with _
underscores. Then in your application code just rename everything
accordingly.
Once again, even if you are using M$ SQL server it would be a good ide
On Wed, Jul 20, 2005 at 12:43:48PM +0100, teknokrat wrote:
> The problem we have is that we want to migrate to postgresql from our
> current sql server db, but the problem with caps requiring quotes around
> them makes this a far from easy migration.
The rule is pretty much, either always quote
I have one particular insert query that is running orders of magnitude
slower than other insert queries, and I cannot understand why.
For example, Inserts into "conceptProperty" (detailed below) are at
least 5 times faster than inserts into "conceptPropertyMultiAttributes".
When I am running th
Hi all,
I'am a bit puzzled. I have a view and some delete rules defined on it. Now my
problem is, only one gets executed (the first one) and the other ones seem not
to be executed at all. I use a subselect within those rules (which works fine
for the first one by the way) and I wonder if this c
# [EMAIL PROTECTED] / 2005-07-20 12:43:48 +0100:
> Tony Caduto wrote:
> >The easiest solution is just not to use caps or spaces in your
> >table/object names, there is no advantage to doing so.
> >People just need to get over the fact that having caps in a name make it
> >easier to read.
> >
> >M
On Tue, 2005-07-19 at 16:31, Rob Brenart wrote:
> Richard Huxton wrote:
>
> > Rob Brenart wrote:
> >
> >> I'm running postgresql 8.0 under WindowsXP for a development box (the
> >> production server isn't up yet, and will be linux, so I don't know
> >> that the problem will travel)...
> >>
> >>
>> "open_datasync"
>
> This setting is only safe if you disable write cache.
Thanks you for explanation.
I expected that default installation does not cause data loss in any
maschine configuration.
I don't remember was write cache enabling Windows default setting or was it
set by me.
Andrus.
Am Dienstag, 19. Juli 2005 15:40 schrieb Tom Lane:
> Janning Vygen <[EMAIL PROTECTED]> writes:
> > On more related question:
> > I updated pg_trigger and pg_constraint and changed all my FK:
> >
> > UPDATE pg_trigger
> > SET
> > tgdeferrable = true,
> > tginitdeferred = true
> > WHERE tgconstrn
Hi everyone! I'd like to post a few features I'd like to see in coming
releases. Does anyone know about a wishlist newsgroup or web page, or
whoat is the proper way to propose such requests?
Thanks,
Ezequiel Tolnay
---(end of broadcast)---
TIP 2
Is it possible to add a custom datestyle?
I am migrating from sybase to postgres and the datetime/timestamp
formats are different, some of the existing code depends on that
format. I thought the easiest way would be to use a custom datestyle,
but I couldn't find out how to add one (if thats p
On Jul 20, 2005, at 5:58 AM, Dave Cramer wrote:
Hi, i have just installed 10.4 on one of our machines and cannot
get past this error during make
/usr/bin/libtool: for architecture: cputype (16777234) cpusubtype
(0) file: -lSystem is not an object file (not allowed in a library)
I
go schrieb:
> Hi, pgsql-general.
>
> Explain me please the difference between
> Vacuum full and Vacuum freeze
>
See you:
http://www.postgresql.org/docs/8.0/interactive/sql-vacuum.html
--
Mario Günterberg
mattheis. werbeagentur
IT Engineer / Projektleiter
Zillestrasse 105a. D - 10585 Berlin
Hi, pgsql-general.
Explain me please the difference between
Vacuum full and Vacuum freeze
--
Have a nice day!
go mailto:[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Tony Caduto wrote:
The easiest solution is just not to use caps or spaces in your
table/object names, there is no advantage to doing so.
People just need to get over the fact that having caps in a name make it
easier to read.
My Test Table should be my_test_table, the naming makes no differe
> > What version exactly was this? There was some changes in
> 8.0.2 in this
> > area on win32. The default sync method was also changed at
> this point.
>
> "PostgreSQL 8.0.2 on i686-pc-mingw32, compiled by GCC gcc.exe
> (GCC) 3.4.2 (mingw-special)"
There we go. That explains it - you have t
Dear developers,
I am not subsribed to the hacker's list, so I submit my request to this
list:
please update the contents dev subdirectory at the ftp server. The
snapshots therein are from mid-June, whereas the docs snapshot is recent
enough.
Thanks
Zoltan
___
> What version exactly was this? There was some changes in 8.0.2 in this
> area on win32. The default sync method was also changed at this point.
"PostgreSQL 8.0.2 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special)"
> What's the output of "show wal_sync_method"?
"open_datas
> > And do your disks honour the fsync? Was a power failure the
> cause of this?
>
>
> I have usual office PC using Quantum FireballP LM20.5 20 GB
> IDE HDD with
> XP drivers.
> How to determine is fsync working or not ?
> I use default postgres.conf file ( added only listen_addresses = '*'
On Tue, 2005-07-19 at 16:45 +, vinita bansal wrote:
> Hi,
>
> I am trying RAMFS solution with Postgres wherein I am pushing the most
> heavily used tables in RAM.
Why? I mean, what problem are you trying to solve?
> I have 32GB RAM on a 64 bit opteron machine. My database size is 40GB. I
On Wed, Jul 20, 2005 at 11:28:23AM +0200, Josef Springer wrote:
> i want to automate the startup of my database. So i have to create first
> an user and a database, second the schema, all with psql. But how can i
> create a database with psql if no database exist ?
When you first install Postgre
Jamie,
That's strange, I have 8.03 building fine on 10.4 ? Did you simply do
a make without a make clean and run configure again ?
Dave
On 20-Jul-05, at 3:37 AM, Jamie Deppeler wrote:
Hi, i have just installed 10.4 on one of our machines and cannot
get past this error during make
gcc -no
Hi,
1. connect template1 database with your user.
2. create database YOURDB
3. "\c YOURDB" will connect to new database
4. create table etc.
linimi
On 7/20/05, Josef Springer <[EMAIL PROTECTED]> wrote:
> Hi,
>
> i want to automate the startup of my database. So i have to create first
> an user
klient table has oid 66079
file 66079 size is 13 MB
in correct copy klient table file size is 5MB
it seems that other table, nomenkla oid=65783 is added to the end of
klient table.
How to repair file 66079 so that it contains only 3686 rows from beginning ?
---(end
Hi,
i want to automate the startup of my database. So i have to create first
an user and a database, second the schema, all with psql. But how can i
create a database with psql if no database exist ? Executing psql, i
must define the options for a database and an user with password.
Best Reg
It seems that corrupted table klient contains data from some other table.
select * from firma1.klient limit 3686;
Seems to return all data from table.
Starting at row 3687 table contains data from other table.
VACUUM command returns:
INFO: vacuuming "firma1.klient"
ERROR: invalid page heade
>> Today morning suddenly one table in one database, firma1.klient is
>> corrupted. When trying to backup it using pgAdmin III I get the log
>> below and backup is not created.
>
> What caused this? Presumably you had a power/system-failure or similar?
Windows XP does not respond and I pressed
Andrus wrote:
I have Postgres 8 running on Windows XP
The size of data subdirectory is 326 MB
Today morning suddenly one table in one database, firma1.klient is
corrupted. When trying to backup it using pgAdmin III I get the log below
and backup is not created.
What caused this? Presumably
Hey List,
due to the PostGIS extension PostgreSQL is THE free DBS for geospatial data.
I know of its capabilities to handle vector data and like to know if
PostgreSQL can also be used to administer geospatial raster data.
I would be thankful for any information and experiences in this field of
I have Postgres 8 running on Windows XP
The size of data subdirectory is 326 MB
Today morning suddenly one table in one database, firma1.klient is
corrupted. When trying to backup it using pgAdmin III I get the log below
and backup is not created.
I have:
1. Compressed backup of the whole dat
Hi, i have just installed 10.4 on one of our machines and cannot get
past this error during make
gcc -no-cpp-precomp -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wendif-labels -fno-strict-aliasing -dynamiclib -install_name
/usr/local/pgsql/lib/libpq.4.dylib -compatibility_version 4
-curr
51 matches
Mail list logo
