Send netdisco-users mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/netdisco-users
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of netdisco-users digest..."
Today's Topics:
1. Importing the users table (Andy Ruhl)
2. Re: Importing the users table (Andy Ruhl)
--- Begin Message ---
I'm trying to move an active Netdisco server to another server by
moving the database.
When I try to load the database from an SQL dump, I get an error on
the users table like this:
$ psql -f users.sql
psql:users.sql:22: ERROR: value too long for type character varying(50)
CONTEXT: COPY users, line 1, column username: "user1
{CRYPT}$2a$04$eGQ68GFd.n9mSTUFFN2UOXl.9sSWJ4txFj4vKACumfRySTUFF
2017-03-17 10:09:52...."
I've tried a binary dump and restore as well with this error:
$ pg_restore users.dump.bin
pg_restore: [archiver] unsupported version (1.13) in file header
How do I get the users table moved over?
Andy
--- End Message ---
--- Begin Message ---
On Mon, Jun 10, 2019 at 7:56 AM Andy Ruhl <[email protected]> wrote:
>
> I'm trying to move an active Netdisco server to another server by
> moving the database.
>
> When I try to load the database from an SQL dump, I get an error on
> the users table like this:
>
> $ psql -f users.sql
> psql:users.sql:22: ERROR: value too long for type character varying(50)
> CONTEXT: COPY users, line 1, column username: "user1
> {CRYPT}$2a$04$eGQ68GFd.n9mSTUFFN2UOXl.9sSWJ4txFj4vKACumfRySTUFF
> 2017-03-17 10:09:52...."
>
> I've tried a binary dump and restore as well with this error:
>
> $ pg_restore users.dump.bin
> pg_restore: [archiver] unsupported version (1.13) in file header
>
> How do I get the users table moved over?
I kept playing with it and I found something that worked:
pg_dump -t users --column-inserts -h 192.168.1.3 > users.sql
psql -f users.sql
Hopefully this helps someone else.
Andy
--- End Message ---
_______________________________________________
Netdisco mailing list - Digest Mode
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users
